delete | Schulz Consulting

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)

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

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

Contact Us