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 :
Microsoft Dynamics AX (Archived)

AX 2009 Change inventory valuation method from weighted average to FIFO

(0) ShareShare
ReportReport
Posted on by 75

Can anyone tell me if there is a utility to accomplish this feat?  I see there is a utility to convert to standard cost.  So is there one to convert to FIFO as well?  Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    There is only a utility for converting to standard cost. This is introduced within AX2009 as the standard cost was newly introduced. It is a better option for "fixed purchase price" which was often used as standard cost in prior versions of AX.

  • RCarlson Profile Picture
    75 on at

    Thanks, Andre.  However, we want to change from Average Cost to FIFO.  How does one do that?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    First check if it is allowed to change and what rules applies to do this.

    This answer is just a suggestion, so first test in a separate environment before messing up!

    It is possible change the inventory model on your item model group.

    But you have to take care of correct postings. Except for Standard cost, you need te recalculate and close your inventory to have the appropriate costprice on the issued inventory transactions periodically. During daily postings an average cost is used for the inventory transactions. The real FIFO, LIFO or average cost will be applied by using the periodic closing and adjustment.

    Try if you can close your inventory on a given date and directly after, change the inventory model to FIFO. Then create some transactions, recalculate the transactions and see if some scenarios are working correctly.

    Again: first test, before you get in any trouble.

  • RCarlson Profile Picture
    75 on at

    Thanks Andre,  I will try that in our test environment.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans