Weighted average cost method -

kartik5295

We are using NAV 5.0 Version.

As per Inventory Set up, the average cost calculation type is 'Item & location & Variant'.

Average Cost Period is Day.

the following is the inventory ledger of a part no.


posting date Document No. Entry Type Item No. Location Code Quantity Cost Amount (Actual)
19-Oct-10 M-SFTR01810 Transfer IN960023 U1 PROD 4 227,917.25
26-Oct-10 M-SFTR01833 Transfer IN960023 U1 PROD 1 57,451.93
26-Oct-10 RC-02816 Consumption IN960023 U1 PROD -4 -228,295.34


the weighted average cost is (227917.25+57451.93) / (4+1) is 57073.84
The receipt of 4 qty entry has been applied to the issue entry.

but still the cost do not match.

Can anyone help me understand what could have gone wrong?

Alex_Chow

Run the Adjust Cost - Item Entries process before you do any inventory analysis.