Right Method to Correct Costing Mistakes?

adamEthan

NAV 4.0 SP3

Unfortunately our controls weren't good enough, and various items were created with different costing methods, including average/fifo/standard. Transactions were processed with these items, including all sales processes, transfers, item journals. Many of the items have quantities at different locations.

What is the correct method to fix these mistakes and have all our items use the same costing method?

Is it:

1. complete any erroneous prod. orders / ship all sales ordes with items
2. item journal out every single item / lot so that every item has a quantity of 0 with no open issues
3. Change costing method
4. Item journal back in every lot/quantity for each item

Please advise, we are looking to fix asap.


as always!

thanks!

-adam

adamEthan

I intended on followed these steps in a test company:

1. negative adj the item to zero.
2. make sure there are no partial po and so.
3. run adjust cost.
4. positive adjust inventory

But get the:

"You cannot change costing method because there are 1 or more entries for this item."

jannestig

I just did this for a client changing all item from Fifo to standard which is an easier scenario to do, i changed the methdology after removing or stock and value then ran a report to change the physical value.

This has worked so far without an costing issue.

On partnersource there is an article about recommendations to changing costing methodology.

Alex_Chow

Microsoft recommends that you rename the item and create new items in its place.

The only problem with that is you lose all history...

adamEthan

Is there anyway to reassociate the history with the items after they are moved? any way to combine items? or is it all a big mess?

can anyone recommend a "manufacturing costing" book that I could read to get a better grasp on how to handle the costing inside of navision?

thanks as always

Alex_Chow

adamEthan wrote:

Is there anyway to reassociate the history with the items after they are moved? any way to combine items? or is it all a big mess?

can anyone recommend a "manufacturing costing" book that I could read to get a better grasp on how to handle the costing inside of navision?

thanks as always

You can download the Inventory & Costing course book on Customer Source. It's the manual used to train implementors and consultants.