Hi everybody:
I am working with Navision 5.0 on Ms SQL Server 2005, and we seem to be getting quite strange results from the Inventory Valuation report, in particular: sales / purchases of material & stock variation don’t seem to add up.
Furthermore, in order to produce one value of the Inventory Valuation report for a given date I may have to wait for up to half an hour.
I am thinking there is something wrong with our configuration or with our processes.
I know it has to do with [Value Entry] and [Item Ledger Entry] but no query on these 2 tables alone seem to reproduce the values of the Inventory Valuation report.
From the few things I have read on this site there are more tables involved.
In order to understand the mechanics of it & run checks, I am interested in is:
the SQL query equivalent of the Inventory Valuation report.
Thanks in advance.