I’ve been digging into the cost calculations for sales and have come across a discrepancy that I can’t figure out.
The unit cost in the ARTran table is different from the SOLine table.
Where are these 2 costs pulled from?
Answer
ARTran vs SOLine unit cost
Best answer by Laura03
Hello,
Depending on the valuation method of your items, Sales Order line cost may be an estimate.
For example, a FIFO item could have several layers of receipts sitting inventory with different costs. When a Sales Order is entered, Acumatica estimates the cost. The same item could be on several Sales Orders, and we don’t yet know which Sales Order might ship first, so we don’t know the precise cost of the item yet. When the Sales Order Invoice is Released, or when Update Inventory Cost is clicked, is when the system looks at remaining inventory cost layers and pulls the items out of inventory with a proper cost.
Laura
+19Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi
Then I stumbled across the Sales Profitability Analysis under Receivables and opened the underlying generic inquiry. It turns out there IS a cost field in the ARTran table (this is new?).
I compared the ARTran cost to the SOLine cost and they’re different.
Attached is the GI...it’s been through several iterations in this journey to get the cost for the invoice.
+19Hello,
Depending on the valuation method of your items, Sales Order line cost may be an estimate.
For example, a FIFO item could have several layers of receipts sitting inventory with different costs. When a Sales Order is entered, Acumatica estimates the cost. The same item could be on several Sales Orders, and we don’t yet know which Sales Order might ship first, so we don’t know the precise cost of the item yet. When the Sales Order Invoice is Released, or when Update Inventory Cost is clicked, is when the system looks at remaining inventory cost layers and pulls the items out of inventory with a proper cost.
Laura
~ Laura Barber, WM Synergy
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.