We did stockcount on August 31, 2008. The item valuation report as at August 31 2008 was printed on September 22 2008. What I have noticed is that I have an Average Unit Value, I have the quantity and then I have the actual cost. If I multiply the average unit value by the quantity I do not get the amount reported for actual cost for some items. Further, the average unit value for these same items is way out. If I divide the actual units by the actual cost I get the correct cost per unit.
Another problem is that the stock card shows a different quantity on hand than the August 31st report. I printed it again today for the August 31 2008 date and the particular item I am watching now agrees to the stock card and the average unit value agrees to the correct unit cost. I can not see where any adjustment was done to bring this in line.
Unfortunately there is not report that shows the quantity on hand and valuation after each transaction i.e. shipment, adjustment, receipt etc. I do not have Gridview.
Do you have any idea why the costs and quantity would vary for the same date. Especially when other items have retained the exact information as the earlier printed report.