The report can include both posted and unposted RAs, or it can be limited to only posted RAs.
NOTE: For CARS+ installations using the Customer Salesman logic and who have GVT record “CUSSLM” set up, this report is limited to those RAs which have a bill-to party or third party matching a record in the Customer Salesman file, and the RA open date falls within the effective date range for the salesperson(s) requested. Refer to the chapter of this manual titled Edit Customer Salesman Number for more information on the Customer Salesman logic.
To access the
Salesman Revenue Report, type SALESRPT (RET) at any menu "OPTION:" field or the appropriate line number on the Corporate Accounts submenu of the Customer
Maintenance Menu. The screen will
then display:
| OPTION: __ SALESMAN REVENUE REPORT 1 Start Date 08-01-16 2 End Date 08-31-16 3 Location ALL 4 Start CDPID FIRST 5 End CDPID LAST 6 Sales Territory ALL 7 Start Market Segment FIRST 8 End Market Segment LAST 9 Start Employee FIRST 10 End Employee LAST 11 Sort Order 2 (1=CDPID#, 4=Open Loc/CDPID# ) 2=Salesman/CDPID#, 5=Market Segment/CDPID#) 3=Territory/Salesman/CDPID# ) 12 Posted Only Y 13 Detail/Summary D 14 Page Breaks N 15 Print/Display/CSV P prtspool 1SAVE 2 3 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. START DATE |
Using your selected date format, enter the Starting date. Press (RET) to default to the first day of the previous month. The date range enter in Fields 1 and 2 refers to the closing DBR date. EXAMPLE: Press (RET) |
|
2. END DATE |
Using your selected date format, enter the Ending date. Press (RET) to default to the last day of the previous month. 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: Press (RET) |
|
3. LOCATION |
Enter:
EXAMPLE: Type TUS (RET) |
|
4. START CDPID |
Enter up to 10 alphanumeric characters to indicate a starting range of Corporate Discount ID numbers or press (RET) to default to FIRST. EXAMPLE: Type 1234567890 (RET) User tips: Traditionally, CDPID numbers are assigned to corporate accounts. They may also be assigned to Vendor records. In some cases, both the renter on a RA and the vendor may have CDPID numbers. This report uses the renter's CDPID number when selecting RAs. If you would prefer to have the report reference the Vendor's CDPID number instead, ask Thermeon's Customer Support Dept. to set up GVT record "VENDCDP". |
|
5. END CDPID |
Enter up to 10 alphanumeric characters to indicate an ending range of Corporate Discount ID numbers or press (RET) to default to LAST. EXAMPLE: Type 1234567890 (RET) |
|
6. SALES TERRITORY |
Enter up to 3 alphanumeric characters to indicate a specific Sales Territory or press (RET) to default to ALL. (Sales Territories are user defined and can be entered on each Salesman's Record.) These are user defined. Note: If a specific Territory is entered in this field, the report must be run for "ALL" salesmen. See Fields 9 and 10. EXAMPLE: Type CAL (RET) |
|
7. START MARKET SEGMENT |
A field in Edit Corporate Account Record can be used to define a category or market segment for that account record. Examples are 'COR' for corporate, 'GOV' for government, or 'LEI' for leisure. Enter up to 3 alphanumeric characters to indicate a beginning range of Market Segments. Or, press (RET) to default to the FIRST Market Segment. EXAMPLE: Type COR (RET) |
|
8. END MARKET SEGMENT |
Enter up to 3 alphanumeric characters to indicate an ending range of Market Segments. Or, press (RET)to default to the LAST Market Segment. EXAMPLE: Type COR (RET) |
|
9. START EMPLOYEE |
Enter up to 6 alphanumeric characters to indicate the first Employee Code of an individual sales person to be reported or press (RET)to default to the FIRST one. Codes entered here must already exist in the User Access File File. EXAMPLE: Press (RET) Note: If a specific Territory is entered in Field 6, the report must be run for "ALL" salesmen. A change from the defaults is not allowed in the Salesman fields. NOTE: For CARS+ installations using the Customer Salesman logic and who have GVT record “CUSSLM” set up, this field and the next accepts code from the Customer Salesman file. Refer to the chapter of this manual titled Edit Customer Salesman Number for more information on the Customer Salesman logic. |
|
10. END EMPLOYEE |
Enter up to 6 alphanumeric characters to indicate the last Employee Code of an individual sales person to be reported or press (RET)to default to the LAST one. Codes entered here must already exist in the User Access File. EXAMPLE: Press (RET) Note: If a specific Territory is entered in Field 6, the report will be run for "ALL" salesmen. A change from the defaults is not allowed in the Salesman fields. |
|
11. SORT ORDER |
Enter one alpha character to select the sequence in which you wish to have the data listed. The accepted values for this field are:
EXAMPLE: Type 2 (RET) User Tip: When sorted by choices 1, 4, or 5, a final sort is provided for all RAs within the requested parameters that do not have a CDPID number with a salesman code. |
| 12. POSTED ONLY |
Enter:Y = Yes, include only posted RAs in the report.EXAMPLE: Type N (RET) |
|
13. DETAIL/ SUMMARY |
Enter one alpha character to select the report format.
EXAMPLE: Type D (RET) |
|
14. PAGE BREAKS |
This field determines whether or not there should be a page break between primary sorts. In other words, if the sort criteria chosen in Field 11 was "2" (Salesman, then by CDPID number) a new page (page break) would be used to begin each salesman's part of the report.
EXAMPLE: Type N (RET) |
|
15. PRINT/ DISPLAY/CSV |
Enter:
EXAMPLE: Type P (RET) |
The screen will then display:
| OPTION: __ SALESMAN REVENUE REPORT 1 Start Date 08-01-16 2 End Date 08-31-16 3 Location TUS 4 Start CDPID 1234567890 5 End CDPID 1234567890 6 Sales Territory CAL 7 Start Market Segment COR 8 End Market Segment COR 9 Start Employee FIRST 10 End Employee LAST 11 Sort Order 2 (1=CDPID#, 4=Open Loc/CDPID# ) 2=Salesman/CDPID#, 5=Market Segment/CDPID#) 3=Territory/Salesman/CDPID# ) 12 Detail/Summary D 13 Page Breaks N 14 Print/Display/CSV P 1SAVE 2 3 4 5BACKUP 6 7HELP 8 |
PRESS "F1" AT THE "OPTION" TO BEGIN PRINTING.
Notes about the columns:
T&K Revenue = Time and Mileage/Km Revenue.
There are no extractions made on RAs with inclusive rates. As an example, assume there is a 1-day rental with an inclusive rate of $80 (LDW $20.00; Time $60). The full rate of $80 will be shown in the T&K column. The LDW column will be blank. Total Revenue will be $80. The computation for “Avg Daily Earning” will be based on $80.
Discounts are deducted from T&K.
LDW Rev = LDW Revenue.
If LDW was part of an inclusive rate, it is ignored and not shown in this column. It is included in the T&K Revenue column
Total Rev = Total amount of the RA including taxes and fees.
This report contains a calculation of rental length called "DBR Days" (or just "Days"). One of two possible formulas are used in CARS+ to calculate this figure. To chose the formula to be used in this as well as over fifty other CARS+ reports, go to Page 5, Field 3 of Edit Miscellaneous Control Fields.
Avg. Dly Earning = The average revenue per day. This calculation is the result of dividing the 'revenue' by the Rental Days. The 'revenue' is defined by a setting in the Edit Misc Control Fields (page 2, Field 30: Include in T&M on DBR). The field has 4 settings that are interpreted as follows:
Edit Misc
Page 2
Field 30Revenue includes Blank Time and Mileage/Kms less discount 1 Time and Mileage/Kms less discount plus "L" type options (such as LDW) 2 Time and Mileage/Kms less discount plus "L" type options and "C" type options (coverages) 3 Time and Mileage/Kms less discount plus "L" type options, "C" type options, and "O" type options.
Notes on Running the
Salesman Revenue Report
This report is intended to be used by management to
track sales.
Monthly goals can be entered in the Corporate Account record and/or the User’s Access File record. These goals are shown on the report.
A few examples of how to generate different types of reports are given below. Those fields that have been changed from the defaults are shown in red.
Example 1: Report of closed RAs for Salesman JDA's accounts during August,
sorted by CDPID.
| OPTION: __ SALESMAN REVENUE REPORT 1 Start Date 08-01-16 2 End Date 08-31-16 3 Location ALL 4 Start CDPID FIRST 5 End CDPID LAST 6 Sales Territory ALL 7 Start Market Segment FIRST 8 End Market Segment LAST 9 Start Employee JDA 10 End Employee JDA 11 Sort Order 1 (1=CDPID#, 4=Open Loc/CDPID# ) 2=Salesman/CDPID#, 5=Market Segment/CDPID#) 3=Territory/Salesman/CDPID# ) 12 Detail/Summary D 13 Page Breaks N 14 Print/Display/CSV P 1SAVE 2 3 4 5BACKUP 6 7HELP 8 |
Example 2: Report of all rentals year to date for
CDPID number 456789001, sorted by opening location.
| OPTION: __ SALESMAN REVENUE REPORT 1 Start Date 01-01-16 2 End Date 08-31-16 3 Location ALL 4 Start CDPID 456789001 5 End CDPID 456789001 6 Sales Territory ALL 7 Start Market Segment FIRST 8 End Market Segment LAST 9 Start Employee ALL 10 End Employee ALL 11 Sort Order 4 (1=CDPID#, 4=Open Loc/CDPID# ) 2=Salesman/CDPID#, 5=Market Segment/CDPID#) 3=Territory/Salesman/CDPID# ) 12 Detail/Summary D 13 Page Breaks N 14 Print/Display/CSV P 1SAVE 2 3 4 5BACKUP 6 7HELP 8 |
| OPTION: __ SALESMAN REVENUE REPORT 1 Start Date 08-01-16 2 End Date 08-31-16 3 Location TUS 4 Start CDPID FIRST 5 End CDPID LAST 6 Sales Territory ALL 7 Start Market Segment FIRST 8 End Market Segment LAST 9 Start Employee FIRST 10 End Employee LAST 11 Sort Order 5 (1=CDPID#, 4=Open Loc/CDPID# ) 2=Salesman/CDPID#, 5=Market Segment/CDPID#) 3=Territory/Salesman/CDPID# ) 12 Detail/Summary D 13 Page Breaks N 14 Print/Display/CSV P 1SAVE 2 3 4 5BACKUP 6 7HELP 8 |