Use this screen to analyze those travel items that have already been matched. Because it is possible to match many items at one time on the Match Company Paid Expenses screen, the matching may occur without an item-by-item inspection. You can use this screen to analyze those matched items by vendor, traveler, trip number, expense type, and expense report number or voucher number.
To prepare the most comprehensive report can be prepared by leaving all Vendor, Traveler, Trip No, Exp Type, and Exp Rpt No/Voucher No fields blank and clicking the Execute button on the toolbar. This will produce a table populated with all matched travel items. To prepare a report with more specialized information, enter information into the fields in this screen and click the Execute button.
Run this inquiry at any time to view matched items for the current or prior periods. Because travel items can be expensed and matched in different periods, this inquiry can be helpful to view travel expenses that were incurred in one period and then matched in another. To obtain the most accurate information, refrain from performing this inquiry when new matches are being created in the Reconcile Unmatched Expenses or the Match Company Paid Expenses screens.
Use this field to query on only one vendor at a time. Use 
or enter the vendor ID for your inquiry. The vendor name
and location will display to the right of the ID. If you want to review
all the matched travel items for one vendor, leave the following fields
blank: Traveler, Trip
No, Exp
Type, and Exp
Rpt No, or Voucher
No.
Use this field to query on only one traveler at a time. Use or enter the traveler ID for your inquiry. The traveler name
will display to the right of the ID. If you want to review all the matched
travel items for one traveler, leave the following fields blank: Vendor,
Trip No, Exp
Type, and Exp
Rpt No or Voucher
No.
Enter the trip number you want to query. If you want to review all the matched travel items for one trip number, leave the following fields blank: Vendor, Traveler, Exp Type, and Exp Rpt No or Voucher No.
Enter the expense type you want to query. If you want to review all the matched travel items for one expense type, leave the following fields blank: Vendor, Traveler, Trip No, and Exp Rpt No or Voucher No.
If you have selected the Expense Report option in the Select group box, enter the expense report number for your inquiry. If you have selected the Company Paid option in the Select group box, enter the voucher number for your inquiry. If you want to review all the matched travel items for one expense report number or one voucher number, leave the following fields blank: Vendor, Traveler, Trip No, and Exp Type.
Use this group box to populate the table with items entered via expense reports or company-paid items. The default setting is Expense Report.
Select this option to inquire only on matched items that originated on an expense report.
Select this option to inquire only on matched items that originated on a company-paid invoice.
Use this group box to focus your query on a specific period of time. This time period will employ the periods and subperiods in which the travel items were matched and does not necessarily reflect the actual date of travel associated with the expense.
Enter, or use the drop-down list to select, the year in which the travel items were matched.
Enter, or use the drop-down list to select, the period in which the travel items were matched.
Enter, or use the drop-down list to select, the subperiod in which the travel items were matched.
You cannot edit the items in this table.
This column displays the vendor ID.
The vendor name is displayed in this column.
The vendor location is displayed in this column.
The trip number is displayed in this column.
Either E (Expense Report) or C (Company Paid) is displayed in this column.
This column displays the expense report number as it was generated by the system or assigned by the user.
This column displays the expense report date.
This column displays the A/P voucher number as it was generated by the system or assigned by the user.
This column displays the invoice date.
The expense type is displayed in this column.
The fiscal year in which the travel items were matched is displayed in this column.
The period in which the travel items were matched is displayed in this column.
The subperiod in which the travel items were matched is displayed in this column.
The traveler ID is displayed in this column.
The traveler name is displayed in this column.
The start date for this trip number is displayed in this column.
The end date for this trip number is displayed in this column.
This column displays the number of items that were multiplied by the amount in the Rate column.
This column displays the rate that is associated with certain types of expenses and was multiplied by the Units column.
This column displays the expense amount. If the Units and Rate columns are used, this will be the product of those two columns. If the Units and Rate columns are not used, this is the expense that was entered from the invoice or the expense report.
The project, if any, is displayed in this column.
The organization is displayed in this column.
The account is displayed in this column.
The destination is displayed in this column.
The transportation code is displayed in this column.
This column displays the ticket or unique item number, if applicable.
The transaction type description is displayed in this column.
If you have designated a label for this field, it will display as the field heading and the column may be populated with the data entered with the original invoice or expense report.
If you have designated a label for this field, it will display as the field heading and the column may be populated with the data entered with the original invoice or expense report.
The project abbreviation, if there is a project, is displayed in this column.
The organization abbreviation is displayed in this column.
This column displays the fiscal year in which the expense item row was posted into Costpoint, either through an expense report or a company-paid voucher.
This column displays the period in which the expense item row was posted into Costpoint, either through an expense report or a company-paid voucher.
This column displays the subperiod in which the expense item row was posted into Costpoint, either through an expense report or a company-paid voucher.
This column displays the source of the travel expense item listed in this row. Items entered into Costpoint through standard entry will be marked S. Items that you entered into Costpoint in the Enter Unmatched Expenses screen (for initialization purposes) will be marked U.
Highlight a row and click this button to view the reverse of the information presented. If you are viewing an expense report item (for example, if you selected the Expense Report option to populate the table), the Matched Items subtask will display the matching company-paid items. If you are viewing a company-paid item (for example, if you selected the Company Paid option to populate the table), the Matched Items subtask will display the matching expense report items.
Highlight a row and click this button to show the information from the original entry. If you are viewing an expense report item (for example, if you selected the Expense Report option), the History subtask will display the expense report as it was originally entered. If you are viewing a company-paid item (for example, if you selected the Company Paid option), the History subtask will display the expense voucher as it was originally entered.
Highlight a row and click this button to view the information on a single-form view instead of in a table format.
This screen accesses the following tables:
CO_VEND_MATCH_HS
VEND
EXP_HDR
EXP_LN_HS
CO_EXP_HDR
CO_EXP_LN_HS