I. SET-UP STEPS

A. Records need to be set up in the Edit Ticket Charge Codes file. This file allows the user to configure how this program will work for the various types of vendors that charge for tolls.

B. A Ticket Charge Codes (previous step) must be assigned to each vendor in the Vendor file whose tolls are to be processed by this program.

C. Hertz users only (these steps may be skipped by all other users,

1. The Edit TICGAR Control Record should be set up . Refer to the chapter Edit TICGAR Control Record for more information.

2. Prior to using this program, the next "ticket reference number" must be defined. This is done using the program Edit Next TICGAR Number. Since this is typically a "run once" program, it is not on a menu. It can be accessed by typing RUN and any menu "OPTION" field, then typing EDNTGR in the "Name of Program" field. (Note: The user's menu security level must include the "Run A Program" item on the System Management Menu in order to perform this step.) The screen will then display:

OPTION: __ EDIT NEXT TICGAR NUMBER 1 Next TICGAR # 1SAVE 2 3 4 5BACKUP 6 7HELP 8

Enter the next reference number into field 1.

Press enter to return to the OPTION field, then press F1 to save the record.

II. SPREADSHEET FORMAT

The following table lists the required column headers to be used in the spreadsheet. After entering data, export the data as a comma delimited file and place it on your CARS+ server for processing. Warning: The column headings must be character by character as they are illustrated in the chart below and the format instructions must be followed. Additional columns may be added to the spreadsheet but they will be ignored by the processing program.

Required Column Header	Format	Notes
Date	DDMMYY	date the toll was received by the rental company
Vendor-no	8 character Vendor number	this is the Vendor number of the toll issuer
Offense-type	2 character code	Leave this column blank. The Ticket Charge Code record that is to be used for the admin fee and taxes charged comes from the Charge Code on the Vendor in the previous field will be used.
Citation	up to 20 characters alphanumeric	Toll citation number
Amount	nnnnnn.nn	The amount of the toll charge without any administration fees
License	11 character vehicle license number	License plate number of the vehicle involved
Ticket-date	DDMMYY	Date the toll occurred
Ticket-time	HHMM (using a 24 hour clock [2pm = 1400))	Time the toll occurred
Description	30 characters	A description of the toll road or bridge

III. TRANSMITTING THE FILE FROM A PC TO THE CARS+ SERVER

Create the spreadsheet on a PC or computer that is also used to access CARS+. Once the spreadsheet is done, save it in the csv format. Then on the same computer, sign into and access CARS+. Go to the Batch Ticket Processing Report program and with the cursor at the "OPTION" field, press F4 to upload the file. A browser window will appear. Select the csv file from your PC and click "Send".

IV. RUNNING THE PROGRAM

If the file has been previously imported (using the above instructions), the file can be loaded for processing by either typing the file name in Field 1 or searching for it. To search, place the cursor in Field 1 and press F6. A search window will appear on the lower half of the screen. An example is shown below.

OPTION: __ IMPORT TOLL CHARGES 1 Batch file name 2 Ticket Received RA/NRV# 3 Ticket No. 10 Last Name 4 Ticket Issuer 11 First Name 5 Ticket Date 12 Address1 6 Ticket Time 13 Address2 7 Offense Type 14 City 8 Ticket Amt 15 State 9 License No. 16 ZIP /dev/tty Option: _ TICKET FILE SEARCH F2=NEXT 8 F4=PREV 8 File Name Create Date 1 ticket-101112.csv Oct 11 12:00 2 ticket-100312.csv Oct 3 14:20 ** No More Records **

Select the appropriate file by typing the row number.

After loading the name of the file to be processed, place cursor back in the "OPTION" field and press F1 to begin.

The Import Toll Charges program works as follows:

A. All records in the spreadsheet are sorted by Vehicle License Plate number and then citation issue date/time (this is to discover if multiple tickets were written for a single rental). As a result, they may be processed on the screen in a different order than the order expected.

For each line in the spreadsheet:

B. If the vendor number doesn’t match an existing vendor record in CARS+, an error is displayed and the record is skipped.

C. If the vendor does not have a Ticket Charge Code assigned to it and the Offense Type column in the spreadsheet is blank, an error is displayed and the record is skipped.

D. If the vehicle license number doesn’t match an existing license number in the Vehicle file, an error is displayed and the record is skipped.

E. Next, the Vehicle History file is checked to see if this toll has already been processed. If a toll record (Service Code "X5") is found, an error is displayed and the record is skipped.

F. If the vendor number and vehicle number are validated, the RA file (and optionally the Non-Rev file) are examined for records in accordance with the date and time of the toll.

When only one transaction involving the cited vehicle is found, and the GVT record “QUICKTKT” exists, the ticket is processed and nothing displays on the screen. Otherwise, the RA and/or NonRev is displayed on the main window for editing by the user.

Press F1 to proceed with processing.

When more than one record is found, the possibilities are displayed in the subwindow on the screen. The user must then select the line number for the correct record, or the user may press ESC to exit the subwindow without selecting a line.

If no records are found in the RA or Non-Rev files, the vehicle history file is examined for Service Code records number 00 (RAs) and 93 (Non-Revs) in case the RAs or Non-Revs have already been purged off the system.

At any time, the user can press F2 to skip the record displayed and move on to the next record in the file. If a record is skipped it will appear on the error report at the end of the run.

G. Pressing F1 for each ticket displayed causes the the program to write a ticket to be processed and the following occurs:

1. Edits made to the renter’s address are saved to their customer record.

2. Edits made to the displayed name are saved to their customer record.

3. A Service Code "X5" Vehicle History record will be written for the toll. This will be written as an "open", un-invoiced record.

4. The next ticket from the spreadsheet file is then displayed.

H. Once all records have been processed, two audit files are produced:

• The first lists all toll charges which were successfully matched to a vehicle number and were processed.
• The second lists all charges that erred out.

To access this program: To access the Ticket Processing Report, type IMPTOL (RET) at any menu "OPTION:" field or the appropriate line number on the Ticket/Toll Processing Sub-Menu of the History/Maintenance Menu. The screen will then display:

OPTION: ____ IMPORT TOLL CHARGES 1 Batch file name 2 Ticket Received RA/NRV# 3 Ticket No. Name 4 Ticket Issuer 10 Address1 5 Ticket Date 11 Address2 6 Ticket Time 0000 12 City 7 Offense Type 13 State 8 Ticket Amt 14 ZIP 9 License No. /dev/tty 1BEGIN 2 3ERASE 4UPLOAD 5BACKUP 6SEARCH 7HELP 8

Enter data as follows:

1. BATCH FILE NAME	Enter the name of the ascii comma delimited file containing the toll data. Press F1 to begin processing the records.
2. TICKET RECEIVED	This field displays the date the toll was received.
3. TICKET NO.	This field displays the toll number of up to 20 alphanumeric characters.
4. TICKET ISSUER	This field displays the Vendor number of the entity that issued the ticket.A valid Vendor number must be used.
5. TICKET DATE	This field displays the date the toll was issued.
6. TICKET TIME	This field displays the time the toll was issued.
7. OFFENSE TYPE	This field displays the Ticket Charge Code from the vendor record.
8. TICKET AMT	This field displays the amount of the toll.
9. LICENSE#	This field displays the license number of the vehicle stated on the ticket.
10. ADDRESS 1 11. ADDRESS 2 12. CITY 13. STATE 14. ZIP	If the customer’s address needs to be updated (obvious typographical errors done at the counter), enter the new information in these fields. Upon pressing F1 to save, the data entered will update the customer record.