We have an item that was physically made wrong. The manufacturing order(MO) shows the status changed to complete on 1-29-19. After finding the item was made wrong, a user unlinked the MO from the SOP, thinking that he could use the same MO number, and change the item number that it was linked to. After realizing that couldn't be done, he tried to change the status of the MO to complete. We get the error "The status of this manufacturing order couldn't be changed because one or more picklist items have been issued, or a purchase order has been issued for items needed for this manufacturing order."
What needs to be done, to change the status of this MO number? Do we need to re-link the MO to the SOP? Do I just change the status on the PK010033 and WO010032 tables? I don't want to just change it in SQL, because I know there are a bunch of tables that Manufacturing uses. So what options do we have?
------------------------------
Chase Landorf
Director of I.T.
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------