Route Delivery List

The Route Delivery List is a definitive list of subscribers on a particular route. It can be used in a variety of situations—for example, when a new carrier begins delivering a route. If a TM product is delivered with the publication (see Deliverable in the Setup Manual), occupants receiving the TM product may also be listed. Route Lists can be generated here; they can also be set up to print on bundle tops.

To produce the list:

• Select Route Delivery List from the Route menu to display the Route Delivery List Report window.

  
• Click Add and complete the following fields.

  Field	Type	What to enter
  PRODUCT	setup	Enter the publication for which to generate the delivery list.
  REPORT DATE	date	Enter the date for which to generate the delivery list. If a past publishing date is entered, subscribers will be listed as of that date, but only “active” and “active or additional product” subscriber types can be entered in the next field. See the note about input files below.
  INCLUDE PENDING	yes/no	Indicate whether pending (unprocessed) starts, stops, moves, and other subscriber transactions should be taken into account. For example, if the Route Delivery List is being run for the future date of 8/7, and there is an unprocessed new start for 8/7, the subscriber will be listed if you select this checkbox.
  SHOW BONUS DAY	yes/no	The report can include bonus day subscribers (subscribers that will receive the paper even if it is not a normal delivery day for them). Enter yes if both bonus day and regular subscribers should appear, enter no if only regular subscribers should appear, and enter only if only bonus day subscribers should appear.
  SUBSCRIBER TYPE	predefined	Enter the type subscriber that should appear on the delivery list. Choices are active subscribers, active or additional product, inactive subscribers, all subscribers, all households, and non-subscribers. An inactive subscriber is a temporarily stopped subscriber. A non-subscriber is an occupant with no subscription history. If “active or additional product” is selected, occupants receiving a TM product being delivered with this publication will also be listed. If “all households” is selected, Billing Method, Delivery Schedule, and Delivery Day are skipped.
  REASSIGNED ROUTES	yes/no	Indicate whether to include subscribers whose subscription route is different from their address route (see Rerouting for a discussion of subscription routes versus address routes).
  INCLUDE ADDITIONAL PRODUCTS	yes/no	A TM product or another publication may be set up to print with this publication’s route list (see Deliverable in the Setup Manual). In this case the route list would include both the subscribers for this publication and the TM addresses or subscribers for the other publication. Indicate whether additional products should be included in the route delivery list.
  INCLUDE NON-DELIVERY DAYS	yes/no	Indicate whether you want to include a subscriber’s additional products that are not delivered on the selected report date.
  ADDITIONAL PRODUCT	setup	TM products and other publications can be set up to “always” print with this publication, or to “ask”. If they are set to “ask”, you must enter the product in this field. Enter “*” to multi-select products.
  PRINT ORDER	predefined	Indicate whether the report should be printed in order of address, carrier delivery sequence, or postal route.
  BILLING METHOD	predefined	Specify the billing method to include in the report. Choices are office pay, carrier collect, paid complimentary, unpaid complimentary, or * (to multi-select billing methods).
  PRINT RATE CODE	yes/no	Indicate whether rate codes should appear on the Route Delivery List for subscribers that have rates (i.e., office pay subscribers). Because this is the subscriber’s current rate, this field is available only if running the report for a current or future publishing date.
  DELIVERY SCHEDULE	setup	Specify the delivery schedule to include in the report or enter “*” to multi-select delivery schedules. You can leave this field blank if you want to run the report for a specific day.
  DELIVERY DAY	predefined	If you left Delivery Schedule blank, specify the day of the week to cover in the report.
  SELECTION TYPE	predefined	Indicate whether routes to be included in the report should be selected by area, region, zone, district, or route.
  PRINT ALL	yes/no	Indicate whether all routes for the publication should be included in the report.
  SELECTION	setup	If you entered “n” in Print All, specify the area, region, zone, district, or route to include in the report (based on what was entered in Selection Type). Enter “*” to multi-select areas, regions or zones. In the case of districts and routes, there is no multi-select. However, you can enter “*” or click the Find icon to the right of this field to add districts or routes one at a time in a separate maintenance window.
  REPORT TYPE	predefined	Indicate whether a standard Delivery List or Throwoff List should print. The Throwoff List is a condensed version of the Delivery List, showing only the address, name, delivery schedule, number of copies and (optionally) delivery instructions for subscribers on a given route; it is only available when running the report for active subscribers. You may also choose to Export the Route Delivery List in the standard format or a file-mapped format. If exporting, totals for the Route Delivery List will still be displayed in the window.
  USE FILE MAP	yes/no	If exporting data, indicate if you are using a file map that has a usage of “RouteData”.
  FILE FORMAT	setup	In FILE FORMAT, identify the file map you will use (must be set up in advance). If you are interfacing route data to RouteSmart, select the “RouteSmart” format here.
  EXPORT FILE	open (14)	If Report Type is “export”, enter the name of the ASCII file that should be created by the export. The format for the file is given in Appendix B.
  SPACING	predefined	Indicate whether the spacing should be single or double.
  PRINT DELIVERY INSTRUCTIONS	yes/no	Indicate whether to include delivery instructions in the report.
  PRINT TRUCK	yes/no	Indicate whether to include the truck, truck name, and supplying truck ID in delivery list.
  ADDITIONAL REPORTS BY ROUTE	yes/no	Indicate whether to create a separate file for each route, as well as the full route delivery list. If you select this checkbox, a separate file will be created for each route, with the product ID and route ID appended to the file name entered in View/Print. If you do not select this checkbox, only the full route delivery list will be produced.

• Click OK and then Continue to produce the report.

A Note About Input Files and Date Parameters

If you intend to use an input file with a date parameter for the Route Delivery List, you must follow a specific procedure when building the input file to prevent certain date-related validation issues.

To build an input file using a date parameter:

1. Select the Route Delivery List option from the menu.

2. Click Add and select the Product.

3. In the Report Date field, press Ctrl-P to display the input parameter dialog box.

4. Enter the Parameter Name (e.g., TODAY + 1) and click OK.

   
5. Back in the Report Date field, enter a date that is many years into the future (e.g., 01/01/2050).

6. Complete the rest of the fields on the window as appropriate and click OK.

7. Click Save, enter a name for the input file, and click OK. The input file is now saved and can be used the next time you run the Route Delivery List.

8. On the Route Delivery List Report window, click Cancel.

To use the input file:

1. Select the Route Delivery List option from the menu.

2. Click Find, enter the input file name, and click OK.

Example—Route Delivery List