Use this screen to view check date, number, and amount information for posted checks. You can limit this information by cash account or use this screen to view information for only one posted check. Information in the Vouchers subtask can be limited by organization. Use the subtasks in this screen to "drill-down" through many layers of data, including information about the vouchers paid by a particular check, the voucher detail for both A/P and PO vouchers, and vendor addresses and contacts.
Use the Export button on the toolbar to export data from this screen to other files (e.g., Excel).
This screen is blank when you enter it. We recommend using Subquery to limit the amount of data before executing the Inquiry, or, if you want to view information for a particular cash account, organization, or check number, enter that information in the proper field or use Lookup before executing the Inquiry.
Use this screen whenever you need to view information for checks that have already been posted. Unposted checks do not display in the Check History Inquiry screen or in any of its subtasks.
Enter, or use Lookup to select, the cash account number in this field, if you want to view information for a particular cash account. The name of the cash account displays in the non-editable field to the right. If you execute without entering a cash organization or a check number, the table window will display information for all cash organizations and check numbers associated with the cash account. To view checks for all cash accounts and organizations, leave all the header fields blank and execute the inquiry. If you leave this field blank, the table window will include a Cash Account column.
Enter, or use Lookup to select, the organization number in this field, if you want to view check information for a particular organization. The name of the cash organization displays in the non-editable field to the right. If you enter the cash organization without entering a cash account number or a check number, the check information for all cash accounts associated with the cash organization displays in the table window. If you have already entered a cash account number, the information in the table window will be limited to that particular cash account/organization combination. To view checks for all cash accounts and organizations, leave all the header fields blank and execute the inquiry. If you leave this field blank, the table window will include a Cash Organization column.
If you want to limit the information in the table window to a particular check, enter that check's number here. Although you can execute the inquiry based on check number alone, it will be easier to locate a specific check by also entering cash account, cash organization, fiscal year, and/or period information. If you enter a check number here, the Check Number column will not be included in the table window.
Enter, or use Lookup to select, a valid address code. The address code can be up to 10 alphanumeric characters and is stored in the Vendor Check table. Address codes are established in the Maintain Vendors screen.
If you want to view check information for a particular fiscal year, enter the fiscal year here or select one from the drop-down box. You can execute the inquiry based solely on fiscal year, or you can use the Fiscal Year field to further limit the check information displayed.
If you want to view check information for a particular period, enter the number of the period here or select one from the drop-down box. Although you can execute the inquiry based solely on the period, we recommend that you also limit the inquiry by fiscal year, because you may have identically numbered periods in different fiscal years.
If you did not limit your inquiry by cash account, this field displays the number of the cash account from which the check on this line was paid.
If you did not limit your inquiry by cash organization, this field displays the number of the cash organization from which the check on this line was paid.
If you did not limit your inquiry by check number, this field displays the number of the check on this line.
This field displays the date on which the check was issued.
This field displays the currency code for this check's pay currency. The pay currency may or may not be the same as the functional currency (the currency in which you maintain your Costpoint records) or the transaction currency (the currency of the invoice you received from your vendor).
This field displays the total amount of the check. This amount is displayed in the pay currency for this check.
This field displays the total amount of the check. This amount is displayed in your functional currency.
This field displays a status code for the check. The status codes are:
P - Zero Balance
V - Void
O - Outstanding
C - Cleared
S - Stop Payment
This field displays the 25-character name of the pay vendor to whom the check was issued.
This field displays the name of the joint payee to whom the check was issued.
This field displays the pay vendor's location.
This field displays the code for the pay vendor's payment address.
This field displays the pay vendor's ID.
This field displays the reference number 1 assigned to this check, if there is one.
This field displays the reference number 2 assigned to this check, if there is one.
This field displays the name of the cash account. This column is included in the table window regardless of whether or not you enter an account number in the Cash Account field.
This field displays the name of the cash organization. This column is included in the table window regardless of whether or not you enter an organization number in the Cash Organization field.
This field displays the fiscal year to which the check was posted. If you limited the inquiry by fiscal year before executing, this column is not included in the table window.
This field displays the period to which the check was posted. If you limited the inquiry by period before executing, this column is not included in the table window.
This field displays the subperiod to which the check was posted.
For void checks, this field displays the date on which the check was voided.
For void checks, this field displays the fiscal year in which the check was voided.
For void checks, this field displays the period in which the check was voided.
For void checks, this field displays the subperiod in which the check was voided.
If the check was manually entered, this field displays an "M." You can enter checks in three different locations in Costpoint: the Record Manual Checks screen, the Check subtask of the Enter A/P Vouchers screen, and the Check subtask of the Enter PO Vouchers screen.
If the check was system-created, an "S" displays in this field.
This field displays the description of the check's pay currency.
Select this pushbutton to view address and phone information for the pay vendor on the highlighted line.
Select this pushbutton to view vendor contact information for the pay vendor on the highlighted line.
Use this pushbutton to view summary and detail information regarding vouchers related to the check on the highlighted line. Information on this screen may be restricted due to activation of org security. For more information about org security and how to apply it, see Special Topic SA-5, "Organizational Security," and the function documentation for org security in System Administration.
This field displays the total amount of all checks in the table window in your functional currency.
Accounts (ACCT): Account descriptions in all subtasks come from this table.
Billable Labor Category (BILL_LAB_CAT): This table contains project labor categories (PLCs) and their descriptions, entered through the General Labor Categories screen in Costpoint Labor. The Vendor Labor subtask takes the PLC Description from this table.
Organizations (ORG): Organization names and abbreviations in all subtasks come from this table.
Purchase Order Line (PO_LN): This table contains all the purchase order information entered in the Enter POs screen in Costpoint Purchasing. The Enter PO Vouchers application in Costpoint Accounts Payable also accesses this table for purchase order information corresponding to the voucher being entered. The PO Detail subtask uses the Purchase Order Line table to populate the fields in its table window. These fields display quantity and cost amount information from the purchase order.
Projects (PROJ): Project names and abbreviations in all subtasks come from this table.
Reference Structure (REF_STRUC): Reference number names in all subtasks come from this table.
Voucher Header History (VCHR_HDR_HS): The Voucher Header History table stores header information (i.e., information that is not included in the table window) for all posted vouchers. This table provides information for all the fields relating to voucher information in the Vouchers subtask (except for the Discount Taken and Amt Paid fields), as well as the voucher header information for the Voucher Detail subtasks (both A/P and PO). It also provides all the voucher header information for the Vendor Labor subtask.
Voucher Labor Vendor History (VCHR_LAB_VEND_HS): After an A/P or PO voucher has been posted, this table stores the data you entered in the Vendor Labor subtask of the Enter A/P or PO Vouchers screens. It also contains a Billable Labor Category Code, which is linked to a PLC description in the Billable Labor Category table. The Vendor Labor subtask uses this table to populate all the fields of its table window, except for the PLC Description.
Voucher Line Account History (VCHR_LN_ACCT_HS): This table stores account, organization, project, cost, and tax information for each voucher line after the voucher has been posted. It provides the data for all the fields in the Voucher Detail (A/P) table window, expect for the Vchr Line, Description, and Notes fields. It also provides account, organization, project, reference number, and amount information for the Vendor Labor subtask.
Voucher Line History (VCHR_LN_HS): This table stores discrepancy, tax, and amount information for each PO voucher line after the voucher has been posted. It also stores line notes and line numbers for all vouchers after they have been posted. The Voucher Line History table provides information for all the fields in the Voucher Detail (PO) table window. It also populates the Voucher Detail (A/P) Line No, Description, and Notes fields.
Vendor (VEND): The Vendor table contains information you entered for vendors in the Maintain Vendors screen. The pay vendor's name and location in all Inquiry screens come from this table.
Vendor Address (VEND_ADDR): This table stores the vendor address information you entered in the Maintain Vendors screen. It provides the information for the Pay Vendor Address and Phone Info group boxes in the Vendor subtask.
Vendor Address Contacts (VEND_ADDR_CNTACT): This table stores the contact information you entered for the vendor in the Contacts subtask of the Maintain Vendors screen. It provides all the information for the Contacts table window.
Vendor Check History (VEND_CHK): The Vendor Check History stores check number, date, posting, and cash account and organization information for checks that have already been posted. It provides all the information for the main screen's table window, as well as the check header information for all the subtasks in the Check History Inquiry screen.
Vendor Check History Voucher Detail (VEND_CHK_VCHR): The Vendor Check History Detail contains information that links checks to particular vouchers. This information includes the voucher vendor ID, the amount of the check that was applied to the voucher (because many vouchers may be paid by the same check), and the discount taken on posted vouchers. It supplies the data for the Discount Taken and Amount Paid fields in both the Vouchers and Form View subtasks.