Sage 100 ERP 4.5+
Problem / Description:
MAS 200 SQL v4.5.5 Inventory, Utilities, Delete and Change Items. Getting “No Action – Item exists in inventory history.”
Resolution:
Apparently beginning with 4.5 the Delete utility changed. The Delete utility will remove all instances of an item from many different tables EXCEPT the IM_ItemTransactionHistory file. So…… if you want to delete an item all of its transaction history must first be deleted from IM_ItemTransactionHistory.
Possible workarounds
– Use Purge Item History : Inventory – Utilities – Purge Item History (NOTE: THIS APPEARS TO PURGE ALL HISTORY BY DATE RANGE AND IS NOT SELECTABLE BY AN ITEM NUMBER)
– Merge the item(s) into a single unused inventory number which sorts toward the bottom of any lookup list (i.e. – ZZZZ or 9999)
