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.

All data entry that affects inventory items must be updated prior to accessing this utility. Exclusive access to the inventory files is required. Having all users exit Sage 100 ERP is also recommended.

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 Existing or New item in the New Item Code field. When an existing item code is entered the Merge functionality is triggered. When a new item code is entered the Renumber functionality is triggered.
Click Proceed

Warning: If the starting and ending numbers are different, every number within that range will be selected. 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 check box to delete the item code from all available files.
To delete the item code from specific files, clear the All Files Associated with Item check box and select the appropriate check boxes. 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.
You must print and clear the listing before you can delete another item.
Click Proceed to begin item deletion.
The item code is deleted.

For Inventory version 4.3X and prior. (Legacy)

All data entry that affects inventory items must be updated prior to accessing this utility.
Exclusive access to the inventory files is required. Having all users exit Sage MAS 90 or 200 is also recommended.
- 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 be aborted.

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, every number within that range will be selected. 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 be aborted 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 cannot be selected 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 be deleted, renumbered, or merged.
Review the selections carefully. Click the Clear button to remove any undesired entries.
Note: Once Proceed is selected, this process cannot be reversed. Do not attempt to cancel the update.
Click Proceed to complete the process.
Print the Item Delete/Renumber/Merge Log and verify that the process completed successfully.
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
Using Copy and Paste may cause corrupt records if spaces are copied in the field