Account Activity Totals Subtask
Use this subtask of the Financial Statement Comparison Inquiry screen to view account activity information for each financial statement line on the Details subtask.
You can also drill down from this subtask into the Posting Detail subtask to view journal entry posting details for an account activity line.
Account Activity Totals
| Field | Description |
|---|---|
| Fiscal Year | This field displays the value you entered in the Start field of the Selection Ranges group box. |
| Accounting Period | This field displays the value you entered in the Period field of the Selection Ranges group box. |
| 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. |
| Account | This column displays the account ID. |
| Account Name | This column displays the name of the account. |
| 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: 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. |
| 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 |
|---|---|
| Account | This column displays the account ID. |
| Account Name | This column displays the name of the account. |
| 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. |
Subtask
| Subtask | Description |
|---|---|
| Posting Detail | Click this link to display the Posting Detail subtask. Use this subtask to view journal entry posting details for an account activity line. |
Related Topics:
Use this subtask of the Account Activity Totals screen to view additional posting detail for the transaction you selected on the Account Activity Details table window. The Journal Entry table window displays the individual journal postings for the transaction.