Skip to main content
OCLC Support

Borrower circulation auto update

Learn how to create and print Borrower Circulation Update reports in Amlib.

The Borrower Circulation Automatic Update (&BORCUPD.QRP) template was created for the purpose of automatically changing the status of borrowers based on the inclusion of due date parameters in the Where statement of the report. The application of this would be to change borrowers with overdues past a certain due date to a SUSPENDED status. This report can only be used with borrowers who have items on loan.

To set up the process correctly, the following reports would need to be scheduled in this order:

  1. Borrower Automatic Update (&BORUPD.QRP) to set all borrowers with a SUSPENDED status back to a status of OK
  2. Borrower Circulation Automatic Update (&BORCUPD.QRP) to set all borrowers with the given due date parameters to a SUSPENDED status

In the event that any borrowers with a SUSPENDED status return or pay for all their overdues, the scheduling of the reports in this way ensures that those borrowers will be re-instated to a status of OK. The running of the Borrower Circulation Automatic Update then re-calculates which borrowers still fit the criteria for suspension, so that these borrowers still have their SUSPENDED status.

 Note: When the Borrower Circulation Automatic Update report is run, a borrower file is also created which contains all the records for borrowers that have had their status changed.

Set up the reports

Create the borrower automatic update report

  1. Click the F1 New button – the Select Report Format screen will display.
  2. Highlight the Borrower Automatic Update (&BORUPD.QRP) and click the Select button.
  3. Type in a Description – for example: Borrower Update – Clear Suspensions.
  4. Ensure the Update Entity (Y/N) column = Y
  5. Click the F3 Save button when complete.
    clipboard_efd552712d1884f320d54fc322283976d.png
  6. Highlight the report and click the F7 Where button – the Borrower Reports – Where screen will display.
  7. Enter the Borrower Status to be checked (and cleared) – for example: BorStatus = SUSP.
  8. Click the F3 Update button when complete.
    clipboard_e9bdbf0dd438496acb3eb6386282c2edc.png

F10 More

  1. Click the F10 More button – the More screen will display.
  2. Click the F1 New or F2 Insert button.
  3. Enter the following parameters:
    • Report Line Number = 1
    • Column = S (for Status)
    • New Value = OK (for Unrestricted)
    • Send Memo = D (this will delete the memo if it no longer applies)
    • Address 3 = <leave blank>

clipboard_ee4e3a427334cc59271b81eb9f503da48.png

  Column 1 Column 2 Column 3 Column 4 Column 5
Heading Report Line Number Column New Value Send Memo Address 3
Example 1 S OK D <leave blank>
Comment Line 1 is used for updates Borrower field - can be Borrower Types (T), Classes (C), Groups (G) or Status (S) The new value - must be a valid code for the selected column If D, will delete if it no longer applies - otherwise set to N to leave in place  

The Column is set to S in order to change the Status. The new value is the normal OK status you would have your borrowers default to – this will depend on the settings you have in the Borrower Status Codes screen (Main > Borrowers > Borrower – Application > Borrower Status):

clipboard_e85ad93a68175bb56739e044900640827.png

  1. Click the F3 Save button when complete.

Create the Borrower Circulation Automatic Update report

  1. Launch the Amlib client.
  2. Ensure that the borrower circulation update template is correctly set in Main > Reports > RepAddNew – Entity = Borrower:
    • Report Type = Borrower Circulation Automatic Update
    • File Name = &BORCUPD.QRP (not to be confused with &BORUPD.QRP)
      clipboard_e444a1782f7a69426fab2a555f4df198f.png
  3. Go to Main > Reports > RepBorrower – the Borrower Reports screen will display.
  4. Click the F1 New button – the Select Report Format screen will display.
  5. Highlight the Borrower Circulation Automatic Update (&BORCUPD.QRP) and click the Select button.
  6. Type in a Description – for example: Borrower Update – Auto Suspension.
  7. Ensure the Update Entity (Y/N) column = Y
  8. Click the F3 Save button when complete.
    clipboard_e55dd4c93a18f7abdebe3025e0efd23c7.png
  9. Highlight the report and click the F7 Where button – the Borrower Reports – Where screen will display
  10. Set the due date parameter based on your criteria for suspension of borrowers. You may also choose to include parameters if you wish to exclude certain borrowers (for example: housebound borrower type or specific location).
  11. Click the F3 Update button when complete.
    clipboard_e39d0ee68afa0107f7b770126429f8e63.png

F10 More

  1. Click the F10 More button – the More screen will display.
  2. Click the F1 New or F2 Insert button.
  3. Enter the following parameters:
    • Report Line Number = 1
    • Column = S (for Status)
    • New Value = SUSP (for Suspended)
    • Send Memo = Y

clipboard_ea9418b5e4f47d81da815346ced58ce98.png

  Column 1 Column 2 Column 3 Column 4 Column 5
Heading Report Line Number Column New Value Send Memo not used
Example 1 S SUSP Y <leave blank>
Comment Line 1 is used for updates Borrower field - can be Borrower Types (T), Classes (C), Groups (G), or Status (S) The new value - must be a valid code for the selected column If Y, create the memo in Text for Letter, found at the top of the Borrower Reports screen  

The column is set to S in order to change the Status. The new value is the status you are changing your borrowers to – this will depend on the settings you have in the Borrower Status Codes screen (Main > Borrowers > Borrower – Application > Borrower Status):

clipboard_ea14e1f3552e03e1c5789f1ee0e994f09.png

The Send Memo can be set to either Y or N. If set to Y, the memo will be attached to each borrower’s record as a borrower memo.

  1. Click the F3 Save button when complete.

Memo

If you set the Send Memo column to be Y in the F10 More screen you will need to fill in the content of your memo.

  1. Highlight your report and click the Text for Letter button – the Letter Text screen will display.
    clipboard_ede06323ab132b2b77b751b8db83d53e9.png
  2. Enter the memo text – for example: The borrower is suspended until all overdues are returned or the replacement costs paid.
    clipboard_ed7cdc777de874a09d19ecdef48e62e8b.png
  3. Click the F3 Save button when complete and click on the red [X] to close the window.

Print report (via Scheduler)

Borrower update reports must be run via the Scheduler.

Start the scheduler

  1. From the Reports screen, select Application > RepStartSchedule
    clipboard_e9f0343725fb983d95000c2ea4d71774f.png
  2. The Report Scheduler screen will display.
  3. Select your printing options: ensure Save to File is ticked (you can tick all three if you intend on printing up multiple reports using multiple formats during a session).
    clipboard_ef60e4db47cbb6140345daeebde84fade.png
  4. Then click the OK button.
  5. After clicking OK, if you go back into the Application menu you will see that RepStartSchedule is now greyed out with a tick next to it – this indicates that the Scheduler is now running.
    clipboard_e25fce5f6808bd1fe7cf11252de038fc8.png

Scheduling the report

IMPORTANT! In order to ensure that only those borrowers with outstanding items are/remain suspended, the reports MUST be run in the following order:

  1. Borrower Automatic Update (&BORUPD.QRP) to set all borrowers with a SUSPENDED status back to OK.
  2. Borrower Automatic Circulation Update (&BORCUPD.QRP) to set all borrowers with the given due date parameters to a SUSPENDED status.

The reports can be run manually run or scheduled to run daily/weekly (as long as they are run in the correct order).

  1. With your report highlighted, select the F6 Print button – the Print dialogue box will display.
  2. Select from the following options:
    1. From:
      • Database (to search the entire database)
    2. To:
      • File (to save a report as a file)
    3. Frequency:
      • Any frequency can be used: Once Only, Daily, Weekly or Monthly
    4. Schedule:
      • First Print Date – in DD/MM/YYYY format
      • First Print Time
        clipboard_e4bc8756b0ce7dade74ec69afaa911880.png

IMPORTANT! In order to ensure that only those borrowers with outstanding items are/remain suspended, the reports MUST be run in the correct order!

  1. Once you have selected all of your settings, click the OK button – the Report – Save As screen will display:
    clipboard_e0d6bb61b31c419ee3878bb437d3d39b4.png
  2. Select a Save in: location and type in a File name: - for example: Borrower Update- Clear Suspensions or Borrower Update – Set Suspensions.
  3. Click the Save button when complete.

Check print progress

  1. You can check the progress of your reports at any time by going into Main > Reports > RepPrintProgress.
    clipboard_e59dd94470011c8b68f529fde863b6c0a.png
  2. You can also click through the three tab options at the top to see the ones that are Waiting, Running, or have already been Printed.
  3. Your report will show up in Printed when it is complete.
    clipboard_ef5cc2d93fc7b836d14bd67abe4b88d6f.png

Check the suspended borrowers

If required, borrowers that have been suspended with the Borrower Circulation Automatic Update report can be checked from a borrower file.

  1. Launch the Amlib Client.
  2. Got to Main > Borrowers > Borrower – the Borrower Details screen will display.
  3. From the menu, select File > DisplayFile – the Borrower Saved Query Results screen will display:
    clipboard_e32ad36a4079749cd74c803a3efbe5151.png
  4. Borrower Circulation Automatic Update will be listed under the report name – for example: Borrower Update – Auto Suspension.
  5. Highlight the saved file and click the F9 Select button to see a Borrower List of the borrowers who have been suspended:
    clipboard_e6a56ea11fb39b8ff8e3070b656f90d3b.png
  6. Double-click on a name to bring up the Borrower Details:
    clipboard_e91e739fce25d03288d558adfadf8f2c9.pngclipboard_e0c2ca9960112cb6a8afe3ffc4d789b14.png