Hi,

Our inventory data has not been cleaned up for many years. There are 65% of items which have no sales for more than 999 days. Also, it takes so much space. We would like to get rid of those old items. Any good suggestions?

Thanks,

Mavis

Hi Mavis

It is generally not a good idea to delete old items - they tend to be stored in unexpected places and their deletion causes data corruption if you are not very careful.

What I recommend for my clients is the item number change feature of Toolkit for Adagio (www.dakotasoftware.com). It has the ability to merge two items together, which essentially deletes one of them. The trick is that I set up a new item called "Deleted Items" and merge hundreds or thousands of items into that new item. Since the toolkit searches through all the Adagio databases, it is much less likely to cause data corruption.

My trick is a little more complicated than I described above - if you want to know the full details, including an issue with units of measure and how to use Excel to speed up the process, ask me to continue.

Steve

Mavis:

Steve is correct in that just deleting the items is not a good idea as there can be a lot of references with the deleted item with your database.

The same Toolkit that Steve refers to also has a feature for deleting items where it will find all references of the item being delted and remove them. If you would like to acquire this toolkit please let me know.