Discussion Forums

Each of my report pages is based on a single record. I’ve heard it rumored that there’s a possibility of making a variable at execution time which would record the value I’m looking for ([PMQuote.CuryAmount]) and return 1 or 0 (or True or False, etc.) when [PMQuote.CuryAmount] > 3000, and then I could use that variable (somehow? Not sure) to control whether or not my background image prints on a page.I’m new to Acumatica, so I don’t know where to start with this. Can anyone please advise me as to how I might go about doing it?

 The AR numbering sequence is currently set up to use a single sequence for invoices, credit memos, and debit memos as below; However, upon review, duplicate reference numbers were identified as outlined below: Could you please advise what may be causing these duplicates?

After upgrading to 2025 R2 Build 25.201.0213.3, we encountered a very strange issue.Within one day right after the upgrade, we accidentally found that clicking the Inventory ID in the sales order details grid had no response and triggered no error and no pop-up window displayed.We spent a lot of time troubleshooting and conducting tests in the test environment, which has been upgraded for two months and works properly.When we were at a loss, the function suddenly and miraculously returned to normal today. Clicking the Inventory ID now brings up the pop-up window as expected.We did not update the browser (both Chrome and Edge showed the same issue in previous tests), nor did we modify any line of customization code. The problem got fixed automatically out of nowhere, which is extremely weird.Does anyone know the root cause?

I am working in Acumatica Modern UI customization and I have a Smart Panel with an Upload button.  When the user clicks the Upload button, a file upload dialog (<qp-upload-dialog>) should appear.Here is the code I currently have: When I click the Upload button, the file upload dialog does not appear in  Modern UI.  But it was working as expected in Classic UI. Thanks in advance for your time and support.

The Item ID hyperlink on Sales Order and Shipment details cannot open the Stock Item popup window, no response after clicking.But the same Item ID link works fine in AR Invoice screen, can open stock item page normally.Can somebody give some advice?

Hello TeamI am trying to use the customer metafield to sales order description.I’ve done the required mapping based on the below KB Article The same entity mapping working for customer entity but it is not working for sales order. https://community.acumatica.com/how-tos-and-faqs-262/how-to-map-shopify-metafields-to-acumatica-fields-when-importing-data-30209?tid=30209&fid=262 Try to bring the customer metafield when the shopify order customer, Order> Customer> metafield the data has to pull and update in the sales order description on header level. https://community.acumatica.com/how-tos-and-faqs-262/how-to-map-shopify-metafields-to-acumatica-fields-when-importing-data-30209?tid=30209&fid=262 Could you please any one can help why it is not working on sales order description.

Hello, I created a custom quoting software in Python for the machine shop I work for.  It auto generates a routing with set-up time, run units, and run time. As well as what material to use based on user inputs. previously we have just ran this software then just copied it over into Acumatica, so Acumatica gives a unit price.   I am trying to get this info to be pushed to Acumatica via the rest API.  I have successfully been able to put/patch the info from my software to Acumatica.  The one tricky thing I have been having problems with is Acumatica calculating everything incorrectly.  Resulting in me editing the times and reverting it back to get Acumatica to give me the correct costs. For Example:image (8) shows the data fresh from my calculator in Acumatica.  You can see it is not calculating fixed labor costs at all.  2: the variable labor cost is off..   some operations have no run time but still show a variable labor cost.  The material cost is also off.  when I go into estimate o

We have recently upgraded from Acumatica 2024R2 to 2025R2, and we are still using the Classic UI (not Modern UI). In our previous 2024R2 environment, we were able to display the Total Cost field on the PO Receipts (PO302000) form, which showed the total monetary value of the received items.However, after upgrading to 2025R2, the Total Cost field is no longer visible on the PO Receipt page, What is the recommended way to re-add the Total Cost field to the PO Receipts (PO302000) form

the issue I am seeing now but wasn't there before is. When you link a SO to create a PO. The create PO is taking the date listed under the ship to date vs the requested on date stated on the SO. Any one know how to fix that? here are screen shots: SO: Create PO: should state Jan 28th but it doesnt. 

Ive been getting questions from our engineer to order team about utilizing Planning Production Orders to drive demand, instead of utilizing BOMs. However, I haven't been able to find any documented process of “next steps” after initially driving demand. Is there much of a documented process to replacing or changing to Regular production orders once ready to produce? It seems from initial research, that any use of PL Production Order Types is simply a manual management of use. Any help would be appreciated! 

We have a customer who wants to use multiple virtual warehouses to allocate stock.In reality, all of the items are in the same physical location.If a particular warehouse is selected on the sales order, so in turn the shipment, is it possible to change the warehouse that the item is picked from when using the Automated Warehouse Operations/handheld device? 

Does anyone know the answer to this question from our customer? We are getting ready to go live with the ability to ship internationally out of Acumatica. We were testing a shipment this morning and comparing the label that printed to the label that prints from UPS Worldship, and the Worldship label has a second label printed that is a barcode version of the commercial invoice.  Is it possible that we can get the commercial invoice that is created in acumatica to also print out as a second label to be placed on the package? We were told by our UPS rep that the second barcode label needs to be on the box so customs can scan and bring it up electronically. 

Yes you can export tracking number from Acumatica to BigCommerce/Shopify. To do so you nee to put tracking numbers in the line with box under Packages Tab.Keep in mind following rules: When shipments that include multiple boxes with separate tracking numbers are exported from Acumatica ERP to BigCommerce or Shopify, the system checks if the following conditions are met: • Each item in the shipment is linked with a particular box. If an item is not assigned to any box, the system displays an error. • Each box in the shipment contains at least one item. If a box is not assigned at least one item, the system displays an error. During the synchronization of shipments with Shopify or BigCommerce, for each box in the shipment, a separate shipment with a separate tracking number is created in the online store. Boxes that don't have any items assigned or are missing a tracking number are not exported to the online store.

Hi everyone,I'm currently trying to connect a FLEX synchronization scenario to a secure SFTP server. The SFTP server has been configured to use OpenSSH public/private key authentication.I followed the official documentation carefully: https://help.acumatica.com/(W(14))/Wiki/ShowWiki.aspx?pageid=d9555f46-0a48-4059-8082-decc6b8e3652 However, when I try to establish the connection, I get the following error message:Permission denied (publickey) FYI : The SFTP user does not have a password (only key-based access) but FLEX seems to hash the password even when the password field is left empty, which might be causing the authentication to fail.

I am having trouble moving GI Condition rows using the “Move Row Up” and “Move Row Down” buttons. When I select a row and click the “Move Row Up” button nothing happens. In my screenshot below, the only way I can “move” the row at the bottom up to the second row is to delete all 17 intervening rows and then manually add them all back below the new row. I don't have an option to import criteria either, which would be useful here.Is this really the only way to “insert” a GI condition somewhere other than the bottom row?Can’t Edit GI Criteria Row Order Thank you!

We’re currently preparing for an MRP implementation in Acumatica, and one of the key risks we’re anticipating is how the system will handle split Sales Orders tied to the same item.Due to capital budget constraints, it’s common in our environment for a single project/item to be split across multiple Sales Orders—sometimes up to 6–8 based on customer capital funding limits (typically around $5,000 per order). From an operational standpoint, these do not represent separate demand signals; they reflect a single underlying requirement that is fragmented for financial reasons.Our concern is how MRP will interpret this structure:Will each split SO be treated as independent demand, potentially inflating supply signals? What is the best way to maintain a unified supply strategy (single PO or Production Order) while demand is distributed across multiple SOs? Are there recommended configurations, linking mechanisms, or planning practices to prevent duplicate or excessive planned orders in this s

We have an original invoice of $10,000 with 2% cash discount for payment within 10 days.We returned goods worth $1,000 via debit adjustment.The system still calculates cash discount based on the original invoice amount ($200 discount), instead of the adjusted net amount of $9,000 (correct discount should be $180).My temporary workaround: I used a $9,000 debit adjustment to offset the original bill, then recreated a new $9,000 bill to get the correct payment amount.Could anyone advise if this method is acceptable? Are there better solutions?

How do we update prices for service contracts?When we update a recurring price, this does not cascade to the next period. It reverts back to the original price from two periods ago. Is there a function to update prices and cascade those prices to every period forward? 

We have a custom warehouse operations web application that integrates with Acumatica via the REST Contract-Based API. The app has its own user authentication system with individual named users (warehouse staff, receiving clerks, etc.). All API calls from our app currently go through a single shared service account, so every receipt, transfer, and AP bill created in Acumatica shows the same username in audit logs - we lose individual attribution entirely.We are aware of Option 1 - storing each user's Acumatica credentials in our system and logging in as them individually for each operation. This is the obvious solution but comes with real tradeoffs: every warehouse user needs an Acumatica license seat, credential storage and session management gets complex, and we'd need to manage separate Acumatica sessions per app user.Our question: Is there a supported or recommended approach in Acumatica to pass the identity of the originating user through API calls made by a service account, withou

Hi Acumatica Community,S4 Consulting is pleased to share that we are providing a Free Vietnamese Language Pack for Acumatica ERP for Acumatica users and implementation partners working with Vietnamese teams. Our Vietnamese Language Pack included:Menus, screens, and key business fields Standardized Vietnamese business terminology Support for both Web and Mobile interfacesWe are also happy to support Acumatica partners who have projects in Vietnam and need a practical localization option for their customers.You can view the full details here:https://s4.com.vn/en/vietnamese-language-pack-for-acumatica-erp/Thank you.

Hi Acumatica Community,I’d like to share a resource dedicated to Acumatica in Vietnam:https://acuerp.vn/This is a Vietnamese blog focused on practical Acumatica usage, built to support both businesses and consultants working in a local context.The main goal is straightforward:– Help companies understand how Acumatica fits real operations before implementation– Share hands-on configuration, customization, and deployment experience– Provide practical use cases instead of generic documentationKey highlights:– Content tailored to Vietnamese business environments (finance, distribution, construction, F&B)– Real implementation scenarios from actual projects– Guidance on system setup, workflows, and data structure– Insights into applying Acumatica for cost control and operational efficiencyIn many ERP projects in Vietnam, the challenge is not the software itself, but how to adapt it correctly to local business models. This blog focuses on solving that problem with real-world experience.Th

Hey Everyone, I heard of an update to Chrome that will deprecate XSLT. Long Story Short - Classic UI screens will break November 17, 2026 onward. https://developer.chrome.com/docs/web-platform/deprecating-xsltThe only workaround at the time is to use Firefox Browser (or other non-chromium browsers) or use an older version of Chrome / Edge. I believe Acumatica is working on a patch / workaround for earlier versions of Acumatica (that don’t have modern UI). Important update to keep on your radar less your Thanksgiving gets ruined 😅This adds an urgency to update screens to Modern UI. I’m not sure whether screens will crash or loose functionality. I’m going to try to manually turn-off XSLT to see how screens respond.  Stay tuned in case any fix becomes available. 

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 Karthik Gajendran - Acumatica Community Featured Member for April 2026Meet Karthik Gajendran our Acumatica Community Featured Member for April 2026. It’s great to have you as part of the Acumatica Community ​@KarthikGajendran! Acumatica Community Webinar - Data by Design II: Take Acumatica’s Report Designer to the Next Level - April 21, 2026 - RecordingReady to go beyond the basics? This intermediate session builds on Data by Design. If you’re comfortable modifying reports and working with data, it’s time to unlock more advanced capabilities that give you greater control and flexibility. Acumatica User GroupsNew! NorCal Acumatica User Group, Distribution Customer User G

We redesigned the PO641000 form and are able to print from Printed forms, but not from the actual Purchase Order on Screen PO301000.  We are using 2025 R1 which has still the classic UI.  Just went down an AI wormhole and still could not get a solution. All tips greatly appreciated.  

Hi All,I am trying to get OpenOrderQty to show on a GI that is based on Purchase Receipts screen. I have linked POReceipt to POReceiptLine as per DAC Table, however the value for OpenOrder QTY does not show up.If someone can let me know what is missing in order to make this work, it would be wonderful.Kind regards,Calvin Law