Moving from FIFO to Standard costing in Navision

bhupendra

My problem is to move Costing method for all items in database irrespective of no. of company exists in the database.

There is a way to do so as given below steps:

1 For the item in question, reduce the quantity on hand to zero by making a negative adjustment.
2 Rename the item in question.
3 Create a new item and give it the name of the original item.
4 Set up a correct costing method for the new item.
5 For the new item, increase the quantity on hand to the original amount by making a positive adjustment.


Is there any other way to move items costing methods from FIFO to Standard?

considering all setup related to inventory and manufacturing..like Production BOM,Routing so that any changes must reflect in all these parameters.

Pls help?

engghimanshu

Sorry there is no other way !!

themave

Why go through the step of renaming the records and then creating new ones. You can make a dataport to change the costing method instead. Just as long as you make sure your inventory quatities are zero and you have run the adjust item cost routine. all your values should be closed and you won't have a problem.

scunha@bemisworldwide.com

We had the same issue, where we were using Standard costing, but forgot to change new items from FIFO to Standard... Suresh a developer from Tectura wrote a small piece of code to change to Standard.... one important thing you need to do after the change is to update your SKU cost entries if you are using them... the costs do not automatically get updated...otherwise all values on your invoice PO's will go to PPV

The code actually runs in a report... If you are comfortable editing the Cal Code in a report to update the items in question, I would be happy to share it with you.

We are running v4.0

bhupendra

Dear Themave and scunha,

Thank you very much for the great help.
Suggestions from both you seem quite good.

Dear Themave
could you plz explain me the steps in details,becuase I don't want to miss any steps while doing this.

Dear Scunha

I am quite comfortable editing the Cal Code in a report to update the items in question, I would be happy if you could share it with me.

Thank you again.

FPulsfort

Hi Themave,

please consider that e.g. all purchase and sales orders which have been shipped must be invoiced completely before you run the adjust item cost routine. If there are some which are not invoiced the item ledger entry will stay open.

I think the renaming way is a better one.

Regards
Frank

themave

Here are the steps I would take,

1. Make sure all items are cleared off of Sales Orders and Purchase Orders
2. For the item in question, reduce the quantity on hand to zero by making a negative adjustment.
3. Run Adjust/cost item entries routine.
4. Post Inventory cost to G/L
5. use dataport with two fields.
Item No. and Costing Method
to change the costing method to standard
6. make a positive adjustment journal to bring the item back into inventory

The advantage you have over renaming the item, is that you don't loose all the history on the item. And you do not add another item card, that ends up staying in Navision for ever.

themave

Here are the steps I would take,

1. Make sure all items are cleared off of Sales Orders and Purchase Orders
2. For the item in question, reduce the quantity on hand to zero by making a negative adjustment.
3. Run Adjust/cost item entries routine.
4. Post Inventory cost to G/L
5. use dataport with two fields.
Item No. and Costing Method
to change the costing method to standard
6. make a positive adjustment journal to bring the item back into inventory

The advantage you have over renaming the item, is that you don't loose all the history on the item. And you do not add another item card, that ends up staying in Navision for ever.

bhupendra

Dear Themave & FPulsfort,

Thank you very much for your precious suggestion.