Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

ModifyAll Item Costing Methods

(0) ShareShare
ReportReport
Posted on by 175

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 993 Super User 2024 Season 1 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 175 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 169 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,433 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans