You’re offline. This is a read only version of the page.
Announcements
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.
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.
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.
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?
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.
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.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
232,996
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
