Inventory Valuation report

Hi,

Inventory Valuation report does not match Inventory to GL Reconciliation Report. This happens on 3.6 with Std cost, after ran the periodic activities.

I thought that the Unit Cost on Inventory Valuation report = Cost Amount (Actual) (on Item Ledger Entry) / Remaining Qty

And INVENTORY VALUATION column on Inventory to GL Reconciliation Report should agree to the balances in the Inventory Valuation report. However it did not.

For example item A, on the Inventory to GL Reconciliation report, the Inventory Valuation column is $29.70 for the 1 pc in inventory. That is the standard which is correct. On the Inventory Valuation Report, the Unit Cost is $14.85 or the Average Cost of the transaction for 2 pcs that are still open from the transaction on 12/10/2003. Evaluation Journal was run on 12/31/04 to adjust unit cost from 0 to 29.7. Why Inventory Valuation Report shows 14.85 instead of 29.70?

Here are all the Item ledger entries for Item A

Posting Date Entry Type Item No. Quantity Invoiced Quantity Remaining Quantity Open Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invt.)
10/31/2003 Positive Adjmt. A 2 2 0 No 0 0 0
12/10/2003 Negative Adjmt. A -2 -2 0 No 0 0 0
12/10/2003 Positive Adjmt. A 2 2 1 Yes 0 29.7 0
12/29/2003 517000P Sale A -1 -1 0 No 45.26 0 0
5/25/2004 Negative Adjmt. A -1 -1 0 No 0 0 0
5/25/2004 Positive Adjmt. A 1 1 0 No 0 0 0

Thanks