The Remaining in WIP Smartlist shows quantities remaining for a closed Manufacturing Order

When an MO is closed, there should be no quantities remaining in WIP for any components.

The table that holds the quantities still assigned to a MO is the MOP1000. The MOP1000 is the MOP Stack WIP table. It holds how many items were issued to WIP (QTYRECVD) and the quantity consumed by the MO Receipt. When an MO is closed, all lines for the MO should be removed from the table. If there was some type of issue with the MO close process, these records may not have gotten removed. And they will still appear on the Remaining in WIP Smartlist.

Steps to resolve

Go to Transactions | Manufacturing | Manufacturing Orders | MO Entry and verify the MO has a status of Closed and not just Completed.   If the MO is only in Completed status, go to Transactions | Manufacturing | Manufacturing Orders | Component Transaction Entry and do a reverse issue of the components. If you are unable to do the reverse issue, contact the support desk.

Run the below script to determine for closed MO.

select * from MOP1000 where MANUFACTUREORDER_I in (select MANUFACTUREORDER_I from WO010032 where MANUFACTUREORDER_I= '8')

Run the below script to delete these records.

delete MOP1000 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)

If records were stranded in the MOP1000 for the closed MO, it may be stranded in other tables as well. Run the below scripts to remove the records from other table where they should not appear. Then run an Inventory Reconcile.

delete MOP1400 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)

delete MOP1410 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)

delete MOP1020 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)

delete MOP1025 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)

delete MOP1026 where manufactureorder_i in

(select manufactureorder_i from wo010032 where manufactureorderst_i=8)