How to delete, renumber, or merge inventory items

Use the Delete and Change Items window to delete or change item codes. You can also merge item information by changing an item code to an existing code.

Clear or update ALL Data Entry tasks, which contain inventory items before using this utility. Exclusive access to the inventory files is necessary. Have all users exit Sage 100 ERP and stop the service on the server if applicable.

Sage 100 ERP 4.4 and later (Business Framework)

To Change or Merge:

Open Inventory Management, Utilities, Delete and Change Items.
Go to Change tab.
Entering Starting and Ending Item Code.
Enter an Existing or New item in the New Item Code field. When entering an existing item code, the Merge functionality is available. When entering a new item code, the Renumber functionality is available.
Click Proceed.

Warning: If the starting and ending numbers are different, the change will apply to every number within that range. For example, if 'Starting' = 1 and 'Ending' = 5, the change will affect items 1,2,3,4,5.

To Delete:

Open Inventory Management, Utilities, Delete and Change Items.
Delete tab enter Starting Item Code and Ending Item Code.
Click the Select Files button. The Delete Item Files window opens.
Select the All Files Associated with Item checkbox to delete the item code from all available files.
To delete the item code from specific files, clear the All Files Associated with Item checkbox. Then select the appropriate checkboxes. Click OK. For more information.
In the Delete and Change Items window, click the Print button.
In the Delete and Change Items Listing window, click Print.
Use the print and clear buttons for the listing before you can delete another item.
Click Proceed to begin item deletion.
The item code removed.

For Inventory version 4.3X and prior. (Legacy)

All users must exit so the utility has exclusive access to Inventory files.
If a selected item is in a purchase order or sales order:
- Renumber and merge processes will change the item number on the 'Lines' tab.
- The deletion process will abort.

Open Inventory Management, Setup, Inventory Management Utilities.
Select the Item Delete/Renumber/Merge radio button and click Proceed. The 'Item Delete/Renumber/Merge' window opens.
Select the desired item number or numbers from the Starting Item No. and Ending Item No. lookup lists.
Warning: If the starting and ending numbers are different, the change will affect every number within that range. For example, if 'Starting' = 1 and 'Ending' = 5, the change will affect items 1,2,3,4,5.
Select the appropriate method in the 'Change Method' field.
- Delete - Verify that the quantity on hand is 0 for all warehouses. If any quantities still exist, the deletion will abort and an error will print on the Delete/Renumber/Merge Log.
- Renumber - Enter the new item number in the New/Merge Item/No field.
  Note: Renumber isn’t a choice for a range of item numbers.
- Merge - Select the target item number to merge the data into.
Click OK. The data displays in the lower portion of the window.
Repeat the above steps for any other items to delete, renumber, or merge.
Review the selections carefully. Click the Clear.
button to remove any undesired entries.
Note: After clicking Proceed, this process it’s too late to stop or reverse. Don’t attempt to cancel the update.
Click Proceed to complete the process.
Print the Item Delete/Renumber/Merge Log and verify that the process was successful.
Click Yes at the Clear the Delete/Renumber/Merge log file? dialog box.

Additional information:

New "On the Fly" item codes can be created in the Change Tab.