Use this report to generate a comma-delimited file of utilization data. This data is designed to be imported into a spreadsheet to generate a "Daily Condition Report". This program only creates a file, there is no printed or on-screen report.
This program uses data stored in Fleet Summary and DBR Summary files. These files are populated by background programs run from the operating system scheduler. Please contact the Thermeon Customer Support Department to make sure these programs have been set up on your system. When reading the Fleet Summary file, this program uses the data for Run Type 01.
The revenue data for this report is populated by posting the Accounting DBR (DBRA). No revenue will be shown for a given date if that date has not been posted. The DBRA can be set up to run and post automatically. Please refer to the chapter Overview - Automatic Posting for more information.
The revenue on this report is based only on those items which are flagged with a "Y" in the "Report as Revenue" field in the Edit Optional Items program. Changes to which options are so flagged do not have a retroactive effect on this report. Changes will be effective with the next posting of the DBRA.
Since this report depends on data from the Fleet Summary and DBR Summary files, it is important that it be run after running the programs (noted in points 1 and 2 above) that populate the data to these files.
While this report can be run for a range of dates, the design intent of this report is that it will be run every day for a single date (either the previous or the current day). The data from each day will then be imported into a spreadsheet such that there is a workbook that contains multiple sheets, one sheet for each daily data file. The spreadsheet can then be programmed to combine, sum, average, and/or analyze the data in whatever manner is desired, e.g, Week-to-date, Month-to-Date, Year-to-date, difference between individual dates or date ranges, etc.
The program may be run on a scheduled basis using the CARS+ Report Driver feature. Please refer to the chapter Print Auto Create Reports for more information.
To access the Data Export for DCR program, type DCREXP (RET) at any menu "OPTION:" field or the appropriate line number on the Utilization menu. The screen will then display:
| OPTION: __ DATA EXPORT FOR DCR 1 Start DBR Date 08-01-11 21 Dirty 2 End DBR Date 08-31-11 22 Disappeared 3 Class Detail N 23 Body Shop Status Code Definitions 24 Insurance,Body Shop 4 Available 25 Paid Carshop 5 Local Repair 26 Paid Dealership 6 Foreign Repair 27 Physical Inventory Dealership 7 Stolen 28 Physical Inventory Carshop 8 Totaled 29 Remarketing 9 Accident 30 Move to Sale 10 Temp Non-Prod 31 GPS Installation 11 Perm Non-Prod 32 Theft Report Process 12 Invoice Dealership 13 Avg Oper Fleet 14 Printer CSV 15 Doc.Pending 16 Invoice Carshop 17 New Vehicles 18 Damaged on Sale 19 Complimentary 20 Own Sales 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
| 1. START DBR DATE |
Enter the first date to report. Press (RET) to default to today's date. EXAMPLE: Press (RET). |
| 2. END DBR DATE |
Enter the last date to report. Press (RET) to default to today's date. EXAMPLE: Press (RET). Please also refer to points 5 and 6 of the NOTES section above for information pertaining to running this report for a range of dates. |
| 3. CLASS DETAIL |
Enter one of the following values:
EXAMPLE: Type Y (RET) |
|
4 - 12, 15 - 32 |
For each of these fields, enter the status code or codes which represent that particular definition or condition. The program will report the number of vehicles that were in each of these "conditions" during the date range requested. Do not enter into any of these fields the status code "O" (on rent) or the status code defined in the Edit Main Control Record as the status for Non-Rev. These statuses are automatically determined by the program and the associated data put in the appropriate fields. A single status code may only be entered into one of these fields. If a code is entered on more than one line, the following error message will display:
where X is the offending status code. Any status not entered in one of these nine fields will be reported as "Other Status". |
| 13. AVERAGE OPERATIVE FLEET |
Enter the status codes which represent the Average Operating Fleet. The program will report the number of vehicles that were at these statuses during the date range requested. This field is not related to and does not have the restrictions of field 4 - 12 above. Status code "O" and the status code for Non-Rev are allowed in this field. Status codes that were entered in fields 4 - 12 above may also be entered here. |
| 14. PRINTER |
Enter a valid printer name defined in Edit Terminal Records that is capable of handling CSV output. On most systems, this wil be either CSV or EDITOR. |
Each line of the output file will contain 21 data elements as shown below. The first line of the file will contain column header labels as follows:
Location Code
Class Code
Date dd-mm-yy
# Available
# On Rent
# Non-Rev
# Local Repair
# Foreign Repair
# Stolen
# Totaled
# Accident
# Temp Non-Prod
# Perm Non-Prod
# Pending Sale
# Other Status
# Doc Pending
# Damaged on Sale
# Complimentary
# Avg Oper Fleet
Revenue
# Opens
# Days
# Closes
RECONCILING THE DCR DATA
The DCR Export gets the vehicle count data (elements 4 - 16) from the Fleet Summary file. The other report in CARS+ which uses this file is the Fleet Utilization Report. The DCR Export uses the data from Run Type 01. This report, when run for Run Type 01 can be used to reconcile the fleet count data in the DCR file.
NOTE: When this report is run for a range of dates, the fleet counts are for the End DBR Date only, they are not averages for the entire date range.
User Tip: The program that populates the Fleet Summary file is run from the system scheduler. Make sure that Run Type 01 occurs at the time of day that represents the fleet in the desired state for this report. Typically, Run Type 01 is scheduled to occur just after midnight.
The DCR Export gets the Revenue and transaction (Opens, Days, Closes) data from the DBR Summary file. The other report in CARS+ which uses this file is the Daily Operations Report. This report can be used to reconcile the Opens, Days and Closes.
The Revenue Analysis Report can be used to reconcile the revenue data. While the Revenue Analysis Report does not read the DBR Summary file, this report will produce the same revenue data as the DCR Export. Make sure the Revenue Analysis Report is run for " Revenue Items Only" (field 19 = "Y").