Distribution

Hi all,Does anyone know how to change / update the date that Acumatica uses to calculate the dead stock? As it stands, i can run a dead stock report - not selecting any days - by warehouse and items show up.I want to see what the date that Acumatica is comparing the items against to determine dead stock.*Note: I did do a search on the community and didn’t see an answer to this. :)Thanks!Joseph

Hi, how can I assign a cost to an item that is sold by the sales team on a sales order but is not purchased through our purchasing process?For example, we resell an employee’s day rate when they work on-site at a customer location. Currently, because there is no associated purchase transaction, the system records the sale as 100% profit, which is not an accurate reflection of the true margin.Could you advise on the correct approach to ensure the cost is properly captured and reflected in margin reporting?

Hello everyone,We have an inventory item with the tracking method set to “Track Serial Numbers”, which allows users to manually enter serial numbers.We recently added a feature for some inventory items to auto-generate serial numbers from a numbering sequence on the Save action.However, when trying to assign the generated serial number to the Lot/Serial Number field during Save, we encounter the following error:“Key field cannot start with a leading space.”We are confident that the serial number generated from the numbering sequence does not contain any spaces.Could someone advise on the correct approach to assign auto-generated serial numbers to serial-tracked inventory items on Save without triggering this error?Thank you in advance! protected virtual void POReceiptLine_RowPersisting(PXCache sende

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

What is the best process for the following szenario …Sales Order (SO) one normal stock Item but completely out of stock Order Qty.: 20 pieces PurchaseOrder (PO) for SO from Vendor 1 Order Qty: 20 PurchaseReceipt (PR) Qty.: 10 PO for the rest of 10 pieces from Vendor 2Thanks in advanceDeniz

When a customer decides to pay using a credit card, we charge an additional 2.5%. Is there a way to increase item cost by 2.5% when payment type CC is selected? I see where we can offer cash discounts by days but not an increase by term type. If not, I plan to create a Non-Stock item “Credit Card Fee” where we can calculate the 2.5% manually and add it to the order. 

If an item is setup as base Unit Cases and Purchase Unit Pallet, the PO cost information does not convert properly if changed from one to the other.  Changing the unit cost first, then changing the UOM or Qty causes the ext cost to be incorrect 

I am trying to accomplish the following:Store and Sell item in EAchesOrder in CARrtonsRound up to full CARton on POExample:Carton of 2Customer needs 3 EAI need the PO to be 2 CARtonsCustomer will then get 3 and 1 will end up in stock.I can get it to order 1 case if the customer only needs 1 EA. But if the customer needs 3, it will put 1.5 on the PO. I can't order half a case.How do I get the PO to round to full Cases?I tried Lot size of 1 (and of 2) neither works. 

One of client has below requirement.For easy stock movement and selling purposes they keep some items as 12 piece pack. During their sales operations, sometimes they sell the items as 12 piece packs as well as individual pieces. They have some scenario where they provide 1 individual piece as a free item when selling 12 piece pack. they are not keeping seperate item stock to provide as free item and they take individual units from 12 packs. How can we handle this.

Hi Acumatica Community,I’m looking to learn how others are handling PO revisions in Acumatica when a PO goes through multiple changes over its lifecycle. We’re running into challenges tracking quantity changes, date changes, and other key updates because users are editing the original PO fields rather than having a clear revision history.Today, changes overwrite prior values on the PO, which breaks reporting for vendor accountability, financial reporting, and audit visibility. We don’t have an easy way to answer questions like what changed, when it changed, or how often a vendor moved quantities or dates.For those of you managing frequent PO updates: How are you tracking PO revisions over time? Are you using revision tabs, custom fields, workflows, or external reporting? How do you preserve historical values for quantities and dates while still allowing operational updates? How do you handle ve

Is there a way to automatically load each individual sales order line ship date based on the stock item or manufacturing lead time? We have thousands of parts, and most items are made to order. We have estimated lead times for each part (based on BOM routing and some Manufacturing Lead Time) so we manually have to select the estimated date on each line item when lead times differ drastically.

Is there any way to only trigger awaiting approval notification once not multiple times after the document is approved, placed on hold, make some changes, then removed on hold?The changes that are made have nothing to do with conditions that triggered the approval.Ex:Approval map is setup in SO when an item is discounted 100%, approval is triggered. An SO is created and has the above condition met, approval is triggered, notification is sent, then approved by the approver. Then the sales user places the order on hold and make changes such as mark a line for PO, add description, etc but discount% remains the same. But when the order is removed from hold, approval notification is sent again. This is not a bit anoying especially the approver has approved the order and it’s necessary to make some changes to the order again.

Summit 2026 Breakout Session Presentations - DistributionAttached are PDF versions of the PPT presentations from our breakout sessions. B2B Connector: Breakthroughs with Acumatica and BigCommerceConnected Distribution: Boosting Efficiency Through Integrated SolutionsCounter Sales: Enhancing Walk-in Sales Efficiency with Acumatica POSInventory Management: Smart Allocation Tools to Optimize Inventory Across Every OrderInventory Strategy: Smarter Planning and Replenishment with AcumaticaNavigating Tariffs: Adapting Strategies with Acumatica ToolsOptimizing ERP Value: Realigning ERP Solutions for Distribution SuccessDistribution Strategy: Solving Real World Problems with AcumaticaWarehouse Management: Best Practices and What’s New in Acumatica WMSAI/ML for Distributors: Exploring Intelligent OpportunitiesDashboards and KPIs: Gaining Smarter Insights and Stronger Growth Through Data Visibility

Hi all,I recently created 2 separate Generic Inquiries for my company. One is Inventory with Sales/Margin/Margin % info. The other is inventory with units by location by warehouse.My goal is to combine these 2 GIs into one master GI to avoid having to switch between different reports when viewing sales and inventory information.Below are the data sources for the FIRST Generic Inquiry: Inventory Units & Cost by Warehouse.When I use this GI as a data source for a new GI, NO fields show up even after selecting them in the results field. I have not joined anything to this in the new GI yet, so I doubt it’s a data relation mapping issue.Conversely, when I use the other GI - Inventory by Sales/Margin/Margin % - as a data source, all records populate when I show them in the results field. Both individual data source tabs are shown below.thanks all!Joseph

Wondering if anyone has any customizations/add-ons used for container management in Acumatica that does not involve PC Bennett or IIG container modules? Looking for ideas on how others are handling.

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! 

We are trying to find a solution to alert users that we have shelf-life inventory that is nearing expiration date. Is anyone using the MAX SHELF LIFE field on the Stock Item under the Inventory Planning tab? If so, how does it work? If there are other processes that people are using, I’d love to hear them. We want to be more proactive with identifying product nearing it life span.  Thanks! 

We have lots of cases where we have parts which are used together, for example an enclosure and its backpan each with seperate part numbers. When we buy these items does acumatica have a way to tie these numbers together so that if either of those items are ordered it would also know to order the other item so that we can make sure we have the matching parts. Thanks

We recently implemented using a weight scale and connected to the device hub and we are now noticing the scale is creating 3-6X the ERP transactions in the database.  The user is simply putting box on top of scale and selecting “capture weight” then removing the box but Acumatica is seeing this as 5X the transactions instead of 1 time.  Anyone else going through this dilema?  We are seeing the SCALE try to poll every two seconds in some cases.  Thanks,Nirav S.

When we build Sales Quote our Freight has to be included on a line item and the taxes are one amount. Then when we convert it to a sales order the tax amount changes. Same address and same tax area for sales quote and sales order. Can you elaborate on why the taxes change? Is there a solution to fix this?   

Hello Community,We have faced one unique problem where our punch out creates cross references for all the NON-STOCK items from PUNCHOUT orders. Recently one of our customer reported that one or more items have the same manufacturer part# but different UOM making Acumatica cross reference reject the alternate item entry. After researching we found that Acumatica cannot accept alternate ID with multiple UOM for the same manufacture item from the vendor.Have you faced similar issue with your PUNCHOUT or using alternate IDs and what solution have you implemented? By the way this PUNCHOUT feature is a native Acumatica customization developed by our team but we saw this problem as common to everyone who uses alternateID for their cross reference.Any feedback or solution on this will be greatly appreciated.Vivek Vemunoorivivek@xtramilesoft.com  

Hello all,Recently while implementing Punchout feature for Acumatica for a customer, the users showed us how they utilize the replenishment functionality to create multiple orders for different vendors.While designing the Acumatica feature we focussed only on the Vendor site connection and bringing CART back into Acumatica and create either Requisition or a PO for approval and then sending order directly to Vendor.Now this replenishment order creation caused us delay in our implementation. So the question is how many of you actually use this feature to create orders. If you use “PUNCH OUT” feature how useful this feature to you to place orders directly from replenishment to approved Vendors?  We would like to hear this from the users who are heavily purchasing and have to either entry in Acumatica and then the vendor order site or sending the PO to their order system via email. We appreciate your feedback as this helps us plan and address

Good day,Under Inventory Planning, is it possible to generate a forecast by customer class instead of by individual customer, without requiring customization?If customization is required, can this be achieved with no-code/low-code customizationKind regards,Wilson

I have been trying to delete existing Sales Prices or change the expiry date with an import scenario.I can expiry them OK if the expiry date is null using the follow scenario: But once the expiry date it is set it appears that the existing records cannot be targeted to either delete or change the expiry date.  Is it possible?There is a post on How to Bulk delete all line items in Sales Prices | Community (acumatica.com), however there may be too many records for this manual method.

Hello Linkies,I have created a new PO report - PC PO (PC651000) in the system that I would like to add in place of the Print Purchase Order report as highlighted below.But I am unable to add the newly created report by modifying the Mailing & Printing tab in the Vendors (AP303000) form & Purchase Orders Preferences (PO101000) form.  Kindly let me know how can I achieve it. I am not looking to modify the already existing report.