Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Inventory Revaluation

Posted on by Microsoft Employee

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. 

  • Guy Terry Profile Picture
    Guy Terry 28,484 Super User 2024 Season 2 on at
    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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,339 Super User 2024 Season 2 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,339 Super User 2024 Season 2 on at
    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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? 

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,484 Super User 2024 Season 2 on at
    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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans