Inventory Valuation report

trin

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

Savatage

this has been an issue for as long as I've used Navision

http://www.mibuso.com/forum/viewtopic.php?t=8503

Alex_Chow

There's actually no issue with Navision costing.

From what I see on the entries that's made, the positive adjment and negative adjustment on 12/10/2003 is what's making the average cost $14.85.

The reason is because on 12/10/03, the total quantity on hand is 4 pieces. It's using the 4 pieces / $29.70 to get your per unit cost.

If the positive adjustment was on 12/11/03, then the cost of the sale for 2 pieces would be $29.70.

Also, with standard cost, you'll need to run the Inventory - Cost Variance report so you can see the variance between your actual cost and standard cost is.

search1110

run adjustment items cost procedure, check the type of the period or update NAV up to v5.