Inventory: Value difference between Inventory Valuation by Date report and Inventory Valuation by Date Enquiries utility

Learn how to resolve a difference between the Inventory Valuation by Date report and the Inventory Valuation by Date Enquiries utility, in Sage 200 Evolution.

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

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

However, this is the value on the Inventory Valuation by Date Enquiries utility for the same date as above. 

 

 

Consider the following advice to resolve the above issue:

One of the main reasons that may cause this issue 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.

However, also notice the Date Stamp value of 29 February 2016 11:05 and 11:06. These dates are after the last Invoice with a transaction date of 29 Feb 2016.

This means Evolution needs to recalculate the Unit/Average Cost as the end of January 2016 on the Valuation by Date report. This new valuation may therefore 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 only make use of the Valuation by Date Enquiries utility.

You should also discover that the Valuation by Date Enquiries utility corresponds with the relevant stock account’s GL Enquiries value for the same period. 

 

In addition, consider this link for a detailed article called:

Inventory: Difference-discrepancy between inventory valuation report and inventory control account