Generalized Bill Notices Report

•

The Generalized Bill Notices (Bill) report produces bill notices, which can be sorted by group ID, user name, user ID, or zip code. The report lists both paid and unpaid bills, unless No is selected for the Bills Paid in Full option. By default, the Bills Paid in Full option is set to No. Each bill is itemized, but you must select the Total Bills for Each User check box on the Bill Notice tab to include a bill total.

When the library address is included in a notice, the address is drawn from the user record with a user ID which matches the User ID attribute of the appropriate Library policy.

This report contains the following tabs.

•

Basic Tab: Reports

•

Bill Notice Tab

•

Bill Selection Tab

•

Produce Mailing Labels Tab

•

Sorting Tab

•

User Accountability Selection Tab

•

User Selection Tab

•

User Status Selection Tab

•

Print Separate Reports for Each Library Tab

The text of the notices that are available for printing can be defined by your library. Use the Notices Helper on the Bill Notice tab to modify notice text.

Pipe-delimited Output

If Generate Pipe Delimited Output is selected on the Charge Notice tab, the report creates a pipe-delimited file and places it in the /Rptprint directory with the naming convention of yyyymmdd_internalrptname.pipe. The report log lists the pipe-delimited report file name. This pipe-delimited file can be opened using a third-party application, such as a spreadsheet application.

Sorting selections made within the report are not applied to pipe-delimited files. For example, if you sort the report by zip code, the zip code sort is not applied to the contents of the pipe-delimited file.

The entries listed in the Brief Entries attribute of the User Address Format wizards are used to supply information for the address fields in the pipe-delimited file. The City/State field (if it is used) is evaluated as one field, not as two separate fields for the city and the state. The report will check user records for the fields listed in the Brief Entries attribute and print only the populated fields in the pipe-delimited output.

Pipe-delimited Key File

The pipe-delimited key file defines each field of the pipe-delimited file for a particular notice.

The following pipe-delimited key file defines the fields for a bill notice.

The following example shows a pipe-delimited key file for a bill notice, and the notice output that is produced from the file.

|Friday, May 12, 2006|Rockerfeller Public Library|123 Main St.|
|St. Louis, MO|35801|Tom Patron|1234 Fair Oaks Lane||St Louis, MO|55555|
Dear Tom Patron,|”FIRST BILL” We are taking the liberty of calling your
attention to the fact that you owe the Library some money for the
following bill. Please pay this bill at your earliest convenience.
Thank you.
|Adventures of Huckleberry Finn : Tom Sawyer’s comrade / Mark Twain ;
edited by Walter Blair and Victor Fischer.|Twain, Mark,
1835-1910.|5/12/2006|PROCESSFEE|$5.00|Adventures of Huckleberry Finn :
Tom Sawyer’s comrade / Mark Twain ; edited by Walter Blair andVictor
Fischer.|Twain, Mark, 1835-1910.|5/12/2006|OVERDUE|$.70|$5.70||

Friday, May 12, 2006

Rockerfeller Public Library
123 Main St.
St. Louis, MO
35801
Tom Patron
1234 Fair Oaks Lane
St Louis, MO
55555

Dear Tom Patron,
”FIRST BILL”
We are taking the liberty of calling your attention to the fact
that you owe the Library some money for the following bill.
Please pay this bill at your earliest convenience.
Thank you.
1 Adventures of Huckleberry Finn : Tom Sawyer’s comrade / Mark Twain ;
edited by Walter Blair and Victor Fischer.
Twain, Mark, 1835-1910.
date billed:5/12/2006 bill reason:PROCESSFEE amount due: $5.00

2 Adventures of Huckleberry Finn : Tom Sawyer’s comrade / Mark Twain ;
edited by Walter Blair and Victor Fischer.
Twain, Mark, 1835-1910.
date billed:5/12/2006 bill reason:OVERDUE amount due: $.70

=======================================================================

TOTAL FINES/FEES AND UNPAID BILLS: $5.70