Use this program to:

To access the program, type DBRPT (RET) at any menu "OPTION:" field or the appropriate number on the Additional Accounting Programs sub-menu of the Rental Accounting Menu. The screen will then display:

OPTION: DIRECT BILL REPORT

1 Location ALL
2 Start DBR Date 06-01-08
3 End DBR Date 06-19-08
4 Open/Close 1 (1=Closed RAs Only 2=Open RAs Only 3=Both)
5 Starting Bill-to # FIRST
6 Ending Bill-to # LAST
7 Print/Display P Printer: /dev/tty



1PRINT 2 3ERASE 4 5 6 7HELP 8

Enter data as follows:

1. LOCATION

For the location, enter

  1. Up to 6 alphanumeric characters to select a single location.
  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

Press RETURN to accept the default location.

EXAMPLE: Type TUS (RET)

2. START DBR DATE

Using the selected date format, enter the starting date for the DBR date range. Press (RET) to accept the default which is the first day of the current month.

EXAMPLE: Type 060108 (RET)

3. END DBR DATE

Using the selected date format, enter the ending date for the DBR date range. Press (RET) to accept the default of the current date.

EXAMPLE: Type 061508 (RET)

4. OPEN/ CLOSE

Enter:

1 = Closed RAs only will be selected

2 = Open RAs only will be selected

3 = Both open and closed RAs will be selected

EXAMPLE: Type 1 (RET)

5. STARTING BILL TO #

To limit the report to a range of bill-to customers, enter up to 6 alphanumeric characters to indicate the beginning customer number. Press (RET) to start with the FIRST bill-to customer.

EXAMPLE: Type ABC01 (RET)

6. ENDING BILL TO #

To limit the report a range of bill-to customers, enter up to 6 alphanumeric characters to indicate the ending customer number. Press (RET) to end with the LAST bill-to customer.

EXAMPLE: Type ABC88 (RET)

7. PRINT/
DISPLAY

Enter:

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

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

EXAMPLE: Type P (RET)

The screen will then display:

OPTION: DIRECT BILL REPORT

1 Location TUS
2 Start DBR Date 06-01-08
3 End DBR Date 06-15-08
4 Open/Close 1 (1=Closed RAs Only 2=Open RAs Only 3=Both)
5 Starting Bill-to # ABC01
6 Ending Bill-to # ABC88
7 Print/Display P



1PRINT 2 3ERASE 4 5 6 7HELP 8

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

Notes about the report:

  1. RAs are sorted using the bill-to customer number.
  2. Then RAs are listed numerically by RA number within each customer.
  3. The exception is multi-month rentals; which appear with an asterisk appended to the RA number and are listed in the order in which they were opened.
  4. The revenue reported in the three revenue columns (see below) is affected by the "Report As Revenue" field in the Edit Optional Items file. Revenue will be reported only for those options where this field is set to "Y". Revenue from options where this field is either blank or "N" will not be included.

The follow data prints for each RA listed:

Multi-month indicator (*)

RA #

Renter's last name

Status

Open Date

Close or Return Date (close date for closed RAs; return date for open RAs)

Billing cycle days if a multi-month RA

Length of rental

Total charges

Total revenue (discounted Time and Mile plus any option defined to report as revenue)

Revenue per day (total revenue divided by length of rental)

Revenue per transaction prints only when ALL customers are requested.

On the subtotal line, the Customer number, name, and total number of RAs are shown.