Hello,
What is the right way to calculate Inventory valuation? I know there is a report for this but I am not able to figure it out.
I have made a report that is grouping articles by location code and then calculates inventory valuation for this. In my report valuation is just a summa of
Cost Amount (Actual) field in Item Ledger Entry table. This is not right approach?
If you cannot figure out the standard report what chance do you have of writing one that is accurate?
If you take the cost amount actual what are you doing with stock booked in that is not invoiced?
Understand the current one, it is correct and is a hell of a lot easier than writing your own.
The right way to calculate inventory valuation is the Navision way! [:D]
Do not try to invent one yourself.