Click here for a sample Agency Subscriptions report
The 'Agency subscriptions' report provides you with a listing of all subscriptions from one or more subscription agencies and includes the total number of subscriptions for each agency broken down by status. The report lists the name and address of the customer first. To the right of the customer name appears the name of each publication the customer ordered through that agency. You can use this report to reconcile your records against an agency's records.
Agency
Leave this field blank, and your report will include subscriptions placed through all agencies. Enter a subscription agency into this field, and your report will include subscriptions placed through that agency only. To enter an agency code into this field, right click to display a list of defined agency codes and then select the code on which you would like to report.
Publications
You may enter one or more publication codes in the 'Pubs' fields to select agency subscriptions for specific publications. Leave these fields blank, and QuickFill will show all subscriptions placed through the specified agencies. To enter a publication either type its code directly into the field or right click to select a code from a list of the publication codes defined in your database.
Status
The status fields modify the publication code field immediately to their left. Use these fields to select only subscriptions with a particular status. Note that you can select certain commonly needed groups of statuses. For example, 'C*' will select all expired or canceled subscriptions.
You can also use the status fields without specifying a publication. In this case, you will select all subscriptions with that status, regardless of the publication with which they are associated. To enter a status(s) either type the status code directly into the field or right click to display a list of codes from which to choose.
Order date
You may enter an order date range in this field to obtain agency information for a specific date range. Filtering by order date allows you to produce time/volume reports by agency.
Amount due
Enter a dollar range in the 'Amount due' field to produce a report on agencies that have outstanding balances.
Click here for more information about Filter screens and Options for running reports.