The Vendor Transaction History (VTH) page allows you to search for specific information related to vendor transactions. It is primarily used to view payment status and history. By entering specific search criteria in the Query tab and selecting the Apply action, results of your query are then displayed in the Results tab of the page. Vendor Code is the only required search field. Other search fields on this page are optional and can be used for additional filtering. Every additional search field entered causes the search criteria to be narrowed. For example, a search on Vendor Code alone may return 50 records while a search on Vendor Code and Transaction Type may return 15 records.
The number of records that will be returned is limited by the VTH Maximum Record Count parameter on the Application Parameters table. If the number of records in your results set exceeds this parameter, an error will be issued and you will be asked to refine your search criteria.
The Vendor Transaction History page provides a few features to assist you in your research or analysis:
Search for payment details, status, and history
Transaction Types included in the query: RQ, PO, PR, ABS, AD, MD, DC, CR, RE, IET, ITA, JV, and PYRL
CR - only CR transactions with an Event Category of REF (Refund)
RE – only RE transactions with an Event Category of REF (Refund)
IET – only IET transactions where the Initiator Code on the transaction Header is equal to R (Receiver/Buyer). (Note: Includes Cancellation versions, since cancellation of these transactions represents a cancellation of an internal transfer rather than a transaction cancellation.)
ITA - only ITA transactions where the Initiator Code on the transaction Header is equal to R (Receiver/Buyer). (Note: Includes Cancellation versions, since cancellation of these transactions represents a cancellation of an internal transfer rather than a transaction cancellation.)
JV - if a Vendor Code has been used on the transaction
Navigate to different pages within the application with the transaction filtered upon transition:
Navigate to different transactions from Vendor Transaction History via the hyperlink in the Transaction ID column
Calculate Amount totals based on search criteria (total of accounting line amounts of all payments found). Disbursement Transactions (AD, EFT, and MD) with a Phase of Cancelled are not included in the calculation. When you refresh the page (by entering the new search criteria and clicking Apply), the Calculate Amount Total button needs to be clicked again to get the updated Total AL Amount.
Download search results to a spreadsheet. To export the queried results, refer to the "Export Grid Results" topic in the CGI Advantage Page/Table User Guide.
Note that Vendor Transaction History page only displays finalized transactions and does not display transactions in a Draft Phase or transactions that are pending approval. The only exceptions are Cancellation versions of IET and ITA transactions, since a cancellation of these transactions represents a cancellation of an internal transfer rather than a transaction cancellation.
The Vendor Payment History page allows you to search for specific information related to vendor payment transactions. The difference between Vendor Transaction History and Vendor Payment History is that Vendor Payment History page only allows you to query disbursement/payment information (that is, transactions that belong to the AD, MD, DC, CR, RE, IET, and ITA Transaction Types). The Vendor Transaction History page allows you to also query transactions of the RQ, PO, PR and ABS Transaction Types.