Hi Team,

Clients have  reported that there are negative cost on the valuation report.

Cause of the negative stock.

1. Initial stock take was done and cost was 0.
2. Items sold as Price class in 2014 had issue where cost at POS order detail for these items were 0.
3. Since we are using the entire transaction history to calculate its cost, this caused negative cost. 

Suggestion to fix Cost

1.  Take the Valuation of the prior month and the valuation of the current month to calcuate the average cost.
   • For example, Novemeber valuation is 200 at $2.00
   • When valuation for December is run, it should look at the valuation for November and only the movement for December to  calculate the cost for valuation.
2. Take the last average cost of the prior month and add to the snap of the valuation

Justification

We need this feature so that we do not have to correct history data for 45 of our POS clients for their number of locations

The following have been completed:

1. Changed valuation formula to use last months value and add current month's movement to calculate the valuation.