I processed an inventory item revaluation journal by location by variant, and applied it to the item ledger entry. Posted the journal. Ran the Periodic activity Adjust cost item entries. Cost posted to g/l was the correct decreased stock value. When I run the Inventory Valuation Report the cost for that item is incorrect. The cost reflects the value of the adjustment and not the correct revalued cost. Because the item was devalued I now have a negative value for that item. Can anyone tell me why the Valuation report is incorrect and how to fix it please?
Hi Ann I have just created an item and purchase received 10 in at 8.90, invoicing at this cost. The valuation ran at £89.00. I then ran a revaluation journal specifying the unit cost revalued as £8.80 which in turn gave a inventory value (revalued) figure as £88.00. I then ran the adjust cost-item routine and the value remained at £88.00. Therefore this seems to be working on my version (3.60). What version are you running? Is your valuation report modified?
Hi Steven, I am working on Navision version 3.7. The entry which was revalued has the new correct cost in the item ledger entry table and the value entries show the original cost and the revalued cost correctly. As far as I can see the Valuation Report is the standard Navision report without modifications. The problem is that the client processed numerous negative adjustments in an attempt to fix the problem and those entries cannot be revalued. Maybe that is throwing the Valuation out? I did try to attach an excel file for you to have a look at the entries but wasn’t successful!
Hi Ann I ran this through in 3.70 and got the same results. Unsure on the negative adjustment issues. Theoretically the inventory is revalued so if the negative entries are applied to the inbound transaction they are closed and therefore form no impact. So the entry type revaluation has the cost amount actual as the revalued difference and the cost per unit in teh revaluaiton is the unit difference? The Item Ledger Entry shows the Cost Amount (Actual) as the new item cost? What is your costing method? Unit cost on the item card?
Hi Steven, The costing method is Average. The unit cost on the item card is R398.72 which is correct. Yes the entry type revaluation has the cost amount actual as the revalued difference. Yes the cost per unit in the revaluation is the unit difference and yes the item ledger entry shows the cost amount (actual) as the new item cost. That’s why I don’t understand why the Inventory Valuation report is incorrect. The report I am using should be a standard report 1001 called Inventory Valuation? Thanks for your input!
Hi Ann I think you should eliminate anything that is not related to this particular item. If you have a test system, load on a simple example. If this processes okay then it will be due to the transactions against this item. When you run the inventory valuation you define dates, can you leave the starting date blank and ensure the ending date is beyond all transactions for the item and see if this makes a difference.
hi Steve, tried the dates with the report but no changes - still gives the same answers! Many thanks!
I suggest trying it with a new item, and then when this works ([:D]) you will need to see what in teh transactions of the problematic item is causing the valuation to report in the manner it is. Sorry for being so vague - it is difficult ot answer specifics of this nature. Good luck!
Many thanks Steven for all your suggestions! I will try with a new item. If I get it right then I’ll let you know. Kind regards Ann