Delete, renumber, or merge inventory items in Sage 100

Prepare before using the utility

• Clear or update all data entry tasks that include inventory items.
• Ensure exclusive access to inventory files.  
• Running it during active sessions causes errors.
• Have all users exit Sage 100 ERP.
• Stop related services on the server if required.
• No undo process so user MUST RESTORE from backup if the process stops, or has incorrect data.
• Best Practice: Run the process in a copy company first.

Change or merge item codes

1. Open Inventory Management, Utilities, Delete and Change Items.
2. Select the Change tab.
3. Enter the starting and ending item code. 
4. In the New Item Code, enter one of the following:
   • Existing item code for merge.
   • New item code for renumber.
   • "On the fly" item codes are allowed in the New Item Code field.
   • Errors can occur if costing methods are different.
5. Click Proceed.

Delete item codes

1. Open Inventory Management, Utilities, Delete and Change Items.
2. Select the Delete tab.
3. Enter the starting and ending item code.  
4. Click Select Files to open the Delete Item Files window.
5. Choose one of the following:
   • Select All Files Associated with Item
   • Clear that option and select specific files
6. Click OK.
7. Click Print, then print the Delete and Change Items Listing.
8. Use Print and Clear before deleting another item.
9. Click Proceed to delete the item.

Verify results

• Print the Item Delete, Renumber, Merge Log.
• Confirm the process was successful.
• Click Yes to clear the log file.
• If results are incorrect, restore immediately from the backup.