Discussion Forums

Hi All,When providing service, technicians must answer a set of questions regarding the equipment's condition or the service provided.Once completed, the answers will be sent to the customer as a reportI have seen some posts about the Acumatica Survey. However, this feature has been built like a form, that will be sent out to collect feedback and it doesn't work for people using Field Service.So I question how the other companies are using the Field Service Feature facing this issue.Are there any solutions for the Field Service Survey? because this is not a special business process.Best regards,Yên Chi 

Hello everyone,We recently upgraded to 2025 R2 and one of our Import Scenarios is now throwing errors.  Here is the main one:  The Import Scenario is Deleting the Salesperson from each location in preparation for adding the new person in a second scenario.I went to the Customer and every aspect is filled out correctly.  Nothing in the error message is empty for the Customer.  Do we need to add all of those fields now to each Import Scenario???  I have attached the file to this post.  

Hello,I have a user that works hand in hand with our Marketing Manager. She currently has a delegate mailbox of his. Most of the marketing leads come in through his inbox, not hers. While he has the plug in, it is her responsibility to create the leads. Can the plugin work on delegate mailboxes? Say an email comes in to his mailbox, she sees it, can she create a lead using the app? Currently if she tries, the app doesn’t show up.Also, a lot of these emails come in with a list of recipients. Can more recipients be pulled in than just the email author? So, if an email comes in from ABC company, can the author, Mark be pulled in as a lead as well as Judy who was CC’d. Or will Judy have to be done manually? Thank you,Brent  

We plan on using the Time and Material billing rule in the near future for our Cost+ projects. We already set up everything (billing rule, rate tables, etc.). After doing some testing, I find it takes a lot of time to create a pro forma invoice.My question is : Do you have any tips to make it more efficient, since we expect a very high volume of transactions? (+/- 500 cost transactions per pro forma invoice)In the “Time and material” tab of the pro forma, is there any way to select multiple lines at once? (either to delete them or to change their statut to “write-off”?)   I notice that we can “Export to Excel” the transactions from the “Time and material” tab of the proforma. I was hoping we could extract the datas in Excel and upload it back after making some changes (for exa

We are trying to import the PI inventory counts from excel and receiving an error.  Steps takenExport the list with the Excel button. Enter the Physical Quantities in the the column for Physical Quantities in the excel.  Save excel and click upload.  There is only the one column to update.  Expected this to be “easy”Dont know how to find the Trace in the error message to try to identify the error. 

Hi,I am working on import purchase order receipt type transfer receipt which is triggered by record change on Business Event. But, I can’t apply field locations of receipt lines with the same value, just line nbr 1 is applied. I don’t know if there is something wrong with my import mapping.  

Can someone support me by providing a copy of the Acumatica installer version 2020 R2 20.207.0012, it is no longer available in the download repository on Amazon

Hello,We sale our items both singularly and in master packs. I have identified and converted the qty of EA into CS (master pack). I have created a custom label that prints out master pack barcodes but am having troubles in report designer for barcode selection. Each stock item has 2 barcodes, one with the UOM of EA and one with the UOM of CS. I want this report to only show CS barcodes, so I used a filter to only show barcodes that have a CS as a UOM, but it is not displaying any data with this filter. Any ideas how to display on the barcodes with CS as the UOM? 

I’m encountering an issue when creating a PO from the Inventory Planning Display screen. The demand is being generated for a specific Project. However, when the PO is created from the Planning screen, the Project field on the PO is defaulting to Project X instead of inheriting the actual Project associated with the demand.I’m trying to understand whether this behavior is driven by system setup/configuration or standard Acumatica functionality.Is there any setup or configuration that can prevent the PO from defaulting to Project X and instead carry over the correct Project from the originating demand? 

In my code below, the commented out loggedUserRow line uses an obsolete method.  I tried to implement the ICurrentUserInformationProvider to get the User ID.  When the code runs, the _currentUserInformationProvider variable is null.  I’m not sure what I need to do to instantiate the variable.  This is probably a c# thing.  I tried a bunch of things not shown here, but I couldn’t figure out how to implement that interface.   public ICurrentUserInformationProvider _currentUserInformationProvider { get; set; } #region Events protected virtual void _(Events.FieldUpdated<SOLine, SOLine.inventoryID> e) { if (e.Row == null) { return; } SOLine lineRow = (SOLine)e.Row; //Users loggedUserRow = Users.PK.Find(this.Base, PXAccess.GetUserID()); System.Guid? u = _currentUserInformationPr

 In December, I identified discrepancies in my historical inventory valuation report. I was able to isolate the specific transactions causing the issue; however, I require guidance on how to properly resolve it.The issue appears to have originated from the following sequence of events:A purchase order was created, and the items were subsequently received into inventory in November. Upon receipt, the Inventory account was debited and the Inventory Purchase Accrual account was credited. The customer was then billed in December, resulting in a debit to Accounts Receivable and a credit to Revenue. After billing, the inventory was allocated to the job, at which point Inventory was credited and Cost of Sales was debited.For this particular item, the historical inventory valuation report reflects a beginning cost, which is the correct value, followed by a sale amount that is double the beginning value, ultimately resulting in a negative inventory balance.  I don

Hi,I need to overload confirmshipment action in acumatica 2025 R2. In 2024 version I used such codepublic class SOShipmentEntry_Extension : PXGraphExtension<PX.Objects.SO.SOShipmentEntry>{public delegate IEnumerable ConfirmShipmentActionDelegate(PXAdapter adapter);[PXOverride]public virtual IEnumerable ConfirmShipmentAction(PXAdapter adapter, ConfirmShipmentActionDelegate handler) {}}but in 2025 R2 acumatica I got this error.The System.Collections.IEnumerable ConfirmShipment(PX.Data.PXAdapter, ConfirmShipmentActionDelegate) method in the ClaLimitInvTiger25.ClaConfirmShipmentExtension graph extension is marked as [PXOverride], but no original method with this name has been found in PXGraph. I looked over the code and found they moved to cofirm shipment action into ConfirmShipmentExtension.cs file. I also tried to overl

Here are the relevant fields [ToDate] +1 logic doesn’t work on report designer ,Any workaround.

Has anyone been able to get this integration to work?I have exported the report (Excel (Connected), but when opening the exported file, there are no values and no connection has been set up. Are there additional steps one should follow to get this to work?

Hello everyone,I’m trying to calculate the selling price of my stock items (IN202500) using LLM prompts.Specifically, I want to multiply the field AvgCost (INItemCost) by a factor of 1.72, which accounts for the following costs: 10% Storage costs 2% Transport costs 20% Personnel costs 5% Marketing costs 5% Miscellaneous costs 30% Profit margin Unfortunately, I’m struggling to get the correct price calculated. Do you have any tips or advice?Here’s one of my test prompts: ## Context InstructionsYou are an AI assistant working with ERP data.## Instructions with Input DataCalculate the field ((InventoryItemCurySettings.BasePrice)) based on the following input data and formula.Input Data:- Average Cost: $((INItemCost.AvgCost))Calculation formula:BasePrice = AvgCost × (1 + 0.10 + 0.02 + 0.20 + 0.0

We have an instance where an inventory item with a $0 cost was sold then returned. Unfortunately, on the return, the cost defaulted to the most recent sale price and the item was brought back in with a cost. This caused negative COGS and increased inventory value when it shouldn’t have. This item has since been re-sold so I can’t just use the “Issue” and “Receive” processes to remove it from inventory and bring it back at the correct cost.Is there any way to correct the cost on this item?Item costing is specific to the item. I tried using the “Adjustments” but it insists on changing the quantity as well as value.

I created a GI that pulls data from a custom table.  The GI is working perfectly.  I want to add a filter to the GI so that I can use the filter in the Mobile App.  The GI is working in the Mobile App.When I go to the Parameters tab in the GI, there are no fields available to select:Here are some print screens of the GI in case anything looks like it is missing: This is the result of viewing the GI:

Hi Team,I hope you are doing well.I am currently looking for Trial Balance or Account Details endpoints in Acumatica ERP.We are able to successfully retrieve data for the Account Details inquiry screen. However, when attempting to filter using From Period and To Period, we are not receiving any results.Could you please assist us in understanding:If there are any specific parameters or formatting required for the period filters Or if there are any limitations or additional configurations needed for this scenarioAny guidance or suggestions would be greatly appreciated.Thank you in advance for your support.

There is an older article on how to customize the home page for the Self Service Customer Portal:Technical Tuesday: Editing the Acumatica Portal Home Page | Acumatica Cloud ERPHowever, Step 2 is outdated, you can no longer change to the Classic UI. Does Anyone have an updated version of this?From the Classic UI you can:Access the Documentation Menu where you added your wiki Click the Create New Article option in the left menuI started by creating a very simple article as illustrated below.Set the access

I have a custom field called SharePoint Link on the Projects screen. It works correctly as a clickable hyperlink in the Classic UI, but when using the Modern UI, it does not behave as a Weblink, even though I have applied all the necessary changes.  

Hey, gang - not too familiar with FA’s, so if anyone can point me to whatever I missed, it would be greatly appreciated.  I’ve migrated the customer’s list of FA’s into the system (in Initialization Mode) and they are asking to dispose of some FAs in some older periods.  However, when I attempt to do this, I get the “Book Period cannot be found in the system.” error in the Disposal Period field when using a date back in 2015 (as an example). However, I do have book calendar’s set up going back to 1990.

Hello,     recently I have been testing upgrading an instance from 2024r2 to 2025r2 directly. I have met some issues which I have never met before during other version upgrades. So I am writing this down here for others' reference, and also hope experts can help check whether my solutions are right or wrong. Issue 1:Inner Exception:A default full-text catalog does not exist in database 'xxx' or user does not have permission to perform this action.Query in question:exec pp_EnableFullTextSolution: I found a catalog named "ft" already exists but with default=0, then I altered the "ft" default to 1. Rerun the wizard, the error disappeared. Issue 2:An exception occurred during migrations of web.config. Please contact your Acumatica support provider.Solution: I rerun the wizard, performed the "Change Database" action

Hello :)So there are two types of ‘open’ POs: (That I use anyways)Po’s that have nothing billed against them - I can easily cancel thesePo’s that have something billed against them, but not the whole amount, so there is a remaining ‘open’ amount.The top one I can easily cancel and remove, but the second one has a partial amount remaining and I get no options to ‘cancel’ or close it: How can I close/cancel this so when I enter another invoice with a po, it doesn’t show up as an available po? Any help would be greatly appreciated b(^_^)d Thanks

We have a client who is using a third-party timecard and payroll system which utilizes Alpha-based employee IDs in these systems.  We also need to import time card data into Acumatica, but our employees are numerically assigned and have limited 7-character codes due to the BIZACCT segmented key setting.  For this reason we are using “Substitution Lists” to cross-reference the Timecard’s employee identifier with the Employee ID in Acumatica.  We are storing the timecard system’s employee ID using External Ref Nbr field in the Employee screen.In order to keep our substitution list up to date, we’re using the Employee GI as a data provider to update the GI using an import scenario.  Knowing that the substitution list will error if we try using the “=1” code for new lines, we’re using the @@OriginalValue constant to define the row key and mapping it to the Native Field [SubstitutionValues.OriginalValue].  The expectation is that the import will locate the Original Value in the gr

We are relatively new to Acumatica and would like to understand totally how the COGS labor/burden are captured throughout the manufacturing process and where/how costing is hitting the GL.  Currently what we are seeing is labor costs debiting WIP and crediting an account set up in ‘Labor Codes’ ---when the finished good product is produced, the total cost for material, labor, burden costs are crediting WIP and debiting our finished goods GL account.  The labor and overhead costs are not being posted separately or captured in a GL account.  In our previous ERP system, the labor, burden, overhead and material costs hit separate GL accounts.  We can see the amounts for Labor Planned, Labor Actual and Labor Variance amounts in the Production Order which produced the goods.  Any clarification would be most helpful.