Account Summary Activity

General Ledger - Account Summary Activity

Function

Use this task to quickly create GL account activity views by month. The form also provides drilldowns for MTD and YTD Activity details.

=> To access this task...

Select Account Summary Activity from the Inquiry and Maintenance menu.

Account Summary Activity

About the Fields

To enable edits to the form select .

In the Account field...

Enter a valid GL account number.
Click to select a GL account from a list of existing records.
Click the record navigation buttons; to view the first record, to view the previous record, to view the next record and to view the last GL account code record.

In the Description field...

Display only. Displays the description of the GL account code entered.

From the Type dropdown field...

Select Asset (A)
Select Liability (L)
Select Capital (C)
Select Income (I)
Select Expense (E)

From the Post Detail or Summary dropdown...

Selection is disabled and defaults to Summary unless the Post Detail Transactions parameter is marked in the Application Parameters settings. When marked/enabled, the selection defaults to Detail.

Select Detail to post detail transactions.
Select Summary to post only summary information to this account (i.e. summarized by journal ID and date).

NOTE: Active accounts (those with open transactions) may not be deleted. To delete an account, its balance must be brought to zero and all transactions cleared.

Align Fiscal Periods checkbox...

The checkbox is disabled if the fiscal calendars are the same, i.e. the periods are already aligned.

Mark the box to re-align periods in a previous fiscal year to match the current fiscal year's calendar in order to facilitate comparative financial reporting.
Unmark the box to perform no re-alignment.

In the Activity Period field...

The period associated with the MTD Activity, YTD Activity, and YTD Balance. Defaults to the current fiscal period. Change to view different data in the MTD and YTD fields.

Displays the current financial period as defined by the GL Parameters setting.
Enter the financial period for a summary view. This does not change the GL Parameters setting.

In the Activity Year field...

The year associated with the MTD Activity, YTD Activity, and YTD Balance. Defaults to the current fiscal year. Change to view different data in the MTD and YTD fields.

Displays the current financial year as defined by the GL Parameters setting.
Enter the financial year for a summary view. This does not change the GL Parameters setting.

In the MTD Activity field...

Displays the sum of transactions applied to this GL account for the period and year selected.

Select the drilldown button to display a queryable transaction history grid for the selected month.

In the YTD Activity field...

Displays the sum of transactions applied to this GL account for the period and year selected.

Select the drilldown button to display a queryable transaction history grid for the selected year.

In the YTD Balance field...

Display only. Displays the sum of transactions applied to this GL account for the period and year selected.

In the Fiscal Period field...

Display only. Displays the current accounting period.

In the Fiscal Year field...

Display only. Displays the current accounting year.

GL Account Inactive checkbox...

Mark the box to render the account inactive.
Unmark the box to keep the account active.

In the Record Type dropdown...

The first four rows are determined in the Budget Maintenance section of the Default Display Columns option of the Application Parameters task. The selections may be changed by double-clicking on a blue Record Type and selecting from the list. Only budget information can be changed. Note that when the prior fiscal year is NOT closed, see GL Parameters Fiscal Calendar, it changes the years referenced by the Record Type codes. In that case "Next" refers to the current fiscal year, "Current" refers to the prior fiscal year, and "Prior" refers to the fiscal year prior to the prior fiscal year.

Data for the current fiscal year and previous five fiscal years is displayed at the bottom of the grid. The data displayed in these rows is based on the Record Types selected for the first four rows, i.e. Actual Amounts, Actual Units, Budget Amounts and/or Budget Units.

______________________________________________________________________________________