Account by subaccount (GL403000)
You can use this window to easily obtain information, by different subaccounts, about activities on the selected account. In the Subaccount field, you can select a group of subaccounts by specifying values in only particular segments while leaving other segments blank.
The window toolbar
| Button | Description |
|---|---|
| Account details | Navigates to the Account details (GL404000) window, so you can view the account details. |
The top part
By using the elements in this area, you can narrow the records to be displayed in the table. You can select a particular subaccount, or you can select a group of subaccounts by specifying the values for only some of the segments in the Subaccount field.
| Element | Description |
|---|---|
| Branch | The branch of the company whose data you want to view. You can select a required branch, or clear this field. With the empty field, information on all branches is shown. This field is available only if the Multi-branch support functionality is enabled in your system in the Enable/disable functionalities (CS100000) window. |
| Ledger | The ledger whose accounts you want to review. |
| Period | The financial period for which you want to view data. |
| Account | The account whose data you want to display. |
| Subaccount | The subaccount or mask for a group of subaccounts. If you leave the field blank, all transactions for the selected account in the specified period will be listed. If values are specified for only some segments, this defines a group of subaccounts with the specified values as well as all the different values in the segments that were left blank. |
| 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. |
The table
This table displays the account balances for all the subaccounts specified in the Subaccount field of the top part.
| Column | Description |
|---|---|
| Subaccount | The subaccount used with the account. |
| Beg. balance | The balance of the account by the subaccount at the beginning of the selected financial period. |
| Debit total | The debit total posted to the account by the subaccount during the selected financial period. |
| Credit total | The total of credits posted to the account by the subaccount during the selected financial period. |
| Ending balance | The balance of the account by the subaccount at the end of the selected financial period or on the current business date. |
The additional table columns
The following columns appear if the Show currency details option is selected.
| Column | Description |
|---|---|
| Currency ID | The currency of transactions in the account. If it is not specified, the balance is in the base currency. |
| Beg. balance (currency) | The account balance in the selected currency at the start of the selected period. |
| Debit total (currency) | The debit total in the selected currency for the specified account over the selected period. |
| Credit total (currency) | The credit total in the selected currency for the specified account over the selected period. |
| Ending balance (currency) | The account balance in the selected currency at the end of the selected period. |
Parent topic
General ledger windows - overview
Related concepts
Related reference