Stock Item Changes

Hello @u043,

You are correct the inventory needs to be zero before you make changes to valuation method and item class.  

We had a similar issue but could not wait for inventory to zero organically. I issued the inventory out by importing a spread sheet with the SKUs that needed to be changed. 

We ran an import scenario to update the valuation. 

We then exported the line items form the issue and received back the same inventory. 

Also if there are any pending transfers they will need to be closed before you make the changes. 

We did something similar.  I created a GI with all applicable fields needed to do an adjustment (including “QTY In” and “QTY Out”).  Next, I downloaded the spreadsheet and used the same spreadsheet in the “Adjustment” screen.  This made it easy cause the adjustment in and out was the same spreadsheet (mapping the QTY accordingly).  

The issue is that now I need to address all other transactions (PO, SO, Quotations).  This is a lot to coordinate.

Sometimes thousands.  One example of how we got here… We started by implementing purchase orders.  We created an item class called Component for all our raw materials.  We put this component class on all our purchased material.  As we start to build out, we wanted to break our raw materials into different item classes (what seems obvious now).  I build out the inventory adjustment as stated in this thread.  However, now I need to clear transactions on the PO to make these changes still.

Interesting scenario. 

Maybe you could have used matrix items where you would have an effective date in your matrix (instead of eg. color) . Of course now it is too late. I wonder whether that would have worked if you had started off with matrix items. 

Both your solutions are pretty good. 

Toon Six