Hi Gurus,
Our company is planning to move costing method from FIFO to average costing. We know that once items are set up, costing method can no longer be changed. Doing this therefore is like doing a cut-over/re-migration of inventory item master. I would like to know the best practices or specific steps towards this. I am thinking:
- Obtain a snapshot of current inventory value and count
- Flag the items with the old costing method
- Create new items with the new costing method
- Remove the inventory from the old item
- Inactivate old items
- Increase inventory of the new items in the proper location - via adjust inventory worksheet
- Perform series of validations to confirm that the inventory value and quantities were unchanged following the conversion
What we would like to ensure as well is the continuity of reports even after performing this change.
What are the watch-outs/key considerations?
If you could lead me to other useful resources that would be great, as well as experience for those who has done this before.
I will be grateful if you can send me this information. Thank you.