Hi,
I'm not quite understand about inventory revaluation on AX 2012. AFAIK, there are several things about revaluation :
1. we can only make revaluation for on hand inventory only. is there any way so I can make revaluation on item that have been sold? and does revaluation made some effect on issue entry COGS?
2. revaluation can only be done on Moving Average Costing. can I make revaluation on another costing method?
thanks in advance.
*This post is locked for comments
Hi blueberrycheesecake,
Sorry, I forgot about the 'Adjust transactions' functionality. André seems to have all your questions covered. I'd only add something about that the message 'Items set to be evaluated by the inventory models of type 'Transactions not settled' cannot be transaction adjusted...' you can get when using the 'Adjust transactions' form. I recently asked a developer to debug it to tell me what 'Inventory models of type Transactions not settled' meant.
To cut a long story short, we ended up looking at some classes called 'InventModelType' and the up shot was what you already know. All Inventory Models can be Transaction adjusted, except Moving average and Standard Cost. And all Inventory Models can be On hand adjusted, except Standard Cost.
Hi,
Also standard cost will only revaluate the current on-hand. It cannot adjust receipts either. Also this model is skipped during inventory closing and recalculations.
Hi,
how about standard cost? Guy said, I just have to change the active cost price. will my revaluated cost affecting the COGS of the issue transaction as well?
HI,
With the moving average you can't adjust historical transactions as it is calculating the moving average per transaction. The target was to have an inventory model which would make the recalculation and closing not needed. As the moving average model is skipped during the recalculations, you can't adjust the receipts. This is indeed different compared to e.g. FIFO.
You can read all about the moving average in this whitepaper: www.microsoft.com/.../details.aspx
Hi Guy,
I'm sorry I'm not good enough in explaining my problem :)
what I meant is I want to change the cost of the receipt item that have been sold, using revaluation, and I expect system will made adjustment on the COGS of the issue transaction.
I've read the link that you give and I try to make adjustment with costing method Moving Average. I can only select my on hand inventory. I can't select my receipt transaction.
but when I try it with item that has costing method FIFO, it works like I expected. I can choose the receipt transaction, change the cost, then I post it. when I run recalculation again, system adjust the COGS of the issue transaction.
Is there any way to do revaluation on item with costing model Moving Average like what I did on the FIFO model?
Hi blueberrycheesecake,
2. You can revalue on hand inventory no matter which inventory model you are using. If using one of the other actual costing models, you can use the On hand adjustment form.
technet.microsoft.com/.../aa553861.aspx
If using standard cost, I believe you just have to change the active cost price.
1. You can revalue items that have been sold using Inventory close. The sold items will be revalued using the rules associated to the actual costing model that you are using.
I cannot think of a way where you can pick a cost amount from thin air and assign it to a sale. The only method you have to overrule the costing model is to use inventory marking to assign the cost of a particular receipt to a sale.
#1
André Arnaud de Cal...
291,642
Super User 2024 Season 2
#2
Martin Dráb
230,371
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
