Discussion Forums

According to the documentation Purchase Receipts , when we create a Receipt, the system recalculates the Unit Cost instead of using the exact Unit Cost entered in the PO, right?Why does the system recalculate the Receipt Unit Cost from the PO instead of using the exact Unit Cost we enter on the PO? Is there any way to change this configuration so that the system keeps the exact Unit Cost entered in the Purchase Order instead of recalculating it? 

Hi All,My current requirement is as follows:I am extracting daily sales data from Epos Now (POS system). I have already been able to transform the sales data into a journal transaction format and load it into Google Sheets. The next step is to import this data into Acumatica.I would appreciate your guidance on the best approach to proceed, including recommended methods, tools, or integration options for importing journal transactions from Google Sheets into Acumatica efficiently and reliably.version : Acumatica Cloud ERP 2025 R2Thank you for your time, and I look forward to hearing from you.

My client needs the ability to have multiple shipment open on a sales order simultaneously. The create shipments to tell the warehouse to prepare configuration of the shipping items, prepares a pro-forma invoice, and creates a shipment to send to US Customs.What have others done for their clients to achieve this or this type of need, workflow customizations?

Hello,We need the freight cost that is defined on a dropship PO to be linked back to the sales order. We need the freight cost to be tracked and passed from the vendor back to the customer in order to track profitability for the freight line on the sales order. If we do not have the ability to track freight cost, then all we are getting on the sales order is the freight price which throws off profitability.  Tracking dropship freight cost to a sales order invoice. Here is a dropship purchase order. I added line 002, Freight Charge, onto the PO at a $50 cost. This is the cost the vendor is charging us for freight. This line is linked to the sales order. We would like this cost reflected on the sales order that is linked to the dropship purchase order for profitability purposes.   Here is the sales order that is linked to the dropship purchase order. As you can see the “Freight Charge” has a price of $100. To explain further we are charging the customer $100 for freight when the freight

This applies to all of the Acumatica Community Discussion Forums - We do this to make sure the member experience can be focused on product questions and solutions. No commercial useUsers may not use the forum for (commercial) activities such as the advertising or sale of products or services, employment offers, surveys, the sending of commercial messages (spam), the offering of (interactive) games or the advertising of other chat forums or websites.Complete Terms here: https://community.acumatica.com/site/terms

We just found out we cannot print drop-ship POs once it’s been received while being in the PO. Does anyone know the reason? We have a work-around of reopening the PO and printing, or using the Printed Form in the PO list screen. 

Hello all!Join us for first Coffee & Code event for the year - Modern UI, a webinar where Varthini Bhaskaran and Vignesh Ponnusamy dive into the modern UI and best practices. Moderated by Ekaterina Androsova and Vyacheslav Kuznetsov. Grab a coffee and let’s talk code!Recorded video available here: Keep your eyes peeled for the next event, thanks!

Hello! My company is new to Field Services. Sometimes we want to over ride the contact, but ONLY want it to modify the contact box area, NOT the Address info. ALSO, sometimes when I pick a contact I want it to be the contact persons email and phone number, and sometimes I want it to be the basic company contact information. This would likely require a check box customization to choose which decision needs to be made for that specific service order. Any guidance on Out of the Box or customization is appreciated  

Hi there everyone,Our company recently upgraded to 26R1, we noticed a few bugs here and there, but one that seems to be prevalent is an issue with the autocomplete box.  For example, when typing in an item into the Sales Order screen, typically a box automatically comes down, giving you different autocomplete options to choose from. However, now it is only loading the first 15 rows of that, and then showing only blank rows afterwards.This happens both on the Classic and Modern UI, and it happens for all fields that can be auto completed, like Inventory ID and Customer. Each time it shows the first 15 results, and then the remaining populated rows are blank. If you click on one of the blank rows, something is actually entered in, it looks like the text in the autofill box is just invisible to us. Has anyone else experienced this?

We have an internal test server.  Previously when I would run the PatchTool it updated within seconds.  Today I am running the newest version of the PatchTool against a 25R2 site.  It appeared to hang up on “Starting UI Compilation” but I let it run and it finally finished.  I then ran against another site and paid attention to the time.  It started the UI Compilation and 11:35 and didn’t finish the update until 11:47 (12 minutes).  Anyone else run into this?  Is this to be expected now?  You can see below that Node.js JavaScript Runtime was eating up most of the CPU.  Just curious if this is now normal.  

Hi,I am running into an issue with a client on version 25R2. I am able to generate a Project Drop Ship PO from the project. However, when I try to create a PO Receipt against the Project Drop Ship PO, I keep on getting this error message below. The trace log does not provide any detail. I reviewed the inventory and stock item configuration everything appears to be okay. Do you know what I am missing or could it be a bug? Any insight would be great. Thanks,​Frances  

Hello all,i have built a 12 Mos rolling report & the coulmns seem to be carrying forward the balance to the next months and soo. I only want to display the figures relevant to current period. How to do so under Column sets?

Hello Everyone,I would like to know whether any liquor distributors or alcohol beverage distribution companies are currently using Acumatica?If yes, I would appreciate hearing about your experience with inventory management, order processing, compliance handling, integrations, and overall system performance within the distribution workflow.

Hi all,A client is looking to be able to embedd docusign part 11 into Acumatica. Its needed for sign offs. Instead of sending out a document for signature, they want to be to sign in the acumatica instance and keep it there for records.

any thoughts or passed discursion on this customer question ? For SO’s that are sitting in awaiting payment or credit hold. How do we get it so that it commits that inventory? We need to be able to plan for that inventory.

Hello,I have been trying to release the Labor transaction but unable to do so: How to resolve this?

Our client is using Filters on the Inventory Planning Display in 24R2.  While testing for 25R2, I noticed the option to setup filters is gone.  This is a critical piece for our client.  Is there a work around that I am missing?  The client has many users of this screen that need standard filters to review the results.Has anyone else noticed or experienced this issue?

Hello,we have a multi company & multi branch setup. How can 1 setup the warehouse & location for the items being undergoing intercompany transactions across branches & companies as we only have the option to set a single default WH & Loc.

Hi all,I am trying to reverse an AR application, but I am unable to reallocate the document after the reversal.Current situation:Credit Memo 325697 is currently applied incorrectly. Credit Memo 325697 should be applied to Debit Memo 325701. Credit Memo 325704 should be applied to Invoice 324801.However, when I reverse the application on Credit Memo 325697, the document status changes from Closed to Open as expected. Despite this, the previously applied invoice remains linked, and I am unable to remove the application and reapply the credit memo to Debit Memo 325701.Has anyone encountered this issue before? Is there an additional step required to fully reverse the application and allow the credit memo to be applied to a different document?Please advise.Thank you.

I am working through the Developer course program, and somewhere along the line i had messed up work i did in T210 while working through T220. I couldnt figure out the problem after many hours, and decided it best to just start over with a fresh T220 install using the Acumatica ERP Configuration tool. It doesnt seem to have worked properly. With a fresh install, when trying to click the Services and Prices, it says‘ Error: A site map node with the screen ID RS203000 does not exist. Maybe it was moved or removed.’ But i can manually change the url to go directly to the screen. My Site Map has RS203000 on it. Its a screen in my customization project browser. Its included on the Site Map of the customization project. Its included in the Access Rights.  Any guidance would be appreciated

Do you know what DAC SOShipLineSplit is for and what triggers its population (UOM issue)? I am trying to understand the difference between shipline and shiplinesplit.As an example:Product XX has a base unit of EA and Sales Unit of BOX (5 EA in a BOX). Units are marked as divisible.  PO is EA (so we can’t change the base unit) We raise a SO for  XX: Quantity: 1 BOX Shipping transaction shows XX. Quantity 1 BOX ,the sales unit. On the Picklist form (report) the UOM is set as “=IsNull([SOShipLineSplit.UOM],[SOShipLine.UOM])”.  [I think this is standard]The picklist shows XX with Qty 5 EA to pick (not 1 BOX)(as Shipline.UOM = BOX but ShipLineSplit.UOM = EA) While this is the correct number of base units, we want the picker to send out an unopened box, not 5 individual products and we get mistakes when a shipper (manual picking) sends out 5 Boxes! QuestionsWe did not and don’t expect to ship less than a box (so never 3 EA) so why is ShipLineSplit populated?  Can I safely update the report t

I have an advanced customization product which is causing unexpected behavior with the REST API. There are currently two cases reported of such behavior:Environment: 25 R1, multi-nodeSymptom: when using OAuth 2.0 with Resource Owner Password Credentials, after a successful authentication returns <script>window.open("/Main","_top");</script> on the first request and a blank 200 on subsequent requests. API requests not using OAuth 2.0 (just authenticating with user / password work fine). Behavior cannot be reproduced locally (with client’s data and customizations) or in the client’s Acumatica-provisioned sandbox. Client is working around the issue by only publishing my customization on the main node and sending API requests to the processing node.   Environment: 25 R2 (modern UI)Symptom: when logging into the connected instance through the Jigx app with OAuth 2.0 with Authorization Code, the client receives an error from the Jigx app indicating they are unable to sign in. Beh

Hi ,I have an expense which affects multiple projects. Can I enter one AP bill affecting multiple projects ? Thanks,Dulanjana 

In this example, the attached customization adds HTML field to the projects screen, where AI Studio analyzes the project cost and revenue budgets and generates a report, populating the HTML field.This can be applied to 26R1. -XML for AI Studio prompt is attached with the name PROJRECOM (3).xml  , please remember to change your AI Connection setting after importing the xml file as shown in the screenshot below  -Import Customization package to add the HTML field to the projects screen ProjectRecommendationAIReport (4).zipResult should be similar to the example below This customization is not maintained by Acumatica. It has been developed solely for demonstration purposes to illustrate how AI Studio can be used.    

After upgrading to 26R1, I’m now getting this new Exception (didn’t happen in 24R1):"A PXGraphExtension instance has been passed as a query parameter to the Select method."This happens on a Select using the POLine object: public class POMaintExtension : PXGraphExtension<POOrderEntry>    {        public SelectFrom<POLine>              .Where<POLine.orderNbr.IsEqual<             POOrder.orderNbr.FromCurrent>>            .View POLineView;        private void DeviceHubPrint()        {            foreach (object objPOL in POLineView.SelectMain(this)) //throw Exception...Question: did something change with POLine causing this new behavior?