Schulz Consulting

Sage 100cloud Consulting

  • 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

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