Why is my Product Valuation report different if I run it today, but date it two months ago?
The system is unable to retain the Cost price at every given point.
If you receive an Apple in February for $1.00, in March for $1.25 and again in May for $1.55 and a Banana in February for $1.00 and this does not increase.
Printing the Product Valuation Report will show the cost price in March as $1.25. But if you were in May and ran the report dated February it would value the stock at the cost price of $1.55, because the cost price has increased. But the Banana will show the same cost price for each month.
This is why we recommend that you print or save the Product Valuation reports each month.
If you are seeing variances that cannot be explained by the latest cost changes please run from Products / Utilities - Product Integrity Check. Then run the report again.
Partners and Support also see