Hi,
I am working on Nav 4. 0 sp3.
I could not find any difference between Average cost and Unit cost .
So I am throwing some queries to understand about the exact difference.
I gone through the Help for the Fields Average cost and Unit cost.
Average cost = The program calculates the average cost on the basis of the Cost Amount (Actual) field plus the Cost Amount (Expected) in the Value Entry table. The amount in this field is then divided by the sum of the quantities in the Item Ledger Entry Quantity field.
Unit cost : If you selected a costing method other than Standard, the program uses the following calculation for the unit cost:
Unit Cost = Inventory Value of items on hand (expected cost + invoiced cost) / Quantity on Hand
Both fields contain the same meaning .
Then what is the difference.
0
Comments
I am not a programmer, but clearly from the help the unit cost ONLY looks at the stock you have on hand. The average cost looks at every entry ever made.
actually speaking both values would be same. But unit cost will get updated on item card only when
item entry gets inovoiced(sales,purchase,adjustment).
e.g If GRN is made against PO, average cost is updated but unit cost will get updated
Senior Consultan