Distribution

Hello! We have a scenario where we define the Sales Prices in Non-Base Currency (USD) but require it to be converted to Base Currency (LKR) in some instances. Specifically, if the customer is USD the USD prices need to be loaded and if the customer is LKR, we have to convert the USD price to LKR on an agreed rate. There is an option to convert Base currency prices to a non-base but any possibility of other way around?Best Regards!

Is it possible to merge lots of inventory within Acumatica?

Hello,We have a blanket sales order.Multiple lines each with the same inventory ID.When we create child orders from the blanket, we need each line to be it’s own new SO sales order.Acumatica consolidates all lines into 1 new sales order of type SO. The only way we can see to keep Acumatica from consolidating all lines in 1 SO sales order is to use a different location on the BL line item.I cannot find a preference or setting that says “Do not consolidate” or anything like that.  And the only way we have found top prevent the consolidation is by using different locations on the line, which we do not want to do. Any thoughts or suggestions?

Is it possible to link a Sales order line item to multiple  Drop ship Purchase orders  

Hello! I want to create Purchase Orders by using “Mark for PO” function on the Sales Order form. But I do not need to create Purchase Orders for the full quantity mentioned in the line but a less quantity.  Is there any way of doing this? 

Hello,I see a couple posts that reference my issue but they are not clear, and the help is a bit murky too.  I’d like to get some community thoughts.  Here are the 2 threads that hit on my issue:  What I’m experiencing in 24R2: IF the posting class is supposed to be what drives the GL Accounts, the Order Type Posting Setting seems to override posting classes, essentially making the posting class not viable, because there is no way to “NOT” select a value for this drop down:  as an example, if I have the standard SO Order Type as ABOVE, this setting is set to use ‘posting class’ for sales account.If I create an SO add 2 linesA stock item that has a posting class that uses the “posting class” for sales (therefore the GL account is populated) it will derive the correct Sales Account.   See below - AACOMPUT01 A non-stock item that has a posting class that uses the “inventory item” for sales (therefore the GL Account on the posting class is NULL).   It will NOT place a sales account on the

Why the system would force a refresh on order type change. Order types are used for a classification. In this case, the order is already new and no information has been entered, so changing the Order type field itself does not need to create a brand new record because there has been no action taken on the existing record. 

Hi,Client have updated the Acumatica Non-stock Item master weights for some ittems (They are only doing the Drop-Shipping) and seeking a solution to update the weights in some documents (Ex: Sales Orders, etc) which are created before the weight update. Someone kindly advise in this regard. 

I am trying to create process for users here to use Activity Tasks for order/quote follow up.  I keep getting an error stating  Custom Week cannot be found. Custom Week's must be generated with date greater than 4/24/2025.  What am I doing wrong? 

We have an issue where we will receive more of an item than what’s on the PO, however we don’t want our receiving team to be able add that to the receipt.Is there a way to prevent adding items or QTY that’s not on the PO? 

We have some inventory that was in  A warehouse prior to the split and was transferred to B. However, that inventory was already physically transferred to Z company and should be in the XYZ company.  On the finance side, the value of this inventory was already paid for Z Company. What is the best way in Acumatica to transfer this inventory back?

I received the error message, “Another process has added the 'AR Invoice' record. " Please help and support me.

acu-connect Edition Days: Distribution If you use or support Acumatica for distribution processes, you know that distribution companies have unique needs when it comes to finance and operations.Join us along with Acumatica Product Manager Kelly Squizzero for this presentation geared specifically toward Acumatica customers and VARs who work with the Distribution Edition to learn about add-on solutions to address the common challenges distribution businesses face and how they can help you extend the power of Acumatica.We'll also hear from acu-connect sponsors who have solutions geared toward the Distribution industry, including:Rockton Pricing Management EBizCharge Acumatica payment processing CIMcloud B2B-First e-commerce Cavallo Profit Max Platform Cedar Bay barcode scanning and labellingIf you use or support the Distribution Edition, don't miss this opportunity to learn about add-on solutions to enhance Acumatica! Date:  May 22, 2025Time:  1:00p to 2:00p ETRegistration

I am currently experiencing an issue when attempting to create invoices in the system. The process is being blocked with the following error message: "Invoice Nbr cannot be empty."Could you please advise on the cause of this issue and guide me on how to resolve it?Thank you very much for your support and helping.

Hello all,I have been trying to add medium & flat rate shipping methods in ship via codes, but they arent appearing in the list. The integration with stamps.com and acumatica shows successful, but not able to see medium & flat rate. 

I config inventory replenishment setup inventory planning warehouse detail when I go prepare replenishment screen I don’t see that item in the the warehouse config for replenishment but if select the others warehouses are not in inventory planning, I can see it like this  So please help what am wrong in configuration

Hello Everyone, Acumatica is currently evaluating a native integration with Amazon Vendor Central, and we are seeking insights from customers who are already trading on the platform.If you are currently working with Amazon Vendor Central, we would love to hear from you! Your insights will be help in shaping this integration to better align with your business needs.Please feel free to comment on this post or reach out to me directly via email at karthik.gajendran@acumatica.com.Looking forward to connecting with you soon! Thank you

Hi AllIs there any workflow in Acumatica to have multiple requsitions from the same vendor be added to one purchase order?ThanksAmit 

Looking for some help understanding why when doing a Kit Disassembly some items do not automatically show a cost in them?  Cost appears when the Kit is Assembled, but when doing the Disassembly some of the kit components show a cost and some don’t. All stock items show costs in the Stock Items > Price/Cost tab so I’m having a hard time understanding what I need to fix to resolve this issue. Thanks in advance! 

In many industries (automotive,...) produced parts sent out in reusable bins and / or pallets. These reusable bins must be tracked, and ultimately, you need to know how many reusable items each customer still possesses in order to reclaim them if necessary. How do you deal with these requirements?

Hi,Is there a way we can generate Inventory Balance report for a sepcific date.As an example,  I want to see the inventory available balances as per the date of 5th April 2025. How can we fullfil this requirement?Thanks!

When trying to confirm a shipment I get the error: “Carrier Service returned error. FEDEX: FORBIDDEN.ERROR We could not authorize your credentials. Please check your permissions and try again.” The carrier page for FedEx says the connection is successful, so I’m at a loss of what the issue could be. The Error 

I’ve scoured this forum and can’t find any suggestions, so I’m hoping someone can offer suggestions. We are 2 years into Acumatica and still struggle to find very simple reporting that was readily available in QuickBooks.We are filing personal property taxes and need a snapshot of the quantity of items in inventory as of 1/1/25 AND the valuation of that inventory. Is there something like that already built out in Acumatica? It doesn’t seem like a huge ask, and I’m sure we are not the only company who would need this kind of data, but I can’t find it. Inventory Balance - gives me a current count of thousands of inventory items, no total count, no valuation, no way to filter by date Historical Inventory Balance - allows me to pick a MONTH, not a specific date; no total count, no valuation Inventory Valuation - gives me a total quantity and total cost, however I can’t backdate it at all  Historical Inventory Valuation – if I tell it to pull 01-2025, that doesn’t necessarily give me data f

On the Inventory Transaction History screen, there is a handy button to ‘Include landed cost in unit cost’. Interestingly, this also updates the impact of any PPV cost adjustments on the receipt.Without PPV (original PR price) & with PPV (after PPV revalued)Is there any easy method to retrieve this additional cost layer information through a GI, so we can push it through an import scenario? Specifically, we need to update the Last Cost of specific valued items so that it reflects the actual receipt cost with PPV revaluation included. Otherwise, our cost rolls are taking the incorrect last cost sans-PPV revaluation.