Discussion Forums

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Arpine Arzumanyan - Acumatica Community Featured Member for July 2026Meet Arpine Arzumanyan our Acumatica Community Featured Member for July 2026. It’s great to have you as part of the Acumatica Community ​@arpine08! Introducing Beacon: Your New Knowledge DestinationOne place for everything, Personalized for you, AI-powered, More personalization comingVisit Beacon today: https://beacon.acumatica.com Acumatica User GroupsNew! Special Interest Groups:  Food Distribution Customer User Group, Nonprofit Customer User Group, Industry Groups: Construction Customer User Group, Distribution Customer User Group Request to join today!All Acumatica User Groups How to Answer Questio

Hi everyone,I’m looking for guidance from the community on a matrix item performance issue we’re encountering.BackgroundWe have a client that relies heavily on matrix items, with a single attribute (Color) that currently has 6000+ values and continues to grow. This is due to vendors introducing many unique color variations over time.ProblemWe are seeing significant performance issues when working with template items:Template screen takes a long time to load System performance degrades noticeably In some cases, the screen becomes nearly unusableIt appears the system is attempting to process a very large number of attribute values when loading the template.ConstraintBreaking the attribute into multiple attributes is not an option for this client because:It would disrupt their current product structure It would negatively impact SEO and eCommerce product organizationQuestionsHas anyone dealt with very large attribute value sets (thousands) in Acumatica? Are there any best practices for ma

For past couple of days, Acumatica portal keep on logs me out frequently. Do anyone facing the same issue? 

Hey there! I notice that when I edit a generic inquiry that is a data source for another GI, depending on the number of edits/saves I need to do sometimes the final GI starts to malfunction. Are there “best practices” for when editing a generic inquiry that is a data source for another generic inquiry? 

I tried using @columnConfig({ textAlign: TextAlign.Left }) in ts for my field, but it does not change its position.

Trying to apply updates V26.101.0225 to 26.100.0175 and receive error message: “The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.”Web.config line causing the error is: “ <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />”Here is DotNetCompilerPlatform version (Bin folder of the instance) 

I read this post I need fill parameters from POOrder.VendorID and POLine.InventoryID. But RowSelectorClick  event not callback in tracnsaction grid. Can you any idea for help me?

We want to recognize COGS at the same percentage that we recognize project revenue.For example, if 10% of the contract value is billed to the customer, then 10% of the total cost of the parts (stock items) should be  posted to COGS. This ensures that revenue and the associated costs are recognized in the same accounting period, rather than expensing all material costs upfront when they are issued to the project. Note: We have Field service and Project integration- The service order type was created for Project transactions.Has anyone implemented this type of workflow in Acumatica using standard functionality, without a customization? 

Hello all,I have been trying to delete line item from SO Line using import scenario mapping as below where I am using Line Number as the sales order has same items being used in multiple lines, hence making use of Line Nbr to delete them out, however I am unable to delete them:  What is it that i am missing out or making a mistake?

Hello all,I have a scenario where I have a GI with thousands in lines in acumatica and I would like to import those lines on automation basis. So I would like to import 100 lines under one schedule/one go. How can I do so?

Hello all,I have been working on ARM reports where I have defined my start and end fin period as the param, has YTD & PTD as columns.So if I run for a periodic range of Jan-26 till May-26 both the columns show the same values. I am unable to understand if I’m missing something in here?   Any ideas?

I’m getting the below error when trying to Close a Production Order: Error: Updating 'Production Item Split' record raised at least one error. Please review the errors.Specify the quantity greater than 0.    Which screen/section should I review to find the split line with 0 quantity? What is the recommended fix for old production orders where the split record has 0 qty (update split, clear allocation, add a completion, etc.)?

I have two reports that we use in our Acumatica  AR610000 and SO643000.   Both reports are invoices.   Both reports have the inventory item quantity, price etc in detail section1.   The reports also have detail section 2 with line item note and the SO report has detail section 3 with a product attribute.   With a goal of having the body of the invoice more readable, I enabled borders in detailsection 1 in both reports.  However, regardless of the the settings being identical, the AR report shows the borders in the report around each item and the SO report does not populate the borders.  I am stumped.  Here is an image of the control box from the AR report Detail Section1 properties from AR641000  The following is an image of the same properties box from the SO reportDetail section 1 from SO643000Here is the output from AR report AR report showing top dotted line  Here is the output from the SO report SO Report - not showing border 

Client is taking pictures of packages during the shipping process and wants to send those pictures to the customer in the shipment confirmation report.  The link between the Shipment table and the UploadFile table works fine and assume that we are only returning .jpg files.There are two fields of interest in the UploadFile table:  Name and ShortName as they display in a text field.Name field:  Sales Orders (011110) ShortName field:  receipts camera352545645 20260602T203435 522.jpgTo display the image with database as the source, I used the formula: = [UploadFile.Name] + '\\' + [UploadFile.ShortName]The issue is that it errors with:The link ‘Sales Orders (011110)\receipts camera352545645 20260602T203435 522.jpg\receipts camera352545645 20260602T203435 522.jpg’ was not an imageI can’t find anyway to get the ShortName to not repeat.  I’ve tried substring, instr, and left functions.Any ideas?

We are seeing some order are failing with the below errorThe order is missing the ship via code. Please map it with the shipping option in the store settings or specify it on the Customer Locations (AR303020) form. We would like to understand how we can pass the ship via information from shopify to Acumatica. We have all the settings in store mapping as needed but still it is failing. For failed orders we are manually updating the ship via in customer locations and has to sync. can some one help how we can get the ship via information from shopify to Acumatica? currenty the customer created with blank ship via.

Issue Description :-When converting custom screens to the Modern UI, we encounter the following error:Error: The view doesn’t exist.This happens specifically of the custom screens when clicking the Convert to Modern UI action, the system shows the error. Expected Behavior :-Instead of the error, we should be able to download the Modern UI file that corresponds to the respective custom screen.  Thank you in Advance

Hello all,I want to design a P&L based on the item class as in the below screenshot. Now the only thing I am stuck is the . Is there a way we can design the same under ARM report? If not then under my report designer how can I design to include the COGS ? Because i need to calculate cogs based on COGS account class. 

Hi everyone, I am working on a report to display the monthly General & Administrative Expenses. I was able to create the report, but it runs into an error whenever I try to run the 13th period. I tried to research why this is happening and found out that it’s because of the formulas I used to display the column headers. However, I can’t find an alternative or a solution for it. Could anyone have any idea about this? I have attached the XML file for the report. 

Hi Everyone,When attempting to use the Mass Action from the Sales Order Generic Inquiry (GI) screen to print multiple Sales Orders, the system generates the report for only a single Sales Order, even though multiple records have been selected.Could you please advise if this is expected behavior or if there is any additional configuration or customization required to enable printing multiple Sales Orders in a single operation?Thank you. 

Is there a way to restrict what subaccounts can be used based on the account class?  We use subaccounts for departmental classification.  Like many companies, we do not departmentalize our balance sheet and use 000-000 as our balance sheet class.  With that, we do not want any departmental subacounts used on balance sheet accounts and likewise, we do not want the Balance Sheet 000-000 designation used on any P&L accounts.  We have to clean this up every month because mistakes will be made.

Customer is asking to export various Acumatica entities to Salesforce using the Acumatica Data Provider.  Working with Acumatica support, we were led to believe that it was possible and that you could define the Salesforce schema objects in the data provider based on the exposed Salesforce API.  I thought we would start their first request.  Map Customers to Salesforce Accounts.  The Salesforce data provider is connected and the fill schema fields works.  The customer is using the modern UI.I created a new Export Scenario for Customers to Accounts.  On most of my initial attempts to update a single account, I kept getting an error that multiple accounts found where account = ‘’.  When I added a mapping for the Acumatica customer number to export to the Account ID field, I received the error filter error: select id from account where accountID = ‘0000002’.  Then I put the Salesforce account ID in the External Reference field of the customer and now I get The ID field should not be speci

We have a custom report used to review outstanding customer deposits. After our recent Acumatica upgrade from 24R1 to 26R1, the report began returning different results depending on the user running it.When I run the report as an administrator, the report displays the full data set correctly, including 2025 and 2026 activity. However, when our Controller runs the same report with the same parameters, the report only appears to show data from 2024 and prior. Any 2025/2026 activity is missing from his output.I initially suspected this was a security/access issue, but I have not been able to identify the cause. I checked user roles, GL access, and report access, and I also temporarily gave the Controller Administrator rights. Even with Administrator rights, the report still behaved the same way for him.A few additional notes:The issue started only after the upgrade from 24R1 to 26R1. The report is custom and is based on GLTran data. The Controller can see 2025/2026 transactions in Account

Are there any implementation/training documents in Acumatica’s open university for inventory planning? I can’t seem to find it :) 

Hello,          I am trying to write a GI to get the customer’s sold since information like the below screen.          You can find my share in the below post:     My solution almost works fine, but I find it difficult to get the “last sale qty” and “last sale price” by item using GI.     The last sales date can be got because the default aggregation is MAX, the max date is exactly the last date.      However, the max(orderqty) is not the last order qty, and also the max(unit price) is not the last unit price.     so currently, I am using the AVG unit price and Sum Order qty as a workaround, and it can be accepted by user.     But still, I am eager to learn how can I get the data using a single GI?   Thank you. 

Currently, the Acumatica FedEx Easy Post integration does not support the following FedEx label formats:4X6.75_LEADING_DOC_TAB 4X6.75_TRAILING_DOC_TABRequirement:Add support for the following label stock types in the FedEx Easy Post plugin: 4X6.75_LEADING_DOC_TAB 4X6.75_TRAILING_DOC_TAB  please guide me on how you configured it? Any details or suggestions would be greatly appreciate...