Featured Stories

Filter By Categories
June 05, 2018

Sage 300 CRE: How to setup control accounts

Don’t you hate it when you can’t balance your AP detail (from either the Open Invoices w/Cut-Off tipsTricksDate or the Invoice Aging w/Cut-Off Date report) to your GL Accounts Payable account balance, and you ultimately discover a wayward GL entry where either the debit entry or the credit entry posted to your AP GL account?

One way to prevent this from happening is to turn on the CONTROL settings in GL.  A control account is normally used for entries created in another application (such as AP, PR, or AR).  By specifying a General Ledger account as a control account, entries cannot be made to the account directly in GL unless override settings are first addressed.

To set up Control Accounts, do the following:

  1. Activate the GL Setting:

first2. Activate the GL account as a Control Account (this example uses the Accounts Payable account):

second3. Set up the Control Account Settings (this example uses the AP Control Account and Error Message from their respective drop-down lists):











4. Test the setting:









It works!  The only way the GL AP account can receive a transaction is if it originates from the AP module.  This feature will certainly increase the probability that your AP detail will agree with your GL account balance.

Should you need any further assistance managing your company’s control accounts, please call your United Solutions, Inc. consultant.

Subscribe to Receive Our eNewsletter