Renewal Inventory Report

Click here for a sample Renewal Inventory report

This report shows you how many subscriptions have received each renewal notice. The report is broken down by expire issue and subscription status. Subscriptions with a status of 'AX' (active, cancel at expiration) or 'CX' (canceled at expiration) will have a description of "Do not renew." Active or expired subscriptions that are no longer affected by changes to their renewal series definitions will have a description of "Series ended." The 'Renewal inventory' report is useful if you want to get a snapshot of where your subscribers stand in the renewal process.

Publication

Enter the publication code that Press F2 or right click to select the publication for which you would like to run the report. You must select a publication code in order to run this report.

Report expire issues from ___ to ___

If you leave these two fields blank the report will include all subscriptions for the specified publication. If you enter a range of issue numbers the report will include only those subscriptions that expire within the specified issue range.

Report data file

Enter a file name in this field and QuickFill will create your report and will also generate a data file that contains all of the data that was used to produce that report. This feature is useful if you want to examine the data underlying the report more closely or if you want to present it in formats other than the built-in QuickFill report format. The report data file can be in dBASE (DBF), comma delimited (CSV) or tab delimited (TXT) format. The file name extension that you enter determines the format of the file. The fields in the file are as follows:

ORDERNUM

Order number

PUB

Publication code

RENSERIES

Renewal series

TRACK

Tracking code

ORIGCHAN

Original channel code

EXPISSNUM

Expire issue number

EXPISSDATE

Expire issue date

EXPISSDESC

Expire issue description

STATUS

Status of order

PAID

True if order is paid

EFFSENT

Number of renewal efforts sent

ENDSERIES

True if renewal series has ended

COPIES

Number of copies ordered

 

Click here for more information about Filter screens and Options for running reports.