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

ModifyAll Item Costing Methods

(0) Share

Report

Posted on by AntonisK

238

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.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
AntonisK 238 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,511 on at

Like (0)

Report

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/.../

Was this reply helpful? Yes No