Hi everyone! So I've joined a new company and my first task is to help in the conversion of our existing inventory to matrix items.
I'm going to list how I think this would happen, so please respond with your questions, concerns and guidance for this process.
1) First I need to create the lists for the various matrix options. Shirt Size, Drill Size, Color, Ladder Length etc.
2) Then I need to import a list of our existing items but as matrix items for the replacements.
3a) Then I need to swap the items wherever referenced on all open POs, SOs, IRs, IFs, anywhere else?
Or would you do this for both current and historical transactions? Is it possible for historical? I'm assuming not once periods have been closed, but it would be nice to keep the data.
I'm not sure how I would go about updating these records, it sounds like the most tedious process, particularly since this change is for about 1,200 items.
3b) And paired to that, I need to replace the inventory on hand with the new items. I would do this using inventory adjustments, either manually created or scripted.
All the items are inventory, no serialized or lot and also use bins.
For 3a and b, would you consider trying to script either? Or just a manual process of editing the open transactions found using a saved search and then inventory adjustments for the inventory on hand?
Appreciate your help!