Distribution

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 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.

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,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.

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

Hi there, I have received a PO and now want to do the putaway but it keeps giving me this error:Put Away mode in use.Error: Inserting  'Receipt' record raised at least one error. Please review the errors.Document is out of balance.Scan the destination location. Im assuming this is because i havent been prompted to enter the quantity that i am putting away.Is there a setting i am missing?  

Our team picks 12 orders at a time using the mobile scanners and pick lists.  When multiple orders in a pick list (wave picking) have multiples of the same item, picking directs them to pick one per tote until complete.Example: totes A, B & C each get two of the same white shirts.  A picker will be directed to put one unit in tote A, one in tote B, one in tote C, then another in A, another in B and another in C.Is it possible to change it so that they are directed to put two in A, two in B and then two in C?

We're working on an Inventory Aging Report as a standard feature in Acumatica, and we want to make sure we build it the right way.We already published a survey in the related idea:A big thank you to everyone who has already responded! In case you missed it, here's the Survey link.Your input is invaluable — we'd really appreciate hearing from you!

We have some items that require a core return.  We ship out the new item and include a return label for the return of the core.  We generate the return label in Shipstation, tied to the order/shipment of the new item going out.Shipstation sends back the UPS tracker for the outbound box, but I’m not seeing anything that also has the tracker for the return label.  I’m guessing it doesn’t come back into Acumatica, but I thought I’d see if anyone else may know.

How do I handle this issue using Receive and Put away 25R2 Purchase Pref Default Rec Qty = Open QTY enter PO on Rec & Put Away Receipt is created  Note - PO is more than 15 lines so lines do not populate scan first item with qty 3 open for serialized item prompted for lot serial enter serial number  error below when I hit OK 4 lines display not 3 and end up with 4 received error : The Receive mode is in use.The scanned quantity exceeds the quantity in the BP108849 PO receipt for the 3M.33633 item.Confirm receiving 3M.33633 x 1 EA. The following quantity of the item will be added to a receipt line that is not linked to a purchase order: 1 EA. To confirm, click OK.

Hi all.Currently, the system uses the “Available” quantity to validate stock when creating a Sales Order. As a result, a warning message is triggered when there is insufficient “Available” stock (please refer to the attached screenshot). However, the internal process is based on the “Available to Ship” quantity rather than “Available”.Could you please confirm if it is possible to modify the warning logic to reference “Available to Ship” instead of “Available”? This would ensure the system behavior aligns with our operational workflow.I have tried it adjust this with “Availability Calculation Rules” but was unsuccessful.Appreciate your guidance on this.Thanks in advance!

Hello all,I have created 3 SOs for the same customers on different dates. I then created a single Shipment for those 3 SOs but upon creating an invoice, from the Shipments screen, it create 3 individual invoices. i did check under the order Types, Bill Separately checkbox is inactive.Not only this when the other day I created another set of SO for another customer, 3 SOs → 1 Shipment, it generate 2 invoices from the single shipment for 3 SOs. What could be the other reason for so?Any thoughts?

One of my clients recently ran into an issue with Shipstation and Acumatica. Shipments stopped syncing into Shipstation and he got this error message on Shipstations dashboard. Failed to import View Details The error message was helpful (great job Shipstation dev team). ⚠️ Do not click 'Reconfigure Store Connection' — it will produce this false positive and won't help. Fix the underlying shipment issue first, then the connection will work normally again. I looked at the Shipstation Logs within Acumatica (ScreenId=SS401000) Here again, great job on helpful error messages by the dev team! But I was stumped, because the shipment in Acumatica was not missing any descriptions (Item Descriptions in Acumatica map to Item Names in Shipstation) Finally, as indicated by the error messages, I found the Non-Stock Item has a NULL description. The order entry team simply fills in the description per order because this is a miscellaneous charge. The easy fix here is to put a description into the item

We are on 2025 R2 and use the EasyPost integration for shipping. Since mid-May, FedEx Express labels are generated but are corrupt and will not print on our Zebra label printer. All UPS labels print correctly as well as FedEx ground labels. FedEx Express labels created prior to mid-May can still be printed correctly.What label format works best for FedEx Express? We have used EPL for both FedEx and UPS successfully up until mid-May. As a short-term work around, we changed the FedEx label format to pdf and it generates correctly however the dimensions are incorrect therefore we can’t print it on the Zebra printer. (Printing on a laser printer, folding and taping to the boxes is time consuming but packages are going out.) It appears that there is a parameter missing in the x-EPL2 file returned to Acumatica for FedEx Express labels. The line starting with b21 ends with characters including a “?” which from my limited knowledge of the EPL language indicates a missing parameter. All new Fed

Hello,I was wondering if anyone knows if there is a resolution for this issue:The following error appears when attempting to create a shipment for an order for which the Sched. Shipment date is greater than the current date.This would be considered a bug to us, as there is no reason you should be prevented from shipping an order earlier than requested.This is a required field that is pre-populated from the SO Requested On field, and results in an additional unnecessary and confusing step of manually altering the scheduled shipment date to the current day before creating the shipment.We are shipping non-stock items, back order allowed, allow negative quantity, but that should not matter.I know this was previously a known issue but we are using 2023 R1 where it was supposedly resolved years ago  TYVM!Kyle

Hi Team,I have noticed that in sales price worksheets once it is released, we are not able to make adjustments to it. However, when we click on ignore automatic line discount (Which is selectable though the worksheet is released) the entire worksheet is put back on hold for edits. Can anyone please explain to me what the intended functionality of this check box? I have tested with this and if we delete the worksheet and it doesn't remove the released prices in the sales prices form but this seems problematic for traceability. Thank you in advance on any thoughts. Warm regards,Yasali

Hello,Is there a way to change the price class on the sales order?   Thanks!

Hi Community,I ran into and solved this error that I did not see any posts about on the Community. I wanted to post the Issue and the solution for anyone who might run into this Acumatica Error Message: "There are no lines suitable for creating Child Orders."Cheers,RJ

PO Error: There are no lines in this document that may be entered in AP Bill Document directly. I already enter one time bill with 1 qty and I want to enter more bill but it shows error. 

I have a requirement to create a return for a purchase receipt which has been created for drop ship SO.I tried by creating RMA order with RC order type and added the invoice number too. When I try to create a vendor return from the more menu, I got an erro as PO Error: There are no lines, for which a vendor return can be created. What could be the reason for this and how can I complete this.

We have a dropship PO which associated with a Sales Order. Basically we have released 1 purchase receipt and AP bill for the dropship PO. The Sales Order which associated with the dropship PO is completed with invoice.But unfortunately, we accidentally released another purchase receipt for the dropship PO which is not supposed to be.How do we make correction for the wrong receipt?   

Hi, I want to send an automated daily email of daily receipted stocks from Acumatica. I need them to be broken up between companies/branches and by item class if possible. Business event is what I am thinking, but I’d like to get your thoughts on how you would do it. Any recommendations are welcome 😊

We have an overseas Vendor from whom we make large orders which frequently come in multiple shipments. When they send a shipment, we get an advance listing of the details of the partial shipments, like lot numbers, final quantities, or discounted items, which we use to get the purchase receipt set up in advance to make receiving go more smoothly. Additionally, since undershipping and overshipping are also common, we adjust the Purchase Order to reflect what the final quantities are so that our Availability figures are correct. Our issue is that when we have a first pre-receipt created, the purchase order cannot be edited until that first shipment is received and processed, so any items on subsequent shipments can’t have their availabilities updated or any other adjustments made which come with the vendor’s shipment confirmation. We can have open receipts like this for weeks to months. Is there a way to only lock down individual lines of a PO which are on an open receipt instead of the

What are your thoughts on having Sales Prepared added to the Availability Calculation in a environment where inventory is high turn ?   Deduct Qty. on Sales Prepared A check box you select to deduct (for items of the class) the quantities of items on sales orders of the SO, CS, and IN types with the On Hold, Credit Hold, Rejected, and Pending Approval statuses from the available quantities of these items. The item’s quantity on sales orders with these statuses is shown in the SO Prepared box on the Inventory Allocation Details (IN402000) form.  

Hi Connections, I’ve a query related to expiry date control in Acumatica. Every inventory is specified as lot/serial and has an expiry date. As a result, based on that approach, expired items should not be processed. Is there any evidence that an item was expired at the time of shipment/transfer? Either Warning Message/ Allow / Don’t Allow Setups.,  I couldn't find any settings that would help me control this concern.  Hope you guys can help me on this topic. Thanks Ram