Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

No Action – Item Exists In Inventory History When Using Delete Utility on v4.5+

August 13, 2013 by Wayne Schulz

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)

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: delete, history, inventory

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021
  • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
  • Sage Announces Sage Partner Cloud December 16, 2020
  • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
  • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020
  • Sage 100 data conversion for version 2020.1 takes a long time or appears to hang on IM_LotSerialTransactionHistory when it contains a large number of transactions. December 8, 2020

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.