Historical Inventory Valuation

I have a client who needs to find the value of his inventory as of end of last year. I tried to use Report 10138 (Inventory to G/L Reconcile) but it doesn’t work that way. Can anyone tell me how I can get this information? Darren Bezzant, NCPS, NCSD Central Software Ludlow, New Brunswick, Canada dbz@nb.aibn.com

Hi, You need to create FLOW field in the Item table. Copy field “Net Change” and change calculated field “Quantity” on “Adjusted Cost (Qty.)”. Add field “Adjusted Cost (Qty.)” to SummIndexFields in the second key in Item Ledger Entry table. Crete report based on Item table that will summ this field. Set filter on “Date Filter” field: …12/31/00. Valentin Gvozdev BMI Inc.