B. ACCESSING
AND RUNNING THE DBR REVENUE EXPORT PROGRAM
This report may be configured to run automatically from the CARS+ Report Driver. Users interested in this feature should contact Thermeon's Customer Support Dept. for further information.
In order to get the CSV file, enter a printer name that causes the output to be opened or saved as a file. For most users, the value of CSV or EDITOR 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.
To access the DBR Revenue Export program, type DBREXP (RET) at any menu "OPTION:" field or the appropriate line number on the Export Data Menu. The screen will then display:
| OPTION: __ DBR REVENUE EXPORT 1 Start Date 11-16-16 2 Start Time 0000 3 End Date 11-16-16 4 End Time 2359 5 Location ALL 6 RA Post Value B (Y=posted, N=Unposted, B=both) 7 RAs B (O=owned, F=foreign, B=both) 8 Vehicles B (O=owned, F=foreign, B=both) 9 Extract Inclusive N 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. START DATE |
Using your selected date format, enter the Starting DBR Date. Press RET to default to today's date. EXAMPLE: Type 111516 (RET) |
||||||||||||||||||
|
2. START TIME |
Using your selected time format, enter the Starting DBR Time. Press RET to default to midnight. EXAMPLE: Press (RET) |
||||||||||||||||||
|
3. END DATE |
Using your selected date format, enter the Ending DBR Date. Press RET to default to today's date. Note: The size of the date range you can enter may be restricted by your system access level (see the Chapter on the program, Edit User Access). If you enter a date range that is larger than what is allowed for your account, the following message will appear at the bottom of the screen when you attempt to press F1 to start the report:
EXAMPLE: Type 111516 (RET) |
||||||||||||||||||
|
4. END TIME |
Using your selected time format, enter the Ending DBR Time. Press RET to default to 11:59PM. EXAMPLE: Press (RET) Records will be selected as follows:
|
||||||||||||||||||
|
5. LOCATION |
Enter:
If you plan to post transactions (Field 10 = "Y") in this run, you WILL be blocked if you have entered either a Location Group or ALL in this field and:
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:
EXAMPLE: Type TUS (RET) User tip: When a Location Group is entered in this field, the order in which the locations are processed are: individual locations (in alphabetical order) are listed first, then the groups are processed in alphabetical order, and then the locations within each group in alphabetical order. |
||||||||||||||||||
|
6. RA POST VALUE |
Enter 1 alpha character to select the records to be included.
EXAMPLE: Type Y (RET) |
||||||||||||||||||
|
FIELDS 7 & 8 |
Rental operations which are part of a national franchising organization are faced with several types of rental situations. These situations are summarized in the chart below:
Fields 7 and 8 allow you to select which of the four types of rentals listed above will be reported in the Closed RAs section of the DBR. As a result, this also determines which RAs are included in the revenue averages and other statistics. |
||||||||||||||||||
|
7. RAs |
Enter:
EXAMPLE: Type B (RET) |
||||||||||||||||||
|
8. VEHICLES |
Enter:
EXAMPLE: Type B (RET) Obviously, the combination of responses to Fields 14 and 15 will produce several different kinds of reports.For example:
|
||||||||||||||||||
| 9. EXTRACT INCLUSIVE |
This field allows inclusive items to be extracted from Time revenue. Enter:
EXAMPLE: Type N (RET) |
PRESS "F1" AT "OPTION:" TO BEGIN PRINTING.
C. DATA IN THE EXPORT
The following data will appear in the file for each RA that would appear on a similarly run accounting DBR:
RA#
DBR Date
Vehicle Class
Vehicle Number
Rate Code
Rate description
Renter's Customer #
Renter's Last name
Bill-to Customer #
Bill-to Last Name
Open Location
Open Date
Close Location (added as of release v15.3.0)
Close Date
Charges (one field for each option charge, listed in alphabetical order - RAs without a spefic charge will have no value for that option ",,")
Note: Revenue from both in voucher and out of voucher charges will be totaled together.
When imported into a spreadsheet program, the data will be arranged as follows:
RA#
DBR Date
Vehicle Class
Vehicle Number
Rate Code
Rate description
Renter's Customer #
Renter's Last name
Bill-to Customer #
Bill-to Last Name
Open Location
Open Date
Close Date
Charges:
Time
Miles/Kms
Upsell
Cust Service Adjustments
Discount
Promo
Service Adjustments
Column for each coverage
Fuel
Drop
Each option charge, listed in alphabetical order
Each tax type option
Each miscellaneous charge type option
Final column Gross Revenue