For Hertz operations not doing EDRB or GAR feed, Hertz provides an Excel template for operations to report their cancelled and no-show reservations. Commonly referred to as the "No-No" file, it actually means "No Rental/ No Commission" file.
This program is used to create a CSV file of data which can be imported into Excel. All cancelled and no show reservations that came from OKC are transmitted.

Running this Program Automatically:

In normal operation, this program is not run manually. Instead, it should be set up to be run on a scheduled basis, for example once a week or once a month. When run automatically, the ASCII CSV file that is created will be emailed to the address(es) specified by the user. Please contact Thermeon Customer Support to arrange for the scheduled running of this program.

At the time of this writing, there are 2 similar formats in use. The only difference in the formats is how the Area and Location numbers are listed. In one format, the area and location number are combined in one column with a hyphen between them, such as " 12345-01". In the second format, the area number is in one column and the location number is in another column. The CSV file includes columns with BOTH formats. Prior to submitting the Excel file to OKC, be sure to delete the column(s) that don't meet the OKC Excel template format required for your operation.

User Note: This program is used to send No-Showed or cancelled reservations to OKC for Travel Agency Commission processing. Filled reservations MUST be sent via the Hertz Radius File Creation file program. Both programs must be used to report transactions to OKC.

Locations not operating their system in USD currency:
There must be a record in Edit Exchange Rates with an effective date that is in effect for the data being transmitted. The Exchange record must have "USD" in Field 1 (From Curr Code) and the currency code from the Location File (as entered on Page 3, field 3) in Field 2 (To Curr Code). An example is shown below.

OPTION: EDIT EXCHANGE RATES 1 From Curr Code USD 2 To Curr Code ARS 3 Posting Company 4 Net Vchr Code 5 Effective Date 01-22-13 6 Effective Time 0600 7 Divide by Rate .202839 8 Multiply by Rate 2.000000 1BEGIN 2NEXT 3ERASE 4PREVIOUS 5BACKUP 6 7HELP 8

The program searches the Exchange Rate file for an effective record as described above. If a valid exchange record is not found, the amounts will not be converted to USD.



The Excel template used by licensees is as follows:

AREA-LOC	LOC	TA NUMBER	CKOT DATE	PREPAID IND	RA NUMBER	CX/NS	REV AMT USD	DISC INC	RATE CODE	RES ID	RNTR LAST NAME	RNTR FIRST NAME
4 or 5 digits- 2 digits	2 digits	8 digits	"m/d/yyyy" format only	"Y" or "N" or blank	alphanumeric, no spaces or dashes	"CX", "NS" or blank	must be in $USD	"Y" or "N" or blank	must be an acceptable rate code	alphanumeric, no spaces or dashes	Alpha	Alpha
TEXT	TEXT	TEXT	CUSTOM	TEXT	TEXT	TEXT	GENERAL	TEXT	TEXT	TEXT	TEXT	TEXT

To access the Res No-No File Creation program, type NONO (RET) at any menu "OPTION:" field or the appropriate line number on the Hertz Data Transmissions menu. The screen will then display:

OPTION: Res NO-NO FILE CREATION 1 Start Date 06-24-14 2 End Date 06-24-14 3 Detail/Summary D 4 Separate Page(s) Y 5 Print/Display N /dev/tty 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8