Distribution

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?

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?   

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 

 The PO exchange rate here is 1 USD = 59.75 PHP When trying to receive it, the Currency exchange rate becomes 0. I have tried to put an effective exchange rate, but to no avail. Please help. Thanks

Hi everyone,We order things from vendors sometimes direct from overseas or from domestic locations. An item could have different pricing based on where we are ordering it from. e.g. Overseas is $10 USD, Domestic stock from US is $15 USD…Is there a way to keep both sets of pricing for each item in the system without creating a separate vendor?Thank youJoseph

 GIDate MM/DD/YYExport ScenarioExport Scenario Date format is adding time. I want it in date in MM/DD/YYYY 

From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly?  Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious?  Appreciate any insight others have in this area   

Hello, i am trying to adjust in a part, which is not set as serial tracking..when I adjust in as inventory count reason, it asked me for receipt nbr.. can someone shed some sort of light please?Thank you Zoey 

Is there a configuration or setting to force users to do a recount on the mobile device if they enter a value other than what is on-hand?Example steps:On hand inventory = 7 ea User enters 6 ea for the location Mobile device prompts that this value is incorrect and needs to be recounted After the second entry the user may continue with the count

We are trying to develop a more systematic physical inventory process and are looking for advice on best practices within Acumatica.We are currently using Acumatica 2025 R2 (Classic UI).Our challenge is that we do not want to lock the entire warehouse when performing a physical inventory. Ideally, we would like to count only specific Inventory IDs or locations at a time.I realize that Physical Inventory Types can be filtered by location, and the Prepare Physical Count process allows us to further filter by locations and inventory items when generating a count. However, with approximately 1,300 active Inventory IDs and 1,500 warehouse locations, it still feels like a very manual process to decide what should be counted and when.From what I have seen so far, setting up and managing Physical Inventories appears to be heavily manual. Am I missing something, or does Acumatica really lack the ability to generate and manage cycle counts in a more systematic way?This has led me to investigate

Hi, we have a set up of promotions by item class but need setup mixed promotions. Eg. Item Price Class 1 QPD 120ML (24) has 24 products in it. There is a promotion that is Buy 4 get 1 FREE (the products can be any of the 24 in the item price class). Currently Acumatica will only apply the discount if the customer buys Qty 4 of the one item – not mixed.Any thoughts on setting up mixed promotions?

trying to use a contact for invoices and a different contact for statements. I thought that using the mailing & printing feature within the customer profile would solve this. However, after updating and saving, it does not seem to work. I did generate the statement on demand to test out; not sure if this is the issue. It is the same screen ID of AR641500 that the generated statement is on. It still uses the account email in the general tab, however. That is the one I want for invoices only.   

We recently purchased DRP (not MRP). We buy items in nested sets from our vendors. We need the individual items out of the nested set (disassembly), not the other way around. For example, if Item A is out of stock, we need to buy a nested set that contains Items A, B, and C. When we receive the nested set, we do a disassembly to break it into the individual items. We've already explored setting Source = Kit Assembly on the individual items, but that plans an assembly — consuming components to build the kit — which is the opposite of what we need. We need DRP to recognize that our individual items come FROM disassembling a purchased kit, not the other way around. Is there a way to handle this in DRP? How are others managing nested sets or bundled imports that get broken down for individual sale?

I’m working on an Acumatica-based solution (via a vertical solution provider) for a fuels distribution business and am looking for guidance on how others are handling Weighted Average Cost (WAC) in scenarios where the true cost of inventory goes beyond just the base purchase price. Business Context:In our current system, WAC represents full landed cost, including:Supplier invoice cost (fuel) Vendor-charged taxes and regulatory fees Internal freight (marine, line haul, inter-terminal transfers) Allocations applied as fuel moves through the supply chain This cost structure is critical for:Inventory valuation Margin reporting Financial/audit alignment Challenge in Acumatica:From what we’ve seen so far, WAC appears to only reflect the base item cost at receipt, and additional costs (freight, taxes, etc.) are not automatically incorporated into the inventory cost in a way that recalculates WAC. Questions:1. How are others incorporating additional landed costs (freight, fees, taxes) into WAC

Hi Acumatica Community,I created an Import scenario for 1-Step Transfer but encountered an error.is there a mapping that I need to include to proceed?Thank you!