ACCOUNT ACTIVITY INQUIRY

Use this screen to review postings made to the General Ledger either by account ID or by project ID.

You can create inquiries for either one or multiple periods by account ID or by project ID. Line items will describe the activity (debit and credit) that is posted to either the account ID or to the project ID in question.

More detail for the posted transaction can be obtained in the Journal Detail subtask (accessed by selecting the Posting Detail pushbutton) and Transaction Form subtask (accessed from within the Journal Detail subtask by selecting the Form pushbutton).

To obtain the greatest accuracy, use this screen once the period(s) in question have been closed.

Select Inquiry Type

Account ID

Select this radio button to review postings made to the General Ledger by account ID.

Project ID

Select this radio button to review postings made to the General Ledger by project ID.

Select Account

Enter, or use Lookup to select, an account ID code. The account ID code was originally assigned in the Maintain Accounts screen.

Level

Enter the level of detail needed. If a large number is entered, the report will be more detailed. If a small number is entered, the report will be less detailed.

Note:  Entering a "zero" in this field will result in a report with full detail.

Select Project

Enter, or use Lookup to select, a project ID code. The project ID code was originally assigned in the Maintain Project Master screen in Costpoint Project Setup.

Level

Enter the level of detail needed. If a large number is entered, the report will be more detailed. If a small number is entered, the report will be less detailed.

Note:  Entering a "zero" in this field will result in a report with full detail.

Periods to Display

Fiscal Year

Enter, or use the drop-down box to select, a fiscal year.

Period

Enter, or use the drop-down box to select, a period.

Posting Detail

Select this pushbutton to access the Journal Detail subtask.

Table Window

Subperiod

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

Project

This column displays the specified project.

Project Name

This column displays the name of the project.

Organization

This column displays the specified organization.

Organization Name

This column displays the name of the organization.

Journal Code

This column displays the journal code for the posted transaction.

Posting Sequence

This column displays the posting sequence for the posted transaction.

Amount

This column displays the amount of the posted transaction.

Trans Amount

This column displays the amount of the posted transaction expressed in terms of your company's transaction currency.

Trans Currency Cd

This column displays the currency code of your company's transaction currency.

Transaction Description

This column displays a description of the posted transaction.

Hours Posted

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

GLC

This column displays the general labor category of the posted transaction.

GLC Description

This column displays a description of the general labor category.

PLC

This column displays the project labor category of the posted transaction.

PLC Description

This column displays a description of the project labor category.

Effective Billing Date

This column displays the effective billing date of the posted transaction.

Timesheet Date

This column displays the timesheet date of the posted transaction.

ID

This column displays the ID.

ID Type

This column displays the ID Type (Vendor, Employee, Customer, or Subcontractor).

Values used for the ID Type when posting to the General Ledger

N – Non Labor

Post IWO Journal

Post JEs

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 JEs

S – Vendor Employee

Post Vouchers (Vendor Employee Labor)

Post IWO Journal

Post JEs

E – Employee

Post IWO Journal

Post Labor Distribution

Post JEs

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 of the posted transaction.

Voucher Number

This column displays the voucher number of the posted transaction.

PO Number

This column displays the PO number of the posted transaction.

Name

This column displays the vendor, employee, or vendor employee name associated with the ID column for this posted transaction.

Invoice Number

This column displays the invoice number of the posted transaction.

JE Number

This column displays the journal entry number of the posted transaction.

Cash Receipt Number

This column displays the cash receipt number of the posted transaction.

Bill Number

This column displays the bill number of the posted transaction.

Item

This column displays the item ID of the posted transaction.

Rev

This column displays the revision number of the posted transaction.

Ref 1

This column displays the first reference number of the posted transaction.

Ref 1 Name

This column displays the name of the first reference number of the posted transaction.

Ref 2

This column displays the second reference number of the posted transaction.

Ref 2 Name

This column displays the name of the second reference number of the posted transaction.

Beginning Balance

This field displays the total of the beginning balance.

Prior Periods Activity

This field displays the total of the prior period activity.

Current Period Activity

This field displays the total of the current period activity.

Ending Balance

This field displays the total of the ending balance.