We would like to clean up our item database, hopefully without causing a bunch of data integrity errors. What are all of things I need to check for before deleting items? Obviously they can't be on current sales orders or PO's, but what else?
Any info is appreciated. Thanks!

Hi Kristin

To avoid integrity errors, they can't be on current or historical invoices either. Or historical purchase orders or receipts.

It's best not to delete items, but rather to make them inactive. If you have access to Toolkit for Adagio (http://www.dakotasoftware.com/toolkit.html) a better strategy is to merge them all into one obsolete item code (actually one for each stocking unit of measure). That way the history is preserved, data integrity is clean, yet the item list is trimmed.

Steve

Thanks Steve, we will make them inactive, we don't have Toolkit.