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. |
| Field | Description |
|---|---|
| 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 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 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. |
Subtasks
| Subtask | Description |
|---|---|
| Posting Detail | Click this link to view additional posting detail for the selected transaction in the Posting Detail subtask. |