Distribution

I have a client currently who does Vendor Pricing and they need to update sometimes over 100,000 records. I know this isn’t feasible with the Price Worksheets as they have a limitation. I am looking to see what others have done to get around the limitation in Acumatica. Obviously using the Vendor Prices is not ideal because it would take too long to update.  Thank you!

 Hi Acumatica Community! anyone know how to best handle this scenario? Item A is stored as a kitted item. But it's sold as component as Item B. When looking at on hand qty, is there a way to count Item A's inventory as part of Item B? 

I have a weird issue, I couldn’t find a known reported issue/fix for. 2023 R2Sales Order generated for 150 units at 10 units/case.We had 98 available in inventory.  The system allocated 98, we only shipped 90, due to ‘ship case quantity restrictions’, and canceled the shipment line for 8 units.More inventory became available, recently, system allocated 76 units.  Math says we should have expected 60 to complete the 150.  Total ordered is showing 166 on SOOrderLine. Everything looked fine in the Audit History.  We can track the order allocating all available inventory (known issue for us).  We followed our process to cancel the partial case.  SOOrderLine totals looked fine until inventory was allocated to the shipment this morning. We fixed the issue with this order, but I am trying to understand how this occurred so we can avoid delays/issues in the future.  If the second shipment allocated as 70 or 80, we could have overshipped a case without visibility until we got feedback from the

Has anyone seen this error before? We use the Acumatica Native solution for Ground Collect. I have some shipments that will release while others get this error. I cannot find where the issue lies on this one.  

Our Approval Map for PO Requisitions has been working well, until we wanted to wait until after bidding is complete.  Desired process is:Requisition Created Sent for Bidding Bidding Complete, Price Finalized, and Vendor selected Management ApprovalSo far we’ve been unable to delay triggering the approval to after bidding is complete.  We’ve tried several combinations of Steps and Rules, but it appears to want to go directly from On Hold to Pending Approval.Is there a way to accomplish the flow outlined above?Thanks very muchAndy

When we click CONFIRM SHIPMENT, we get the following error:Carrier Service returned error. USPS:The request could not be understood by the server due to malformed syntax. ProviderEndShipper address.name or address.company requiredCan anyone tell me what needs to be entered in Acumatica to avoid this error and allow confirming the shipment?Thanks,David

Hello, I’m looking for a way to make matrix items with only one variable. I have a product that comes in 4 colours, but doesn’t have any other variables. Is this doable? 

Hi All,since our business have some PO with dropship type we have to manually tick the freight line to complete (dropship freight is a non-stock item) to able to receipts the whole PO). is it possibility for the freight dropship to be auto-complete?

Hello Community, We are having an issue when attempting to confirm a shipment and receiving the following message:On the shipment, we are not trying to delete any items, simply clicking the “Confirm Shipment” button and receiving that error. The quantity lines are as follows:These are serialized items, and all have a serial selected so no unassigned quantities. No duplicate shipments were sitting out there, and the lines are all allocated correctly. The order itself shows the lines as open for shipment and every line is marked “back order allowed”. Has anyone seen this error before? 

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.