Costpoint Online Help

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.

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.