Summary

Sub ledger accounts can be attached to GL accounts in order to group GL account numbers together for reporting purposes using FQRM, Visual Reporting and the QBE reporting tool.

Sub ledger accounts are broken into two parts: sub ledger one and sub ledger two. The sub ledger one account is attached to a sub ledger two account, and then the sub ledger two account is attached to the general ledger account. You must have both a sub ledger one and sub ledger two account set up in order to attach a sub ledger account number to a general ledger account.

In order to add a sub ledger account to a general ledger account, create a sub ledger one account, and then attach it to a sub ledger two account (GL> Maintenance> Sub Ledger 2> Sub Ledger field). After the Sub Ledger 1 account has been attached to a sub ledger two account, attach the sub ledger two account to the general ledger account (GL> Maintenance> Chart of Accounts> General tab> Sub Ledger field).

The format of the sub ledger accounts is set up in GL> Utilities> Setup General Ledger> Default Formats> Sub Ledger 1 and Sub Ledger 2 fields.

Step by Step

1     Open the Sub Ledger 2 Maintenance window (GL> Maintenance> Sub Ledger 2).

• The Sub Ledger 2 Maintenance window will display all sub ledger two accounts that have been created. Select a sub ledger account and the fields in the Edit Sub Ledger 2 section will populate with the information of the selected sub ledger account.
• Select a sub ledger account and click DELETE to delete a sub ledger account. You will not be able to delete a sub ledger account attached to a general ledger account.
  • You can remove the sub ledger from the GL account in GL> Maintenance> Chart of Accounts> Account Information section> Sub Ledger field.
• Click the Create Sub Ledger 2 button to create a new sub ledger account.

2     Create a sub ledger account two.

• Click the Sub Ledger Account 1 field search button to select a sub ledger account.
• Enter a Sub Ledger Code 2.
  • The format of the sub ledger code is set up in GL> Utilities> Setup General Ledger> Default Formats tab> Sub Ledger 2 field.
• Enter a Description of the sub ledger account. The description field can be up to 30 alphanumeric characters long.
• Click SAVE to save the new sub ledger 2.