Vehicle Fuel Usage Exceptions

Use this program to:

Obtain a report (or an exception report) for fuel cards by comparing the distance driven on a RA to the charges made on a fuel card (data from CALTEX is merged into CARS+). Used to determine mis-use of a fuel card.

To access the Vehicle Fuel Usage Exceptions, type FCVRPT(RET) at any menu "OPTION:"field or the appropriate line number on the Fuel Audit Reports Sub-Menu of the Daily Audit Reports sub-menu of the Daily Procedures Menu. The screen will then display:

OPTION: __ VEHICLE FUEL USAGE EXCEPTIONS

1. Start Date 02-22-10
2. End date 02-22-10
3. Fuel Card rate mark-up pct
4. Avergr Fuel at Close Price
5. Under charged trnx only? N
6. Detail/Summary D
7. Print/Display P

1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DATE	Using the selected date format, enter the starting DBR date. Press RET to default to today's date. EXAMPLE: Press (RET)
2. END DATE	Using the selected date format, enter the ending DBR date. Press RET to default to today's date. EXAMPLE: Press (RET)
3. FUEL CARD RATE MARK-UP PCT	This mark up percentage is used in the Under Charged Transaction calculation (see field below.)
4. AVERAGE FUEL AT CLOSE PRICE	Enter the average price per gallon/liter of the fuel. This is used in the Under Charged Transaction calculation (see field below.)
5. UNDER CHARGED TRNX ONLY?	Enter: Y = The fuel tank level at rental and return are compared (including returns for exchanges). When the vehicle is returned with less fuel than it had when rented, a calculation is done using the Average Fuel at Close price (field above) multiplied by the volume difference in the tank. This is subtracted from the RA charge record for fuel. The net fuel amount is divided by the market up percentage to back out the mark up. If the charges on the card are greater than the calculated net charge for fuel, the RA is reported.
6. DETAIL/ SUMMARY	Each RA reported is listed. If detail is requested, under each RA is a row of date for each fuel card purchase record (date/time, fuel type, amount, cost.)
7. PRINT/ DISPLAY	Enter: P = Print a hard copy of this report on your terminal's assigned printer. See the Edit Terminal Records Chapter for instructions on how to assign printers. D = Display this report on your screen. See the General Data Entry Instructions Chapter on how to control the screen display. EXAMPLE:Type D (RET)

PRESS "F1" AT "OPTION" TO BEGIN.

Notes about the report:

RAs are sorted by the fuel card number.