Account by Subaccount

Form ID: (GL403000)

You can use this form to obtain information about activities on the selected account, broken down by subaccount.
Note:
This form is available only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Account Details Navigates to the Account Details (GL404000) form, so you can view all activities in the selected account.

Selection Area

In this area, you specify criteria to narrow the records to be displayed in the table.

Element Description
Company/Branch

The company or branch for which you want to view information. By default, the current company or branch is selected.

Ledger Required. The ledger whose account you want to review.
Period Required. The financial period for which you want to view data.
Account Required. The account whose data you want to view.
Subaccount

The subaccount or the group of subaccounts whose data you want to view. To view data for a group of subaccounts, specify the values for only some segments; this defines the group of subaccounts with the specified values (and with different values in the segments that were left blank). To view data for the selected account (with all subaccounts) in the specified period, leave the box blank.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Show Currency Details

A check box that indicates (if selected) that the columns showing the currency details of the transactions will also be displayed. If the check box is cleared, all transactions are shown in the base currency.

This check box is available only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features (CS100000) form.

Use Master Calendar

A check box that indicates (if selected) that the data in the table will be consolidated by the master calendar. That is, the table will show the transactions posted by the master calendar. If the check box is cleared, the data in the table will be consolidated by the company calendar. If the Company box is blank, this check box is selected by default.

This check box appears on the form only if the Multiple Calendar Support feature is enabled on the Enable/Disable Features (CS100000) form.

For details on running consolidated reports and inquiries, see Consolidated Reports for Companies with Different Calendars.

Table

This table displays the account balances and debit and credit totals, broken down by subaccount.

Column Description
Subaccount The subaccount used with the selected account.
Beg. Balance The balance of the account, calculated for this subaccount, at the beginning of the selected financial period.
Debit Total The debit total posted to the account, calculated for this subaccount, during the selected financial period.
Credit Total The total of credits posted to the account, calculated for this subaccount, during the selected financial period.
Ending Balance The balance of the account, calculated for this subaccount, at the end of the selected financial period or on the current business date if the current period is selected.
Table 1. Additional Table Columns The following columns also appear after the columns listed above if the Show Currency Details check box is selected.
ColumnDescription
Currency IDThe currency of denomination used for the account.
Curr. Beg. BalanceThe account balance in the currency of denomination at the start of the selected financial period.
Curr. Debit TotalThe debit total in the currency of denomination for the specified account over the selected financial period.
Curr. Credit TotalThe credit total in the currency of denomination for the specified account over the selected financial period.
Curr. Ending BalanceThe account balance in the currency of denomination at the end of the selected financial period.