Schulz Consulting

Consulting and Upgrades

  • 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)

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

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?
  • Sage 100 Payroll Tax Update Set for 10/27/22 for New York State Health Care Workers Bonus Program (HWB)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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