Revaluation - Unit Cost

Jonathan2708

Hi,

I want to adjust my Unit Cost on the item card because at some point in the past there has been an error with costs entered and all ledger entries relating to it have been posted and used. The unit cost is currently showing 1.18 when the highest ever actual cost has been 1.10. I want to revalue the items at 1.10, but using the revaluation journal doesn't seem to help because it only looks at the recent open entries for which the costs are already 1.10, so it says 'Nothing to post'.

Can anybody suggest another way of adjusting my current unit cost? I'm using NAV 4.01, FIFO costing, expected cost posting, automatic cost posting, automatic cost adjustment = Always.

Any help appreciated,

Jonathan

Kowa

The function "Calculate Inventory Value" only revalues the current items in stock i.e. open item ledger entries , but you can revalue closed ( and open ) ILE's like this :
Open the Revaluation journal, enter the item no. and then go to the field "Applies-to Entry". Select the positive entry you want to revalue. This will automatically fill in all the other non-editable fields as well as the posting date. Then fill in the new unit cost in "Unit Cost (Revalued)" and post the journal. This will add a value entry to the positive item ledger entry to modify the "Cost Amount (Actual)" of the ILE. Then run report "Adjust Cost - Item Entries" to revalue the COGS of the item that were applied to this entry (if the automatic cost adjustment doesn't do that by itself).
But as the positve and negative inventory value flow balances out after this ( if ILE is closed => Remaining Qty. is 0), the current item cost won't change, only the historical item average cost if a date filter is applied to the item card for some day in the past up to the day the last item sale applied to this ILE was posted. But you can also revalue open entries this way, this will then change the average item cost.