Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

In What Order Should Sage 100 Modules Be Closed For The Month or Year?

December 15, 2015 by Wayne Schulz

sage100_order_closing

 

Curious about the order that you should close the individual modules in Sage 100?  With year-end fast approaching, we’ve received several questions about which module to close first.

Generally, you should close the modules in the order that they’re likely to post transactions to another module. According to Sage, close in this order:

 

B/M – Bill of Materials
W/O – Work Order
B/C – Bar Code
P/O – Purchase Order
S/O – Sales Order
I/M – Inventory Management
M/P – Material Requirements Planning
T/C – Time Card
P/R – Payroll
A/R – Account Receivable
A/P – Account Payable
J/C – Job Cost
B/R – Bank Reconciliation
G/L – General Ledger

 

Remember:

Make a full system backup before closing

The Payroll and Job Cost are especially time-sensitive to when they are closed since they continue to use “bucket driven” totalling (ie PTD, MTD, YTD, JTD) where the totals are accumulated based upon the current period shown in the module setup screen.

Tip:

Prior to closing, go through each of your modules and look in the Setup – [module name] Options. Review the amount of history that you’ve indicated should be retained. Unless you are experiencing slowdowns, we recommend retaining the maximum amount of history. Remember, history can always be purged – rarely brought back. Better to err on the side of retaining too much information than not enough.

Filed Under: Sage 100 ERP Tagged With: Closing, sage 100

Year End Closing Tips for Sage 100 ERP (formerly MAS 90) – Special Newsletter

December 6, 2012 by Wayne Schulz

Our special year end newsletter for Sage 100 ERP (formerly known as MAS90 or MAS200) users is now available. In this issue we explore tips and tricks for closing every module – including the order in which they should be closed.

Are you following best practices by creating year-end archive companies? If not – we will show you how to use the built-in features that allow Sage 100 ERP to quickly create backup copies of your live data. These copies of data are especially helpful for anyone using the payroll module since you can refer back to the archived companies throughout the year as your employees request copies of W2 and other forms which they may have lost.

This issue also has information on the payroll tax updates and provides information about when and how to apply them to your system to meet new IRS and state tax guidelines.

Sage 100 ERP Year In Review – 2012 Closing Tips (PDF)

Filed Under: mas200, Sage 100 ERP, Sage 100 ERP Premium, Sage software Tagged With: Closing, faq, mas200, Sage 100 ERP, tips, year end

Year End 2011 Newsletter: Sage ERP MAS 90 and 200

November 17, 2011 by Wayne Schulz

We’ve just received our year end MAS 90 and MAS 200 newsletter – 2011 edition.

This issue covers a lot of ground  – including:

  • What’s new and what’s coming for Sage ERP MAS 90 and 200
  • Creating a new company in Sage ERP MAS 90
  • The importance of budgeting
  • Sage ERP MAS 90 and MAS 200 Module Closing sequence
  • Year end compliance issues (W2 , 1099, tax tables)
  • SQL Payroll for Sage ERP MAS 200 SQL customers
  • General module closing: Purchase Order , Sales Order
  • General module closing: Inventory Management, Payroll
  • General module closing: Accounts Receivable, Accounts Payable
  • General Module Closing: General Ledger
  • Tips to help your Sage ERP MAS 90 year end processing run smoothly
  • DSD Business Systems office locations

 

Whether you have been working with Sage ERP MAS 90 or MAS 200 as a novice or expert – there’s something for everyone in our year end newsletter. You can view the information online or click to download the newsletter.

 
MAS90 Newsletter Year-End 2011

Filed Under: Sage 100 ERP Tagged With: 2011, Closing, newsletter, tips, tricks, year end

MAS90 and MAS200 2010 IRD Tax and Reporting Update Instructions (How To)

December 27, 2010 by Wayne Schulz

Sage North America have released their IRD (Interim Release Disk) which contain year end program changes for Accounts Payable and Payroll modules. These changes add functionality to the ERP system which allow for processing according to updated federal and state government regulations concerning 1099, W-2 and other tax forms.

The IRD contains year end program changes for AP and PR and common files for the following versions:

  • Sage ERP MAS 90 / 200 Versions 4.40
  • Sage ERP MAS 90 / 200 Versions 4.40 with PU 1
  • Sage ERP MAS 90 / 200 Versions 4.40 with PU 2
  • Sage ERP MAS 90 / 200 Versions 4.40 with PU 3
  • Sage MAS 90 / 200 Versions 4.30 with SU 17
  • Sage MAS 90 / 200 Versions 4.30 with SU 18
  • Sage MAS 90 / 200 Versions 4.30 with SU 19
  • Sage MAS 90 / 200 Versions 4.30 with SU 20
  • Sage MAS 90 / 200 Versions 4.20
  • Sage MAS 90 / 200 Versions 4.10
  • Sage MAS 90 / 200 Versions 4.05
  • Sage MAS 90 / 200 Versions 4.00
  • Sage MAS 90 / 200 SQL Versions 3.74
  • Sage MAS 90 / 200 SQL Versions 3.73

Payroll Update 2nd Quarter

If you have installed the Product Update 3 for version 4.40 these changes have been included in the final released product.

A download with payroll updates for Federal 941 2nd quarter 2010 was made available via the website. This payroll update included adding a new data table, program and form changes to adhere to the Federal requirements under the 2010 Hire Act used for reporting employer exemptions for qualified employees. If you have installed the Product Update 3 for version 4.40 these changes have been included in the final released product.

Some changes included in the Payroll Update.

  • Qualified (W-11) checkbox added to employee maintenance.
  • PR_QExxx.soa data table.
  • Update and 941 program change logic.
  • 2010 2nd QTR 941 form change logic.

Note: For details refer to PR3035-KBA available on
http://www.sagesoftwareonline.com/eServices/Main/frmLogin.aspx

Electronic Reporting for MAS90 and MAS200

  • 1099 Electronic Reporting has been modified according to the Internal Revenue Service’s 2010 Publication 1220.
  • W2 Electronic Reporting has been modified according to the SSA 2010 Specifications for Filing Form W-2 Electronically.

Qualified Employee Worksheet and Report

  • A Qualified Employee Worksheet and Report has been installed to the reports directory. This report is a visual display of the PR_QExxx.soa table that was created to capture data for reporting of qualified employees.
  • The report only displays for employees that have been selected as Qualified in employee maintenance.
  • The amounts on this report do not reflect the FICA limits.
  • The number of qualified employees per quarter is calculated at runtime. This number is not retained in a data file when printing the 941.

To download the latest Sage MAS90 and MAS200 IRD visit the Sage Software Online Support Site (valid maintenance subscription and login required)

Sage ERP MAS90 and MAS200 Year End 2010 Reporting Tips and Instructions (W2, 1099, Closing, Tax Tables)

Filed Under: mas200, Sage 100 ERP Tagged With: 1099, 2010 IRD, Closing, Interim Release, mas200, Sage 100 ERP, year end

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

  • 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)
  • What Are My Sage 100 Mobile Sales Options?

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