Inventory Valuation Report error


Our Inventory Valuation report doesn’t generate ending balance accurately. I tried comparing it with inventory on hand with NAV using correct parameters like location, date filter and item no. but it definitely generates wrong values.

It is not also tally with the stock movement report w/c before is they generate same ending values.

Where do you you think is the problem?

Thank you so much.

NAV 5.0

MS SQL 2000