VIEW ACCOUNT ACTIVITY

Use the View Account Activity screen to review postings made to the General Ledger. You can create inquiries for either one or multiple periods by account ID or by project ID. Line items describe the transactions posted to either the account or to the project.

To display data in the table window, enter your selection criteria and click .

A message appears if no records match your query criteria.

To see more detail for a transaction, display the Posting Detail subtask.

Location

Select

Inquiry Type

Account

Select this option to review general ledger postings by account.

Project

Select this option to review general ledger postings by project.

Account

(Select Account)

If you selected Account in Inquiry Type, enter, or click to select, the account.

Level

Enter the account level for which you want to view activity.

Enter 0 for complete detail.

And Below

Select this check box to include activity for account levels lower than the level specified in Level.

Project

(Select Project)

If you selected Project in Inquiry Type, enter, or click to select, the project ID.

Level

Enter the project level for which you want to view activity. Enter 0 for complete detail.

And Below

Select this check box to include activity for project levels lower than the level specified in Level.

Periods to Display

Fiscal Year

Enter, or click to select, the fiscal year for which you want to view account activity.

Period

Enter, or click to select, the accounting period for which you want to view account activity.

Beginning Balance

This field displays the beginning balance.

Prior Periods Activity

This field displays the total activity for prior periods.

Current Period Activity

This field displays the total activity for the current period.

Ending Balance

This field displays the ending balance.

Table Window

This table window displays the following types of information for each transaction.

Subperiod

This column displays the subperiod for which the transaction was posted to the General Ledger.

Project

This column displays the project ID.

Project Name

This column displays the name of the project.

Organization

This column displays the organization ID

Organization Name

This column displays the name of the organization.

Journal Code

This column displays the journal code.

Posting Sequence

This column displays the posting sequence number.

Amount

This column displays the amount of the transaction in your company's functional currency.

Transaction Amount

This column displays the amount of the transaction in the transaction currency.

Trans Currency Cd

This column displays the currency code of the transaction currency.

Transaction Description

This column displays a description of the transaction.

Hours Posted

This column displays the number of hours posted for the transaction.

GLC

This column displays the general labor category.

GLC Description

This column displays a description of the general labor category.

PLC

This column displays the project labor category.

PLC Description

This column displays a description of the project labor category.

Effective Bill Date

This column displays the effective billing date.

Timesheet Date

This column displays the timesheet date.

ID

This column displays the timesheet ID (employee ID, for example) associated with the transaction.

ID Type

This column displays the ID type.

Values used for the ID type when posting to the general ledger.

Check Number

This column displays the check number.

Voucher Number

This column displays the voucher number.

PO Number

This column displays the PO number.

Name

This column displays the vendor, employee, or vendor employee name associated with the ID in the ID column.

Invoice Number

This column displays the invoice number.

JE Number

This column displays the journal entry number.

Cash Receipt Number

This column displays the cash receipt number.

Bill Number

This column displays the bill number.

Item

This column displays the item ID.

Rev

This column displays the revision number.

Reference 1

This column displays the value of Reference 1 for the transaction.

Reference 2

This column displays the value of Reference 2 for the transaction.

Subtasks

• Table Information

  The information on this inquiry screen comes from the GL_DETL table.

  The information on the Posting Detail subtaks comes from the GL_POST_SUM table.