Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

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)

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

How to remove graphical Sage 100 ERP forms which don’t appear in Report Manager

November 10, 2012 by Wayne Schulz

Have you ever had this happen in Sage 100 (formerly Sage ERP MAS 90 or MAS 200)?

You create any number of graphical forms – only to find that over a period of time some of them never get used. In an effort to clean up your system you try to delete the form(s) via the standard Report Manager process.  Upon navigating to the Report Manager you find that your form(s) for some reason (typically we see this with customers who’ve been using the software for quite some time) the form(s) you wish to delete are not present.

Wish there was a way to delete these wayward forms once and for all?

There is — and here’s the answer:

 

Version(s):

4.10+

Problem / Description:

How to remove graphical forms (checks, invoices, etc) which do not show in the Sage 100 ERP Report Manager and therefore cannot be removed via standard functionality

Resolution:

 

* References to the form code must be removed manually:

* Expand Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance (DFDM).

* In the File Name field, select the …\MAS_SYSTEM\SY_ReportSetting.M4T file.

* Delete the key associated with the form code. Repeat this step for the following files:

* SY_ReportOption.M4T

* SY_LastFormUsed.M4T

* In Windows Explorer, browse to the …\MAS90\MAS_xxx\Reports\ folder.

* Delete the folder associated with the form code.
Note: Review the SY_Company file in DFDM and match the Company Key with the company name to determine the correct records to delete. As always, make a backup prior to making changes to files in DFDM.

 

 

Date Created: 11/10/12

Created By: WES

 

 

 

Filed Under: Sage 100 ERP Tagged With: delete, graphical forms, mas200, remove, sage 100, Sage 100 ERP

Sage 100 ERP (fka Sage ERP MAS 90 or 200): Slow Renumber of Accounts Receivable Customers and Data

August 30, 2012 by Wayne Schulz

Just a heads up on an interesting tech topic being discussed over on 90 Minds. In version 4.5 of Sage 100 ERP the time it takes to delete/renumber/merge large numbers of customers is apparently quite daunting.

One of our members is troubleshooting a way to do 20,000 of them which he computes could take 3 months of processing (I’m probably paraphrasing this but it’s a long time).

If you are in a situation where a new or existing customer asks you about renumbering AR customers – keep this speed situation in mind. It’s not something that is really easy to test short of running a trial renumber on a copy of the customer data.

 

We’ll update you if there is a workaround uncovered

 

Slow Renumber of Sage 100 ERP Accounts Receivable in V4.50

Filed Under: Sage 100 ERP Tagged With: delete, mas200, merge, renumber, sage 100, Sage 100 ERP, slow

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

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