Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Not so secret tips about closing the year in MAS90

January 26, 2009 by Wayne Schulz

I’m surprised to see so much confusion among my clients about the year/month end closing process.

Virtually everyone hesitates to close their books for fear of not being able to go back and make an entry when their accounting staff or CPA eventually give them the journal entries needed to close out their old fiscal year.

Here’s my tip(s):

  • Close your books regularly. – Before you do so ALWAYS turn on the maximum history retention in every module. Simply increase the # of months to the maximum in every setup. You can always get rid of history but it will never come back.
  • Print and tie out the records monthly – AP and AR aging tie to GL control account total – TB and GL Detail in balance (and printed)
  • Use Papeless Office (free in v4.3+) to print these reports
  • Use the COPY function in company maintenance to make a “dummy” company to hold your old data at year end – just in case.
  • Remember that 1099 forms must be printed (and closed) from the AP reports menu.

Starting with 4.2 1099 forms are less of a hassle because the totals are tracked for multiple years, but I still recommend you print and close the 1099 processing in a timely fashion. And remember that you won’t be able to take advantage of the latest software improvements if you are on an old MAS 90 version.

What so many people fail to realize is you can re-open the general ledger very easily. I recommend not developing crazy “workarounds” for year end. Close the period (most people strive to do it by the 10th or 15th of the following month) regularly and do away with worrying about keeping months open.

Want A More Stress Free Closing in MAS 90 or MAS 200?

Stay on the latest version – it’s really tempting (but a bad idea) to cling to the older versions. If you avoid moving to version 4.3 you give up the ability to go paperless with monthly closings as well as productivity features (like the ability of 1099 forms to track information for unlimited years instead of just two) that greatly enhance the speed with which you can print reports.

Close your system each and every month – pick a date by which your books will be closed out each month. And close. Don’t be concerned about having to go back and make an entry into a closed period. It’s been our experience that many more people worry about closed periods than actually ever have to re-open them to post entries.

Plan for year end – realize the consolidating 15 different entities into one is probably best accomplished outside of your annual closign process. Instead take non-year end work — out of year end. Test and implement major changes during your normally slower times of the year.

Did I miss a tip — or get something wrong? Let me know in the comments below.

Filed Under: Sage 100 ERP Tagged With: accounting software closing, mas200, mas90 tips, Sage 100 ERP, schulz consulting, year end

How to remove custom reports from Sage MAS 90 and 200 menus

October 17, 2008 by Wayne Schulz

One thing that has left me (and my clients) scratching our heads over is removing custom reports from the MAS 90 and MAS 200 menu structure. Like bad house guests, these user created reports are easy to add (Library Master – Setup – Report Manager) — but nearly impossible to get them to leave when you want.

Unless someone has discovered a better way, here’s the solution that I’ve used in the past to remove custom reports that have been added to the Sage MAS 90 and MAS 200 menus (these are the reports that show on the Custom menu choice).

UPDATE/CLARIFICATION: These instructions are meant for situations where you cannot remove a Custom Report via the Report Manager menu.  Normally you can go into the Report Manager menu and click the “X” when you have a custom report selected. In many situations (that I’ve seen) this red “X” either is not present for selection or once clicked does not work. That is what the instructions below are meant to cover.

Important: Backup your entire \MAS_SYSTEM and \SOA folder before making any changes. I take no responsibility for any damage that may occur on your system. This was tested on version 4.2 and may (or may not) work similarly on earlier and later versions.

Step One – MAKE A BACKUP FIRST

Go to Library Master – Utililities – Data File Display and Maintenance

For the filename, browse to your MAS_SYSTEM folder and find the file SY_MENU

Browse to the record which is showing your report and click delete.

Step Two

For the filename, browse to the \SOA folder and find the SY1RPM file

Browse to the record which is showing your report and click delete.

Step Three – Recompile your menus

The process to rebuild your Sage 100 menus has changed depending upon the version of Sage that you are using.

For current instructions see – how to rebuild Sage 100 and Sage 100cloud menus.

Found a better way out of this situation? Let me know in the comments below.

Filed Under: Hidden Options, Sage 100 ERP, Tips and Tricks Tagged With: mas200, mas90 secrets, mas90 support, mas90 tips, remove reports mas90 menu, Sage 100 ERP, schulz consulting, Wayne Schulz

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

  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • 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)

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