Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

One Utility Every MAS90 User Must Have: Customer / Vendor History Re-Calculation

October 7, 2008 by Wayne Schulz

martin associates customer vendor mas90 recalculationBeginning with version 4.1 of Sage MAS 90 and MAS 200 the customer master file  holds detailed monthly sales totals. In prior versions this data was only retained for one period using a PTD designation. This new level of detail is helpful to companies who are asking “what sales volume did my customer have last year during the month of February”.

This new feature works exceptionally well except that when MAS90 converts data it will lump most of the totals together in prior years to the last fiscal period. Instead of separating out the historical detail it creates lump sums for conversions. Moving forward the details are tracked apprpriately.

martin associates utilityThankfully Randy Marion at Martin and Associates came up with what must be the worlds most helpful utility. His software does one thing. It recalculates prior history for both customers and vendors and places those totals into the correct monthly column on the respective master file.

As with any recalc process, it is advisable to create a backup prior to execution of this utility. Additionally, it is advisable, but not mandatory, to rebuild the keys of the following list of files for EACH company prior to execution. An exception to this rebuild recommendation is if this data is freshly or recently converted from any version with legacy (.SOA) file structure.

arapfxv2 mas90 file file utilityThe utility is simple to install and use. Move on program file into the SOA folder, execute it by logging into MAS 90, running Syzcon and run
“arapfxv2”. It’s that easy. I’ve done this dozens of times with clients. Never an error message. The utility runs smoothly each and every time.

This utility is must have that can be used by resellers during an upgrade to correctly display various sales and purchase history for data acquired prior to version 4.10 or 4.2 in Sage MAS 90 or 200 ERP. This tool recalculates data in Accounts Receivable and Accounts Payable to correctly reflect Sales and Purchase istory. This is accomplished by scanning all the appropriate history files and accumulating the various totals in the proper fiscal periods and years.

Price: $ 795 with no maintenance

Summary: Nice to see software that is bulletproof, runs fast, works as designed and  saves a company hours of manual labor.

Link: Customer Sales – Vendor Purchase History — Product Manual

What I Like:

  • It just works – no error messages or un-needed complexity
  • Fast
  • Accurate
  • Saves hours of manually computing totals
  • Can be run on multiple companies
  • No ongoing maintenance

What Could Be Improved:

  • I’ve already asked Randy to build one that recalculates 1099 payment totals

Need More Information? Use Our Contact Form Below:

[contact-form 1 “Contact form 1”]

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP, Sage software, Tips and Tricks Tagged With: customer sales history recalc, martin and associates, vendor history recalc

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

  • WFH Tip For Sage 100: Go Paperless February 24, 2021
  • When is Sage 100 2021 Due for Release? February 19, 2021
  • Sage 100 Partner Cloud List of Supported ISVs as of January 2021 February 12, 2021
  • Sage 100 User Help Files and Table Layouts – Version 2018 – 2020 January 27, 2021
  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • 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

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.