GL Account Inquiry - Account field descriptions

The fields are listed alphabetically within each section.

Account Details

Account Type

Each account must be defined as one of these types: Asset, Liability, Income, Expense, and Clearing.

Note:  Because the GL Administrator Year End Report processes accounts differently based on this option, ensure that the account types are set correctly.

When the Account Type is changed on an existing account, an internal SA Change Balance Setup record is created to record the effect for balancing against the account. A maintenance section in SA Balance Maintenance Report shows all creations, deletions, and modifications to Distribution SX.e setup records.

Division

If the GL Account # specified in the Search is associated with a Division, that Division description is displayed. The Division is set up in SA Table Code Value Setup-Division-Description. This field honors division security. Operators can only view account information in the divisions they have security for.

Division Group

If the GL Account # specified in the Search is associated with a Division Group, that Division Group description is displayed. The Division Group is set up in SA Table Code Value Setup-Division Group-Description. This field honors division security. Operators can only view account information in the divisions they have security for.

Forward Balance

The forward balance is the balance carried forward from last year. This field is used only for balance sheet accounts. After your Chart of Accounts is set up, this balance is updated automatically at the end of the year when you perform year-end processing.

Normal Balance

This field indicates whether an account normally carries a debit or credit balance. Debit balances are stored as positive amounts. Credit balances are stored as negative amounts.

Print Type

General Ledger accounts are always updated in detail but can print in detail or summary on reports. If the print type is Detail, the account prints a transaction line for each journal entry. If the print type is Summary, the account summarizes all journal entries and print one transaction line.

This option affects the GL Transaction Activity Report and all user-designed financial statements that are created in GL Financial Statement Setup.

Report Group

Report groups must be previously defined in SA Table Code Value Setup. This value is used by the GL Daily Change Report. The GL Transaction Entry history for each account code in each report group is tabulated and printed as one report group total. This occurs when you assign a specific report group to account codes and run GL Daily Change Report to view the daily changes that have occurred to these accounts.

User1 and User 2

Two user-defined fields are provided for you to specify additional user information.

Period Balances

If you use a 12-period fiscal year, the calendar months are displayed, starting with the beginning fiscal period. If you use a 13-period fiscal year, Period 1 through Period 13 are displayed in the Period column.

The PTD balances are updated through GL Transaction Entry and other updating functions. These amounts reflect the balance for only that period. It is not an accumulative balance from all previous periods.

The YTD balance displays in GL Account Inquiry under the last Period Amount field after the amounts have been posted. This amount reflects the balance as of the last period that was entered.