When an internal part number is changed to "Inactive", it will change all customer part numbers to "Inactive" as well, if those customer part numbers do not have qty OH, open SO, use in BOM, open Kit.....  If the system finds any of these conditions to be true it will not allow the status to be changed on the customer part or the internal part.

Even if a customer part number is "Inactive", it doesn't mean it's ok to be archived.  If a customer part number meets the archive criteria, it will be listed in the archive list.  Let's say, I have an internal part number with 2 customer part numbers associated, if all three part numbers meet the archive criteria, then all three will be listed on the archive list for user to select.  If user selects one customer part number to archive without selecting internal part number, only the customer part number will be archived.  If user selects internal part number to archive without selecting customer part numbers to archive, the program will archive those two customer part numbers also.

When a new part is created, the program will check to see if the same part number already exists in archived database, if yes, then user can not add the same part number again.

When changing the status of a part from "Active" to "Inactive"  or "Archiving" a part the program is checking the "item" status not the "order" status.  So the system will allow user to archive a product/part number that is listed on a Sales Order, Purchase Order, Work Order, etc. if that item has been cancelled or closed.  It will not affect other items listed on the SO, PO, WO, etc. that are still open or have a balance.  The system will not allow user to view/modify this SO, PO WO, etc and a message will pop up telling the user that a part number has been archived from this order and will have to be restored before continuing.  The reason this order may not be viewed/modified is because there might be a total amount that will not display correctly if the archived item is not displayed. 

The "restore" part list will display the internal part numbers and the customer part numbers that have been archived.   If the user only selects customer part number to restore and doesn't select internal part number to restore, the program will restore internal part number as well.

After parts have been restored, if the material types are no longer in current system setup, the program will change those deleted material types to "UNK"