Change Costing Method from FIFO to Average Costing

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 2 Replies | 1 Follower

9 Posts
99 Points
Joined: 2013-4-18
Last Online:
2013-8-7 9:34
Location: Manama, Kingdom of Bahrain
Sujith posted on 2013-5-16 16:56


I am using Ms. Dynamics Nav 2009 R2 and my costing method followed currently is FIFO for my inventory and I want to change this to Average Costing.

When I try to change it shows the below error: You cannot change Costing Method because there are one or more open ledger entries for this item.

How can I change the Costing Method? Kindly help


All Replies

31 Posts
399 Points
Joined: 2011-8-12
Last Online:
2015-3-23 16:32
Location: ...
rriinnoo replied on 2013-5-16 23:35


there are several thread available in the forum where you can find interesting tips,

I strongly advise you to make a test db and test.


Microsoft suggest the following steps:
1. negative adj the item to zero. 
1a. make sure there are no partial po / so / to. 
2. run ACIE. 
3. renumber the item and block. 
4. create new item. 
5. positive adjust inventory

6. run ACIE


If you don't want create new items you can try:

1. negative adj the item to zero. 
1a.. make sure there are no partial po  /so / to
2. run ACIE. 
3. change item cost (via sql) 
4. positive adjust inventory

5. run ACIE


Good luck!

3,472 Posts
58,600 Points
Joined: 2006-4-10
Last Online:
2015-3-27 12:29
Location: Thailand / Pune India
Amol replied on 2013-5-17 5:34

It is showing message because you are trying to change the costing method for those item which is having inventory .IF you want to change the method then system will automatically adjust the cost according to new method



Don't forget to  the post(s) that solved your problem

Page 1 of 1 (3 items) | Get this RSS feed | Bookmark and Share