Print out of Inventory value calculated back to a prior date shows Average Unit value, Quantity on Hand, Actual Cost, but what do these numbers mean?

Try calculating Inventory Sample data back to 4/12/2001, before the May 2001 transactions. 1st Item - BKH.UNI-001 - Actual Cost of 3248.23/18 equals 180.46, not the average unit value shown of 232.02.

After running a dayend, the average unit value of the 14 remaining in inventory is 178.86 when running a current report.

Calculated back to 5/12/01, before the last shipment of 1, Actual Cost Value is $2690.11 divided by 15 is 179.34. Report shows average unit value as 192.15.

Even stranger is BKM.ROY.003. At 4/30/01 Q = 15, Actual = 8.55, Average = .34. After receipt of 10 in 6/2001, Q = 25, Actual = 3458.88, Average = 138.36


Edited by Kate Spontak (05/12/09 05:58 PM)
_________________________
Kate Spontak
Stief Group
New Jersey, the Garden State