Use the Vehicle Location History Report to obtain:


Vehicle history records are examined and used for this report. Specifically:
Rental records (Service Code 00)
Non-rev movements (Service Code 93)
Miscellaneous movements (Service Code X1)
"X1" records - In order to track all transactions and movements of vehicles, the following programs write a vehicle location record to the history file using Service Code X1:

Foreign RA Entry
Hertz One-Way RA Close
Hertz Merge One-Way RAs
Make Vehicle Available
Car Wash Entry
Edit Exchange
Physical Inventory Update

Included in the report are:
Records that fall within the requested date range
The most recent history record that is just earlier than the start date/time

Records are sorted first by model code, then by vehicle number. The number of days (down to the minute) that are elapsed between location changes are calculated. This is then expressed as either days or as a percentage (depending upon which was requested.) To get a detailed listing of the transactions that caused the vehicle to be at one or more locations during the time in question, use the Vehicle Location Transaction Report.

Note: This report cannot be run for a dates that pre-date when this enhancement became available to the operation through a CARS+ upgrade.
To access the Vehicle Location History Report program, type LOCRPT (RET) at any menu "OPTION:" field or the appropriate line number on the History/Maintenance Menu. The screen will then display:

OPTION: __ VEHICLE LOCATION HISTORY REPORT

1 Location ALL
2 Vehicle ALL
3 Owning Location TUS
4 Class ALL
5 Start Date 12-01-16
6 Start Time 0000
7 End Date 12-31-16
8 End Time 2359
9 Include Foreign Y
10 Days or Percent P
11 Detail/Summary D
12 Print/Display/CSV C
13 Printer: /dev/tty




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

Enter data as follows:

1. LOCATION

Enter:

  1. Up to 6 alphanumeric characters to select a single location where a vehicle has been.
  2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+".
  3. "ALL" to include all locations.

EXAMPLE: Type TUS (RET)

2. VEHICLE

To limit the report to a single vehicle, enter the unit number. Otherwise, press (RET) to include all vehicles.

EXAMPLE: Press (RET)

3. CLASS

Enter:

1. Up to 4 alphanumeric characters to indicate a single class of vehicle.

2. A Class Group (starts with a + sign followed by up to 5 characters), such as " +MID".

3. or press RET to default to all classes.

EXAMPLE: Type E (RET)

4. START DATE

Using the selected date format, enter the starting date. Press RET to default to the first day of the previous month.

EXAMPLE: Press (RET)
5. START TIME

Using the selected time format, enter the starting time. Press RET to default to the beginning of the day.

EXAMPLE: Press (RET)

6. END DATE

Using the selected date format, enter the Ending date. Press RET to default to the last day of the previous month.

EXAMPLE: Press (RET)
7. END TIME

Using the selected time format, enter the ending time. Press RET to default to the end of the day.

EXAMPLE: Press (RET)

8. INCLUDE FOREIGN

Indicate if foreign locations should be included. Enter

Y = Include foreign locations

N = Do not include foreign locations

EXAMPLE: Type Y (RET)
9. DAYS OR PERCENT
 Select how the data should be reported:

D = Report using days

P = Report using percentages

EXAMPLE: Type P (RET)

10. DETAIL/
SUMMARY

Enter 1 alpha character to select the report format.

D = Detailed Report. Each vehicle will be listed.

S = Summary Report. No vehicles will be listed. Instead, totals are shown by model and location.

EXAMPLE: Type D (RET)

11. PRINT/
DISPLAY/CSV

Enter:

P = Print a hard copy of this report on your terminal's assigned printer or send as an e-mail. See the Edit Terminal Records Chapter on how to assign printers and send reports as e-mails.

D = Display this report on the terminal screen. See the General Data Entry Instructions Chapter on how to control screen display.

C = Create a CSV file and send to the local PC. In order to get the CSV file, the CARS+ Report Printer must be set to a value that causes the output to be opened or saved as a file. For most users, the value of CSV will work for this purpose. Please refer to the chapter for Edit Terminal Records or Change User Environment for more information on setting up printing to a file and/or opening a file in the default program for that file.

EXAMPLE: Type C (RET)

12. PRINTER

 Use this field to change the default printer.


The screen will then display:

OPTION: __ VEHICLE HISTORY REPORT

1 Location TUS
2 Vehicle ALL
3 Class ALL
4 Start Date 12-01-16
5 Start Time 0000
6 End Date 12-31-16
7 End Time 2359
8 Include Foreign Y
9 Days or Percent P
10 Detail/Summary D
11 Print/Display/CSV C
12 Printer: /dev/tty


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

PRESS "F1"AT "OPTION:" TO BEGIN THE REPORT.


The following columns are shown on the report:

Detailed Version:

Model code
Year
Class
Vehicle number
Location Type
Vehicle history location
Number of Days or Percentage

Summary Version:

Location
Model Code
Year
Class
Days
Average Fleet (Days divided by report days)

CSV File:

In addition to above, the follow are included:

Monthly Cost (amount entered in the 'Monthly Payment' field in the inventory record (page 4, Field 4)

Calculation of the Location Cost (percentage at the location applied to the Monthly Payment)

Value in the 'Misc Amt' field in the inventory record (page 4, Field 34)

Calculation of the Location Misc. Cost (percentage at the location applied to the Misc Amt)

USER TIP: These calculations will be done regardless of the date range for the report. Therefore, the values entered in the 'Monthly Cost' and 'Misc Amt.' fields in the Inventory record must be logical.

Notes about this report:

The purchase and sale dates of each vehicle are taken into consideration.

Example: a vehicle was sold April 15; the report is run for April 1 - 30. At most, the vehicle percentage can be 50% or the days can be 15 days since it was in the fleet for only 15 out of 30 days.

The calculations are based on the dates/times requested.

Example: A report from April 1 to 10 will use 10 days as the 'whole' for the calculations. If a vehicle was at a location for 7 days, it would be reported at 70% for that location. (7/10)

If the report is run for a 30 day month and a vehicle was at a location for 7 days, it would be reported at 23.33% for that location. (7/30)