Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

ModifyAll Item Costing Methods

Posted on by 163

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.

Categories:
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 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 163 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 11,419 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,419 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/.../

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans