Inventory: Difference in values may exist between the Inventory Valuation by Date report and Inventory Valuation by Date Enquiries utility

This article explains why a difference in values may exist between the Inventory Valuation by Date report and Inventory Valuation by Date Enquiries utility.

For example, this is the report value as on 31 January 2016:

And this is the value on the Inventory Valuation by Date Enquiries utility

One of the main reasons that may cause this difference is due to back dated stock related transactions.

In this case, notice the two (an Invoice and GRV) transactions below, processed respectively 5 and 7 January 2016, but also notice the Date Stamp value of 29 February 2016 11:05 and 11:06 (being even after the last Invoice with transaction date of 29 Feb 2016).

The result is that Evolution needs to recalculate the Unit/Average Cost as the end of January 2016 on the Valuation by Date report and this new valuation may not correspond with the Inventory Valuation by Date Enquiries value.

In conclusion:

Whenever there are any back dated transactions in the company, the Valuation by Date report should rather not be used and the user should exclusively make use of the Valuation by Date Enquiries utility.

Users will also discover that the Valuation by Date Enquiries utility should also neatly correspond with the relevant stock account’s GL Enquiries value for the same period.