Account by Period

Form ID: (GL402000)

You can use this form to obtain all information about a particular account by financial period for the ledger and financial year you select.

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, on which you can view all activities in the selected account during the financial period of the selected row in the table of the current form. You click the row of the financial period for which you want to view information, and then click this button. By default, the first row of the table is selected.
Account by Subaccount	Navigates to the Account by Subaccount (GL403000) form, on which you can view all activities in the selected account by subaccount during the financial period of the selected row in the table of the current form. You click the row of the financial period for which you want to view information, and then click this button. By default, the first row of the table is selected. This button appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Selection Area

In this area, you specify criteria to narrow the information 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 of the account you want to review.
Financial Year	Required. The financial year whose periods you want to view. By default, the current financial year is selected.
Account	Required. The account whose balance you want to view through all the financial periods of the selected financial year.
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 appears on the form 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 shown for the master calendar. That is, the table will show the balance details of the account, which were posted for the master calendar. If the check box is cleared, the table will show the balance details of the account, which were posted for 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 contains the account balances and debit and credit totals for all the financial periods of the selected financial year.

Table 1. Table Columns
Column	Description
Period	The financial period of the selected financial year.
Beg. Balance	The balance of the account, calculated for the selected subaccount or subaccounts (if applicable), at the beginning of the financial period.
Debit Total	The debit total charged to the account during the specified period. The amount is calculated for the selected subaccount or subaccounts (if applicable) only.
Credit Total	The credit total charged to the account during the specified period. The amount is calculated for the selected subaccount or subaccounts (if applicable) only.
Ending Balance	The balance of the account, calculated for the selected subaccount or subaccounts (if applicable), at the end of the specified period.

Table 2. Additional Table Columns The following columns also appear after the columns listed above if the Show Currency Details check box is selected.
Column	Description
Currency ID	The currency of denomination used for the account.
Curr. Beg. Balance	The account balance in the currency of denomination at the start of the financial period.
Curr. Debit Total	The debit total in the currency of denomination for the specified account over the financial period.
Curr. Credit Total	The credit total in the currency of denomination for the specified account over the financial period.
Curr. Ending Balance	The account balance in the currency of denomination at the end of the financial period.