TRAVEL HISTORY INQUIRY

Use this screen to perform inquiries on all travel items that have been posted to A/P. These items include matched and unmatched advances, expense reports, company-paid expenses, vouchers, and checks/EFTs. Use this screen to save time by drilling-down to travel details without opening many screens in different modules or printing numerous reports.

You can prepare the most comprehensive report by leaving vendor and fiscal year criteria blank, then clicking the Execute button on the toolbar. This will produce a table populated with all posted travel items for advances, expense reports, or company-paid expenses. To prepare a report with more specialized information, fill in the selection fields before clicking Execute.

Run this inquiry at any time. To obtain the most accurate information, refrain from performing this inquiry when posting new travel advances, expense reports, and company-paid expenses.

Vendor

Enter, or use to select, a vendor ID. The table will be populated only with information about this vendor. If you leave this field blank, the table will be populated with multiple vendors.

Advance No.

This field will appear only if you have selected the Advance option in the Item Type group box.

Enter one specific advance number. If you leave this field blank, all advance documents will be retrieved. The default setting for this field is blank.

Expense No.

This field will appear only if you have selected the Exp Rpt option in the Item Type group box.

Enter one specific expense report number. If you leave this field blank, all expense report documents will be retrieved. The default setting for this field is blank.

Voucher No.

This field will appear only if you have selected the Co Paid Exp option in the Item Type group box.

Enter only one specific voucher number. If you leave this field blank, all relevant voucher numbers will be retrieved. The default setting for this field is blank.

Date

If you selected the Advance option in the Item Type group box, enter the Costpoint entry date of the advance in this field. If you selected the Exp Rpt option, enter the expense report date. If you selected the Co Paid Exp option, enter the vendor invoice date. If you leave this field blank, all relevant document dates will be retrieved. The default setting for this field is blank.

Fiscal Year

Enter, or use the drop-down list to select, the fiscal year that the items were posted. If you leave this field blank, all relevant document dates will be retrieved. The default setting for this field is blank.

Period

Enter, or use the drop-down list to select, the period that the items were posted. If you leave this field blank, all relevant document dates will be retrieved. The default setting for this field is blank.

Subperiod

Enter, or use the drop-down list to select, the subperiod that the items were posted. If you leave this field blank, all relevant document dates will be retrieved. The default setting for this field is blank.

Item Type

Use this group box to select the item type for your inquiry. If you select the either the Advance or Co Paid Exp option, the Advances button will be inactive.

Advance 

Select this option to view advances on the report.

Exp Rpt 

Select this option to view expense reports.

Co Paid Exp 

Select this option to view company-paid expenses.

Table Window

Vendor

The vendor ID is displayed in this column.

Vendor Name

The full vendor name is displayed in this column.

Vendor Location

The vendor location is displayed in this column.

Number

If you selected the Advance option in the Item Type group box, the advance number, as it was generated by the system or assigned by the user, will display in this column.

If you selected the Exp Rpt option in the Item Type group box, the expense report number, as it was generated by the system or assigned by the user, will display in this column.

If you selected the Co Paid Exp option in the Item Type group box, the invoice number of the company-paid invoice will display in this column.

Date

If you selected the Advance or Exp Rpt option, this column displays the date the item was entered into Costpoint. If you selected the Co Paid Exp option, this column displays the invoice date on the company-paid invoice.

Due Date

The due date for the item will display in this column.

Amount Due

This field will appear on your screen only if you have selected the Co Paid Exp option in the Item Type group box.

The system calculates the value in this field by subtracting the Discount Amount column from the Total Amount column.

Voucher Number

The voucher number, as it was generated by the system or assigned by the user, will display in this column.

Discount Amount

This field will appear on your screen only if you have selected the Co Paid Exp option in the Item Type group box.

This column displays the amount to be deducted from the voucher for early payment of invoice.

Discount Date

This field will appear on your screen only if you have selected the Co Paid Exp option in the Item Type group box.

This column displays the last payment date that would allow for early payment discount.

Total Amount

The total amount of the item is displayed in this column.

Document Location

This column displays the location of the document that contains supporting data.

Fiscal Year

The year to which the transactions are posted is displayed in this column.

Period

The period to which the transactions are posted is displayed in this column.

Subpd

The subperiod to which the transactions are posted is displayed in this column.

Detail

Click this button to view detailed information about the items. If you selected the Advance option in the Item Type group box, the Advance Detail subtask will be opened. If you selected the Exp Rpt option, the Expense Report Detail subtask will be opened. If you selected the Co Paid Exp option, the Company Paid Detail subtask will be opened.

Checks

Click this button to open up the Checks Disbursed subtask.

Vouchers

Click this button to open up the Vouchers Posted subtask.

Advances

Click this button to open up the Advance Applied subtask. This button is available only if you have selected the Exp Rpt option in the Item Type group box.

Launch

Click this button to launch the appropriate application (Word, Excel, etc.) that will open the file.