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. Highlight a sub ledger account and the fields in the Maintenance section will populate with the information of the selected sub ledger account.
  • If no sub accounts have been created, the Maintenance section of the window will not display.
• Highlight a sub ledger account and press 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.
• Highlight a sub ledger account and click the Modify icon or press ENTER to modify a sub ledger account.

2     Create a sub ledger account two.

• Press INSERT to create a new sub ledger. This will create a new line item in the window and the fields in the Maintenance section will be blank.
• Click the Sub Ledger Account 1 field label to open a window to select a sub ledger account from.
• 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.
• Press ENTER or click the Save icon when complete to save the sub ledger account.