This topic explains how to rematch partially matched vouchers and refunds in the Automatic Reconciliation module by redefining the document amend limits in the database definitions. After you redefine the document amend limits you can rematch partially matched tickets according to the new limits.
You need the user permits Perform actions in Supplier Reconciliation module and Update Database and Website Definitions |
Go to Setup - Database Definitions - Reconciliation.
In the Auto Document Amend Limits section, enter the new amend limits:
Field |
Description |
Gross |
Enter the gross value range of the documents |
Net |
Enter the net value range of the documents. |
Tax |
Enter the tax value range of the documents. |
Go to the Automatic Reconciliation module, and select the Match Vouchers tab.
Enter the search parameters.
Field |
Description |
Import Date |
The date range in which the vouchers and refunds were imported |
File Date |
The date range of the file dates of the imported Excel files |
From Voucher |
The range of voucher or refund reference numbers |
PNR |
The PNR |
Document |
The document type: voucher, itemized refund, or refund. |
Currency |
The document currency. After a file is imported, or after performing a search in this tab, you can select the currencies included in the File Data column. |
In the Status section, select Partially Matched.
Click Find.
The vouchers and refunds are displayed in the results section.
Shared Data |
|
Voucher |
Voucher/refund reference number |
PNR |
Reservation number |
T. File # |
Travel file number |
File Data |
|
Amount |
Amount of the document as reported by the supplier |
Currency |
Currency of the transaction as reported by the supplier |
Tax |
Amount of tax charged for the service as reported by the supplier |
Commission |
Amount of commission granted for the reservation as reported by the supplier |
Net to Remit |
Net amount of payment remittance as reported by the supplier |
System Data |
|
Amount |
Amount of the ticket as returned from the system |
Currency |
Currency of the transaction as returned from the system |
Tax |
Amount of tax charged for the service as returned from the system |
Commission |
Amount of commission granted for the reservation as returned from the system |
Net to Remit |
Net amount of payment remittance as returned from the system |
Select a partially matched voucher with amount
discrepancies that fall within the new amend limits that you described,
and at the end of the row, click
the , and select Re-Match.
The ticket is matched according to the newly defined definitions.
The original document is amended, previously defined parameter values are overwritten, and the row becomes green.