Deleting Inventory Items in Sage 100

Much like sifting through a clutter-filled attic, obsolete data can bog down the process of searching for relevant info. It can also present confusion, potentially causing incorrect files to be pulled.

Deleting inventory items in Sage 100 can seem daunting if dealing with large amounts of data. Here are some tips to help simplify the process. Note that this tip applies to Sage 100 versions 2015, 2014, 2013, and (MAS 90) v4.5.

Migration-banner - Micro Accounting

Disclaimer: Perform any modifications to your system at your own risk. By performing any of the steps in our tips or trick articles such as this one, you agree that there is a certain degree of risk associated with altering your system and agree not to hold MicroAccounting responsible if any alterations adversely affect your system. Read all instructions completely before performing any of the steps. If you have any modifications to your system, contact your reseller for assistance. If you have any reservations about making changes to your system, contact your reseller for assistance.

Can I use the “Delete” button and skip reading the rest of this post?
The “Delete” button is only available if a listed inventory item was never used in an order.

How does the “Delete and Change Items” utility work?
This utility allows the end user to delete or change an item that has been used in a previous order by entering its product name or code.

I have found it difficult to delete items that have any history, even if the quantity on hand is zero. This happens because when a record is left behind in the database, this prevents the corresponding item from being deleted.

To resolve this issue, within the “Delete and Change Items” utility, make sure the quantity of all items you wish to delete is zero. Then merge them all into a single item.

It is important to consider the valuation for the items being merged. Items can only be merged into an item of the same valuation. When looking to delete items with mismatching valuations, merge items with like quantities into several dummy items.

Run in a Test Company
Before running the “Delete and Change Items” utility in a live company, it is very important to first do this in a test company. This will ensure the desired result can be achieved. Also, it enables you to find out how much time is required. Planning alert: Depending on the amount of items, the process could take as long as 24 hours to complete.

The utility is actually pretty simple. First, click on the “Change” tab. Here, enter the item to merge as both the “Starting Item” AND “Ending Item.”

The number one mistake is not selecting the same Ending Item. If you make a different selection, the utility will incorporate a range of items to be merged into the new code. In the example below, we are merging into an item that starts with “ZZZ,” so it appears at the bottom of the item list. Also, the valuation of FIFO in the code indicates we will be merging all FIFO items.

Deleting Inventory Items in Sage 100 | MicroAccounting

Image 1

Click “Proceed.” Then, you will receive a report listing items that can be merged successfully, along with those with issues that prevent them from being merged.

Deleting Inventory Items in Sage 100 | MicroAccounting

Image 2

Deleting Inventory Items in Sage 100 | MicroAccounting

Image 3

Using Visual Integrator
Often customers have a great deal of items that need to be removed. Rather than hand keying each one, individually, a Visual Integrator import job can be written to bring items from an Excel spreadsheet into the utility. This is very useful to quickly first get items into the test company, then a second time into the live company.

After running a successful Merge in the test company, make a full back-up of the live company and run the process there. Keep in mind there is no “UNDO” button with this tool, so the back-up is the only option if the process does not run as expected.