Acquisition Cost Adjustment - Calculation Logic/Formulae
Summary:
Calculation Logic/Formulae
Content (required):
Hello,
Help with this query please.
Could you help me to know what is the formula to calculate the Unit Cost in the "Review Item Cost" screen when the source is Acquisition Cost Adjustment?
I have executed the below scenario :
The Cost Method is Perpetual average.
1. Created Purchase Order, Receipt A for QTY = 20, Price = 12; Amount= 240;
2. Created Purchase Order, Receipt B for QTY = 10; Price = 15; Amount = 150;
On "Review Item Cost"
* Unit Cost is 13 because the formula is: ((20*12)+(10*15)) / (20+10)
* And the Costed Value is 390 because the formula is: 13*30 (onhand)
3. Created SO Shipment1; QTY = 5
On "Review Item Cost"
* The Unit Cost continues as 13
Tagged:
0