Hello, apologies for the long question.
I am working to setup Acumatica and noticed the handling of inventory for Sales Order shipments is different than every system I have worked on in the past. With our current configuration, when you create shipment for a Sales order you stop just short of Updating IN. This is because one you Update IN it creates the inventory COGS transaction on the PL. We do not invoice and recognize the revenue, until the product is delivered to our customers. So if you do Update IN this creates a disconnect between revenue and expense (not an option). However, if you do not Update IN the inventory remains “On Hand” at the warehouse and all reporting shows those quantities on hand. What I would prefer to see is that inventory moved to In Transit until the SO is invoices at which time the inventory is expenses and the Receivable is created. Due to the inventory remaining ON Hand I am having a difficult time reconciling physical counts at our sites and creates a huge amount of manual calculation to back out the true in transit inventory. I know there is a inventory metric for Available, but that is not included in any mass inventory reports. Meaning I can only look at that by item/Whse.
So two questions:
- Is there not a way to configure the Update IN to move the inventory to In Transit (much like a 2-step Transfer does) and the inventory is expensed at the time of Invoicing?
- I don’t see a report that included Available inventory that I can run for all items/sites? Is this a custom report request?
Thank you very much.
Best answer by NoahView original