VCH/ REF Report

The VCH/ REF report provides detailed information on vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, as well as the transactions they were issued for.

Purpose

The purpose of this report is as follows:

To display all vouchers that were issued, in the supplier currency and/or travel file currency
To display confirmed/and unconfirmed refunds
To display all types of vouchers, such as commission, markup, and ATC vouchers
To track vouchers and refunds that have already been covered

Output

The report has three system templates:

VCH/REF: Detailed information on vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, as well as the transactions they were issued for.
VCH/REF (Group by Mode): Detailed information on vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, grouped according to a parameter selected in the report output, in the Group by column.
VCH/REF (Summary Mode): Total amounts of vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, grouped according to a parameter you select in the report output, in the Group by column.

This report has the following layouts:

CSV
DOCX
PDF
Text
XLSX

In addition, there is a Print option.

How to generate a report - see Reports.

Filters

The report has the following parameters which are shown on the left and enable you to filter the report output:

Parameter	Description
Type	Choose the type of document.
Display Currency	Choose the type of currency displayed: Document, System or Travel File currency.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
Document No.	Choose the range of document reference numbers.
Status	Choose the status of the document: Active or Cancelled.
Branch	Choose the branch where the document was issued.
Issuing User	Choose the user who issued the document.
T. File User	Choose the travel file user.
Doc. Currency	Choose the document currency.
T. File Number	Choose the travel file numbers.
Supplier Paid	Choose the paid supplier.
Res. Supplier	Choose the reserving supplier.
Service Type	Choose the service type the document was issued for.
Price Level	Choose the price level of the transaction associated with the document.
T. File Agent/ C. Client	Choose the agent or corporate client associated with the travel file.
Refund Status	Choose the refund status of all refunds (if none chosen), confirmed refunds, or unconfirmed refunds.
T. File Start Date	Choose the date range of the travel file start dates in which the document was issued.

Example

The generated VHC/REF report displays detailed information on vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, as well as the transactions they were issued for.

The following fields are displayed in the generated report:

Field	Description
Type	This field shows the type of document.
Document No.	This field shows the document reference number.
Status	This field shows the document status.
Doc. Currency	This field shows the document currency.
Issue Date	This field shows the issue date of the document.
Value Date	This field shows the document due date of the document.
Service Type	This field shows the service type for which the document was issued.
T. File Number	This field shows the reference number of the travel file in which the document was issued.
Branch	This field shows the branch where the travel file was opened.
Issuing User	This field shows the user who issued the document. If you did not select to group by this option, this column is displayed as an individual row.
T. File User	This field shows the user who opened the travel file. If you did not select to group by this option, this column is displayed as an individual row.
Supplier Paid	This field shows the supplier paid on the document.
Res. Supp.	This field shows the reserving supplier on the document.
Agent/C. Client	This field shows the travel agent/corporate client the document was issued for.
CRS #	This field shows the CRS (Computerized Reservation System) number.
Res Supp #	This field shows the supplier reservation number (PNR number with flights).
For Details	This field shows the information that appears in the For field on the document (usually the reason the document was issued).
Tickets	This field shows the flight tickets the document was issued for.
#Pax	This field shows the number of passengers the document was issued for.
Passengers	This field shows the passengers the document was issued for.
Amount	This field shows the total amount on the document.
Tax	This field shows the tax on the document.
Comm	This field shows the commission on the document, not including VAT.
Vat	This field shows the VAT on the commission on the document.
Comm. + VAT	This field shows the commission and the VAT on the document.
Markup	This field shows the markup on the document.
Credit Supp.	This field shows the amount that is paid directly to the supplier.
Net to Remit	This field shows the net amount owed to the supplier. The net amount is calculated as follows: Supplier price + tax - commission - VAT - ATC + P. Fee.
Selling Price	This field shows the selling price on the document.
Selling Price + Tax	This field shows the selling price + tax on the document.
Currency	This field shows the currency according to what was chosen in the filter.
Cover doc.	This field shows the type and the number of the covering document (deposit/number).
RMT	This field shows the remittance covering the PRQ covering the document.
Refund status	This field shows the status of the refund.

Example

The generated VCH/REF (Group By Mode) report displays detailed information on vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, as well as the transactions they were issued for.

VCH/REF (Group By Mode) also displays a pie chart according to parameters chosen.

Each row in the table represents an invoice.

The following fields are displayed in the generated report:

Field	Description
Group By	This field shows the grouping of the document.
Disp. Currency	This field shows the currency displayed according to what was chosen in the filter.
Type	This field shows the type of document.
Document No.	This field shows the document reference number.
Status	This field shows the document status.
Issue Date	This field shows the issue date of the document.
Value Date	This field shows the document due date of the document.
Service Type	This field shows the service type for which the document was issued.
T. File Number	This field shows the reference number of the travel file in which the document was issued.
Branch	This field shows the branch where the travel file was opened.
Issuing User	This field shows the user who issued the document. If you did not select to group by this option, this column is displayed as an individual row.
T. File User	This field shows the user who opened the travel file. If you did not select to group by this option, this column is displayed as an individual row.
Supplier Paid	This field shows the supplier paid on the document.
Res. Supp.	This field shows the reserving supplier on the document.

Example

The generated VHC/REF (Summary Mode) report displays total amounts of vouchers, STKs, credit vouchers, payment requisitions, refunds and itemized refunds issued through the system, grouped according to a parameter you select in the report output, in the Group by column.

Each row in the table represents an invoice.

The following fields are displayed in the generated report:

Field	Description
Group By	This field shows the grouping of the document.
Disp. Currency	This field shows the currency displayed according to what was chosen in the filter.
Sum Amount	This field shows the total amount of the document.
Sum Tax	This field shows the total tax amount of the document.
Sum Vat	This field shows the total VAT amount of the document.
Sum Comm + Vat	This field shows the total commission amount, including VAT, of the document.
Sum Mark Up	This field shows the total markup amount of the document.
Sum Credit Supp.	This field shows the total credit amount for the supplier of the document.
Sum Net to Remit	This field shows the total Net to Remit amount of the document.
Sum Selling Price	This field shows the total selling price of the document.
Sum Selling Price + Tax	This field shows the total selling price, including taxes, of the document.