Use this program to produce a listing of vehicles with:
  1. A Sale Date within the dates specified or
  2. A buy back program Accepted Date within the dates specified.

The information provided by this report includes the vehicle's identification number, capital cost, accumulated depreciation, sale date, sale price, and monthly holding cost.

To access the Vehicles Sold Report, type SOLD (RET) at any menu "OPTION:"field or the appropriate line number from the Fleet Menu. The screen will then display:

OPTION: __ VEHICLES SOLD REPORT

1 From Sold date EARLIEST
2 To Sold date LATEST
3 Start Curr Date EARLIEST
4 End Curr Date LATEST
5 Sold or Accepted S S=Sold Only, A=Accepted Only, B=Both
6 Owning Location 6 SHIFT+F7 FOR CODES
7 Lic# or Odom L
8 Sort by S V=Vehicle# S=Sale date P=Purch date 8=VinLast8
9 Format 1 / 2 1
10 Print/Display P
11 Current Location ALL


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

Enter data as follows:

1. FROM SOLD DATE

Using your selected date format, enter the Starting Sold Date. Press RET to default to the EARLIEST record in your system.

EXAMPLE: Type 010104(RET)

2. TO SOLD DATE

Using your selected date format, enter the Ending Sold Date. Press RET to default to the LATEST (most recent) record in your system..

EXAMPLE: Type 033104(RET)

3. START CURR DATE

Using your selected date format, enter the Starting vehicle current date. Press RET to default to EARLIEST.

EXAMPLE: Type 010104(RET)

4. END CURR DATE

Using your selected date format, enter the Ending vehicle current date. Press RET to default to LATEST.

EXAMPLE: Type 033104(RET)

5. SOLD OR ACCEPTED

Enter:

S = To report only vehicles which have been sold and whose sale date falls within the requested date range.

A = To report only vehicles with an accepted date which falls within the date range entered in Fields 1 and 2.

B = To report both sold and accepted vehicles.

EXAMPLE: Type S (RET).

6. OWNING LOCATION

Press Shift and F7 to bring up a pop-up window listing choices pertaining to the Owning Location as shown below:

OWNING LOCATION CODES

1) Local Location/Pool
2) Owned from other pool
3) Both 1 & 2
4) FOREIGN
5) Both 2 & 4
6) ALL Vehicles
LOC#) Specific Location

EXAMPLE: Type TUS(RET)

Note: Your user access may be limited as to the locations for which you can run this report. If your access is restricted and you attempt to enter a location or location group which is outside your allowed parameters, the following message will be displayed at the bottom of the screen and your selection will be ignored:

RESTRICTED REPORT LOCATION

7. LIC# OR ODOM

Enter:

L = One of the columns on the report will be the license plate number of the sold vehicles.

O = A column showing the odometer reading of the vehicle will be shown instead of the license plate.

EXAMPLE: Type O (RET)

8. SORT ORDER

Enter:

V = Vehicles appear in vehicle number order.

S = Vehicles appear in the order of date sold.

P = Vehicles appear in purchase date order.

8 = Vehicles appear in order of the last 8 characters of their VIN#.

EXAMPLE: Type V(RET)

9. FORMAT 1 / 2

Enter:

1 = The report will include the columns “Sold To” and “Current Date” instead of the 2 columns mentioned in Format 2 below.

2 = The report will include the columns “Prepaid Fees” and “Odometer” instead of the 2 mentioned in Format 1 above.

EXAMPLE: Type 1 (RET)

10. PRINT/
DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer. See the Edit Terminal Records for instructions on how to assign printers.

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

EXAMPLE: Type P(RET)

11. CURRENT LOCATION

This field allows you to limit the report to vehicles currently at a particular location or to locations in a location group. Enter up to 6 alphanumeric characters representing a location, or a location group. Press (RET) to default to ALL locations.

EXAMPLE: Type TUS (RET)

The screen will then display:

OPTION: __ VEHICLES SOLD REPORT

1 From Sold date 01-01-04
2 To Sold date 03-31-04
3 Start Curr Date 01-01-04
4 End Curr Date 03-31-04
5 Sold or Accepted S S=Sold Only, A=Accepted Only, B=Both
6 Owning Location TUS SHIFT+F7 FOR CODES
7 Lic# or Odom O
8 Sort by V V=Vehicle# S=Sale date P=Purch date 8=VinLast8
9 Format 1 / 2 1
10 Print/Display P
11 Current Location TUS

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

PRESS "F1"AT "OPTION:" TO BEGIN PRINTING.

READING THE VEHICLES SOLD REPORT

Certain columns on the Vehicles Sold Report may not be immediately apparent. These include:

GAIN/LOSS = Sale Price - Current Value

HOLDING #MOS = The number of months the vehicle has been in the fleet.

HOLDING COST = Capital Cost - Sale Price divided by # months held.

HOLDING PCT = Holding Cost divided by the Capital Cost (expressed as a percentage).

Vehicles that are included on the report because of a buy back acceptance date are NOT included in any subtotals or averages. Their accepted date appears in the Sold Date column followed by an asterisk.