Since duplication of items cannot be totally eliminated, once in a while we do come across duplication of items , that is, two different codes of a single item .Some ORG use one code while the other uses the second code
How to handle this situation
Is there any functionality to merge the codes making them one ?
Is there anyw ay to transfer all the transactions of one code to the other code and making the first one inactive afterwards?
Or any other functionality
I am sure everyone using Inventory/purchasing comes across this problem
The tough part is is how to you identify duplicate items.
Once you have done that, you can decide upon the item number to keep and adjust the inventory to the new item by doing a misc. issue/receipt. You also have to change open PO / Sales orders.
There is no way to go back and adjust older transactions.
Hope this answers your question