Extend Expire Dates

This utility extends active non-combo subscriptions by route for a user-defined number of days. Subscriptions can be extended by route selection or by importing a flat file containing specific Subscription IDs and the number of days to extend.

circle-info

Note: Extend Expire Dates will not update the wallet when Advance Bill Premium Days are used.

To run this utility:

  1. Select Extend Expire Dates from the Utilities | Subscription/Address menu in Graphical Utilities to display the Extend Expire Dates screen.

  2. Select Add and complete the following fields.

    Field
    Type
    What to enter

    USE IMPORT FILE

    yes/no

    Select this option to extend expire dates using an import file rather than route selection. When selected, the File Name field becomes available.

    FILE NAME

    open

    Enter the name of the file to import.

    The file must contain only two types of data per record: the Subscription ID and the number of days to extend, separated by a pipe delimiter. For example: SubscriptionID | Days to extend.

    Any additional data in the import file will result in an error.

    PRODUCT

    setup

    Select the product for which to update expire dates. Only one product can be entered.

    SOURCE

    setup

    Select a source code for these expire change transactions.

    REASON

    setup

    Select a reason for these expire change transactions.

    DAYS TO EXTEND

    integer (3)

    Enter the number of days to extend expire dates (must be a positive integer).

    ALL ROUTES ROUTE

    yes/no setup

    Check All Routes to change delivery schedules for all routes, or enter one or more specific routes. If you click the Lookup icon to the right of the Route field, the Route List Maintenance screen will appear. Select Add and enter and individual route, then click OK. Click OK when you have finished and the window will close.

    ALL DELIVERY DAYS

    yes/no

    If you want to extend the expire date for subscribers who received a paper on a specific publishing date, leave All Delivery Days unchecked, and the publishing date in the Delivery Date date field. For example, if the expire date should be extended for everyone who received a paper on 11/30/2009, enter “11/30/2009”.

    DELIVERY DATE

    date

    Otherwise, check All Delivery Days to include all subscribers who meet the remaining criteria. Delivery Date will be skipped.

    ALL SCHEDULES

    yes/no

    If you want to extend the expire date for subscribers on a specific delivery schedule, leave All Schedules unchecked, and select the delivery schedule in the Schedule field.

    SCHEDULE

    date

    Otherwise, check All Schedules to include subscribers on all delivery schedules.

    UPDATE

    yes/no

    If you check this field, expire change transactions will be created. Leave the field unchecked to produce only a report (transactions will not be created).

    REMARKS

    open (40)

    This field is optional, and defaults to “DTIExpireDateExtend”. Remarks are stored with the ExpireChg transaction.

  3. Select OK and then Continue to update the expire dates.

Last updated