Inventory Revaluation

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (3)

Guy Terry 28,837 Moderator on at

Like (0)

Report

RE: Inventory Revaluation

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.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

RE: Inventory Revaluation

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Revaluation

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?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

RE: Inventory Revaluation

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Revaluation

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?

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,837 Moderator on at

Like (0)

Report

RE: Inventory Revaluation

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.

Was this reply helpful? Yes No