Field Descriptions

Table Information

 

Periods

What can I do in this subtask?

This subtask displays running balances by period, as well as activity for each period. All amounts display only in terms of your company's functional currency.

From here, you can "drill down" into the posting detail that shows what journals and post sequence numbers make up the data on the selected line in the Periods subtask. (This information comes from the GL_POST_SUM table.)

The transaction detail displays the transactions that make up that period's activity. (This information comes from the GL_DETL table.)

The information shown in the transaction is only for one fiscal year, account, and organization.

 

When should I use this subtask?

Use this subtask whenever you need to examine running balances by period, as well as the summary-level activity for each period.

This subtask allows you to conduct a more refined search process by permitting you to "drill down" to journal activity postings and transactions by period.

Field Descriptions

 

FY

This non-editable field displays the fiscal year for the selected line from the main screen for which you are viewing period information.

Account

This non-editable field displays the account number for the selected line from the main screen for which you are viewing period information.

Org

This non-editable field displays the organization number for the selected line from the main screen for which you are viewing period information.

YTD Balance

This non-editable field displays the year-to-date balance for all displayed lines in the Period subtask for the selected line from the main screen.

This balance should equal the amount in the Running Balance Amount field of the last period in the table window and should also equal the sum of the value of the Period Activity Amount fields of all displayed periods.

 

 

Table Window

Pd

The period in which the activity was posted to the General Ledger for the selected fiscal year/account/organization displays in this field.

Period Activity Amount

The sum of all transactions posted to the General Ledger for the selected fiscal year/account/organization displays in this field.

This amount is stated in terms of the functional currency of your company.

Period Hours

The sum of all hours posted to the General Ledger for the selected fiscal year/account/organization displays in this field.

Running Balance Amount

The value in the Running Balance Amount field is calculated as the value in the Period Activity Amount field plus the value in the Period Activity Amount field from the current period.

No beginning balances are considered in this application; this means that all balances are year-to-date only and are stated in the functional currency of your company.  

Running Balance Hours

The value in the Running Balance Hours field is calculated as the value in the Period Hours field from the prior period (if any) plus the value in the Period Hours field from the current period.

No hours from prior years are considered in this application; this means that all hours are year-to-date only.

Postings

Select this subtask link to open the Postings subtask, which displays the posting detail by post sequence number and subperiod for the period activity line you selected from the table window.

Transactions

Select this subtask link to view the Transactions detail associated with the selected period activity line from the table window.  

Table Information

This screen accesses data stored in the  FS_SUM (Financial Statement Summary) table.

Top of Page