Contents of the View Account Activity Screen

Use the fields and options to configure the View Account Activity screen.

View Account Activity

Inquiry Type

Field Description
Account

Select this option to review general ledger postings by account.

Project

Select this option to review general ledger postings by project.

Account

Field Description
(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

Field Description
(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

Field Description
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.

Show net zero transactions

Select this check box to show net zero transactions.

Account Activity Totals

Field Description
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.

Account Activity Details Table Window

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

Field Description
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.

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:

  • N – Non Labor

    • Post IWO Journal

    • Post Journal Entries

  • V – Vendor

    • Create/Post AP Vouchers for Travel Expense/Advance/Company Paid Expense

    • Post Cash Disbursements

    • Post Vouchers (Vendor Labor or No Labor)

    • Compute/Post Unrealized Gains/Losses – AP Gain/Loss

    • Post IWO Journal

    • Post Journal Entries

  • S – Vendor Employee

    • Post Vouchers (Vendor Employee Labor)

    • Post IWO Journal

    • Post Journal Entries

  • E – Employee

    • Post IWO Journal

    • Post Labor Distribution

    • Post Journal Entries

  • C – Customer

    • Post Standard Bills

    • Post Cash Receipts

    • Adjust A/R Underpayment Amounts

    • Post Milestone/Percent Compete Bills

    • Post Progress Payment Bills

    • Post Project Product Bills

    • Post Manual Bills

    • Post Customer Product Bills

    • Compute/Post Unrealized Gains/Losses – AR Gain/Loss

  • O – Customer

    • Post Sales Order Journal

  • I – Inventory

    • Post Inventory Journal

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.

Transaction Amount

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

Voucher Invoice Amount

This column displays the voucher currency invoice amount for the transaction.

Voucher Invoice Currency Cd

This column displays the currency code of the voucher used for the transaction.

Subtasks

Subtask Description
Posting Detail Click this link to view additional posting detail for the selected transaction in the Posting Detail subtask.