web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Changing Item Price/ Item Price History

(0) ShareShare
ReportReport
Posted on by 95

Hello all,

I am using AX 2012 R3 CU13. We use the Standard Cost Costing type and are looking to update the price of an item (Manage costs > Item Price). When we do this, it appears that it updates the price for all of the inventory in the building. What I need it to do is simply update the cost of the item for anything that is received AFTER this price change. That way we can see how much we have of the item at x price and how much we have of the same item at y price. Could someone please explain to me how to make this happen? There is an activation date on the item price but when I set that to the current date it still updates all the inventory that is already received in.

Any help would be greatly appreciated!

Thank you,

Jeff

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Jeff,

    Updating the standard cost price will result in a revaluation of your inventory. You cannot 'switch off' this revaluation so that say because this is how this valuation method was built by MS.

    If you have no stock of that item then you can update the price as you want for the future. Yet, as soon as there is something available or even just recorded then you will see this revaluation process happening.

    Best regards,

    Ludwig

  • JHickey Profile Picture
    95 on at

    Ludwig,

    Thanks for the quick answer. It amazes me that this functionality doesn't exist, especially from an accounting aspect!

    Thanks,

    Jeff

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Jeff,

    This functionality actually exists but not for items that make use of the standard costing valuation method. If you would use Fifo, Lifo, Weighted average and other so-called current evaluation methods then things would work as you described and expect.

    Best regards,

    Ludwig

  • JHickey Profile Picture
    95 on at

    Ludwig,

    Okay that makes more sense. I am only looking to do this for a select few items in our system, would you happen to know the process for converting these to FIFO? I did some researching and found how to create a new FIFO model group but when I try to switch an item to that it throws this error:

    "The item is set to be evaluated by inventory model 'Standard cost'. The system cannot convert the item to be evaluated by an inventory model of type 'Transactions settled' only inventory models of type 'Transactions not settled' can be selected."

    I tried researching that and finding the steps I need to take in order to change these items to FIFO but I'm failing to come up with much on it.

    If you have any information on that I'd greatly appreciate it!

    Thank you,

    Jeff

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans