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.