Share
ReportHi all,
How to adjust the inventory cost without disturbing the quantity where the costing method is average in NAV 2013 R2?
Thanks & Regards,
Saravanan A
*This post is locked for comments
You’re offline. This is a read only version of the page.
65
Hi all,
How to adjust the inventory cost without disturbing the quantity where the costing method is average in NAV 2013 R2?
Thanks & Regards,
Saravanan A
*This post is locked for comments
Hi Sarvanan,
Can you please elaborate on the reason why you want to revalue the cost after the Item has been received? Usually the revaluation journal is used in exceptional situations. In case additional costs need to be loaded on the items, you can load it through the Item Charges.
In Cumulative Update 9, reference 359734, this has been changed to, again, allow revaluation of individual entry i.e. enter a line manually in the journal and select a specific entry in the "Applies-to-Entry" field.
As per the Average Costing method logic, you would not be able to adjust the specific Item Ledger entries.
However you can always, revalue particular Item as on specific dates.
Just go to Revaluation Journal -> Function -> Calculate Inventory Value -> Choose the Posting date (for the date you want to revalue Item Costing).
It would fetch the balance quantity and related value as on that posting date. Put the actual Inventory Value and post the journal.
Regards,
Vishal Salot
//If this answers helped you, please mark it as verified.
So, as I now understand, you have some quantity of this item, which has arrived in different installments (wrhs receipts), and you want to revaluate the exact installment? If you are using the average costing method, you can't do this as it would be against the "average" concept itself. One option is to post credit-memo that would kill the initial receipt, and post a new one. I wonder what is the reason for that, as you will later anyway use "average" write-off?
If you want to write-off further a specific lot of the item, you should create another item card that would not use "average" method and transfer the cost to that one, using separate lots.
No, it says "You cannot revalue individual item ledger entries for items that use the average costing method".
In the revaluation journal there should be a filed "Applies-to Entry", where you can select the specific Item Ledger Entry No. for revaluation. Would that fit your needs?
Using revaluation journal, i can able to adjust for item only when the costing method is average. But is there any way to adjust for specific Item ledger entry alone and that should not be adjusted when we run ACIE job?
You can always do this in the item revaluation journal. You need to select the item and then enter a new desired cost. The difference will be posted.
All responses (
Answers (
