Sage 100 ERP (MAS 90): How to Merge General Ledger Accounts

Question: We own Sage 100 ERP (formerly Sage MAS 90, MAS 200), we have some duplicate General Ledger Accounts, how do we merge these together.

Answer: There is a General Ledger Utility called Change Accounts that will allow merging of accounts. In the example we would like to merge the East and West Warehouse accounts into just one new accounts receivable account.

Step One: Create a new Accounts Receivable account using Account Maintenance which will be account 105-000-00 as shown below: 

Step Two: Go to General Ledger>Utilities>Change Accounts, select the starting, ending and new values for accounts.

Step Three: Click Proceed, and you can then select Yes.

Step Four: Print change accounts log and verify the correct accounts have been merged:

Step Five: You can now look at Accounts Maintenance and verify that the accounts have been changed.

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services 

Mike is an expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.