MODULE CLOSING

Keeping Things In Order

A year end process in one module often writes data to another module.  Therefore, the sequence in which you close your Sage 100 modules is important in order to avoid the risk of damaging your data.

Important: Remember to back up your data before starting module closing procedures. Refer to the article on page 2 of this newsletter for guidance.

1. B/M – Bill of Materials*
2. W/O – Work Order*
3. P/M – Production Management
4. B/C – Bar Code
5. P/O – Purchase Order
6. S/O – Sales Order
7. I/M – Inventory Management
8. M/P – Material Requirements Planning (MRP)*
9. P/R – Payroll (Quarter-end processing)
10. A/R – Accounts Receivable
11. A/P – Accounts Payable
12. J/C – Job Cost
13. B/R – Bank Reconciliation
14. G/L – General Ledger

*Note: While there is no formal closing procedure in the Bill of Materials, Work Order, or MRP modules, all transactions in those modules should be posted before starting any closing procedures in the modules that follow them (i.e. Post transactions in Work Order before closing Purchase Order, Sales Order, and Inventory).

Remember, this is just a general guideline. If you own modules that aren’t listed above or you run any third party add-on products, please contact us to discuss specific closing procedures for your company.

Get the Full Details

YEAR END PROCESSING

Here are just a few tips to keep in mind as you begin year end processing in Sage 100.

1. General Ledger Closing – While it’s a good idea to close modules in a timely fashion, the General Ledger can remain open for as long as you need while awaiting final processing (or audit adjustments) in other modules. A GL that’s still open for 2022 will NOT prevent you from entering transactions for the new year.

2. Payroll Planning – Even if your company is on a fiscal year, you may need to close out payroll at the end of the calendar year – particularly if you’re running an older version of Sage 100 Payroll.

NOTE: This does NOT apply to the newer Payroll 2.0 module which allows two calendar years to be open so you don’t have to run year-end tax reports and W-2’s before processing payroll for 2023 (as was required with the old/legacy payroll module).

3. Check Your Version Number – Closing procedures can vary depending on which version of Sage 100 you’re running. Here are steps to identify both your version number and service pack:

Select Help > About Sage 100

4. Master Console – Once you’re ready to close, you need to make sure all users are out of the system. That’s where the Master Console comes in handy. This utility provides a snapshot of all users currently logged into Sage 100, the workstation being used, what programs/tasks they’re using, and more. You can also broadcast a message to all users or even shut them down remotely.

To launch the Master Console:
Select File > Master Console