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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Select this option to view advances on the report.
Select this option to view expense reports.
Select this option to view company-paid expenses.
The vendor ID is displayed in this column.
The full vendor name is displayed in this column.
The vendor location is displayed in this column.
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.
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.
The due date for the item will display in this column.
The system calculates the value in this field by subtracting the Discount Amount column from the Total Amount column.
The voucher number, as it was generated by the system or assigned by the user, will display in this column.
This column displays the amount to be deducted from the voucher for early payment of invoice.
This column displays the last payment date that would allow for early payment discount.
The total amount of the item is displayed in this column.
This column displays the location of the document that contains supporting data.
The year to which the transactions are posted is displayed in this column.
The period to which the transactions are posted is displayed in this column.
The subperiod to which the transactions are posted is displayed in this column.
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.
Click this button to open up the Checks Disbursed subtask.
Click this button to open up the Vouchers Posted subtask.
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.
Click this button to launch the appropriate application (Word, Excel, etc.) that will open the file.