Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / ModifyAll Item Costing...
Small and medium business | Business Central, N...
Suggested answer

ModifyAll Item Costing Methods

(0) ShareShare
ReportReport
Posted on by AntonisK 177

Greetings to all of you.

CASE: My customer needs to change all of his items costing method, from average to FIFO. 

The items have already related ledger entries which means that i am not capable of modifying the value of the costing method , within BC.

Due to that , i am trying to create a codeunit which will allow me to do so.

This is what i tried to do.

pastedimage1646905425071v1.png

pastedimage1646905453770v2.png

Unfortunately , when i press the action button within BC, nothing happens.

Am i missing anything? It's really important for us to solve this case because we need to avoid renaming the old item codes and create new ons from scratch.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: ModifyAll Item Costing Methods
    [quote user="MahGah"]

    Hi

    I just want to point out that changing costing method in BC without following proper steps will cause issue in finance side. Please make sure your team is aware of that. it could cause discrepancy in accounts and inventory, and some others. Please see below article for proper method. Article also has recommended method to change costing method. 

    www.dynamicsnavconsultant.com/.../

    [/quote]

    One thing i would add to the list in the blog you refer to is to make sure to run the  “Post Inventory Cost to G/L” report.

    Posting is usually done when you adjust the cost, but there is an option to skip it and in case that option have been used i thing it would be a must to run it manually just to be on the safe side.

  • AntonisK Profile Picture
    AntonisK 177 on at
    RE: ModifyAll Item Costing Methods

    MahGah  , Dallefeld .

    Firstly, thanks a lot for your help.

    I managed, with the aid of a custom codeunit to change the costing method on my items.

    Before that , i haven't post any cost on g/l accounts ( adjust item cost entries have never run before).Since this is going to be the first time running it , is it possible that the change of the costing method wont cause a problem?

    For now , i have noticed that, even thought the costing method has changed on the item cards, when i am trying to run the adjust item cost/price , the system doesn't create any new value entries to modify the cost amount

    What do you think?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: ModifyAll Item Costing Methods

    Adding to MahGah's statement....

    Do NOT just force a change of the costing method on the item card. You need to do this correctly or you will create more costing problems.

    The link that MahGah gave you spells things out very nicely, so please follow these steps.

    I personally have done these changes following Alex Chow's steps and it works perfectly but I would add one more thing. Execute in a Test company first.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,435 on at
    RE: ModifyAll Item Costing Methods

    Hi

    I just want to point out that changing costing method in BC without following proper steps will cause issue in finance side. Please make sure your team is aware of that. it could cause discrepancy in accounts and inventory, and some others. Please see below article for proper method. Article also has recommended method to change costing method. 

    www.dynamicsnavconsultant.com/.../

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans