Borrower high usage count

Learn how to create and print the Borrower high usage count in Amlib.

There are several report templates to count high Borrower usage. The report templates are designed to show items used more than 3, 6, 10 or 100 times within a specified period (using the F7 Where statement). The report templates will list the title and the number of times used.

The reports are run against the Borrower History. Users that delete data from the Borrower History table need to be aware of the limitations of results.

Load/check the template type

  1. Launch the Amlib client.
  2. Go to Main > Reports > RepAddNew.
  3. The Report Files window will open.
  4. From the Report Entity drop-down, select the Report Screen (module) you would like to load a template for – for example: Borrower.
  5. Highlight a borrower history report (see list above) and click the F2 Modify button – the Borrower Modify Report File window will open
    (To load a new report template: click the F1 New button instead).
  6. Type in a Description – for example: Borrower History Count.
  7. Choose Type: – ensure that Borrower History is selected.
  8. You can leave Default Stats Code blank.
  9. Update Entity (Y/N) = N.
  10. Click the F3 Update button.
  11. Close out of the Report Files window

The template is now loaded and available for use in a Report.

clipboard_e9d7997f1f99581704568aa00561af949.png

Create report

  1. Go to Main > Reports > RepBorrower.
  2. Select F1 New – the Select Report Format screen will appear
  3.  Highlight the Stockitem History report template you would like to use – &BORH3.QRP (Usage Count > 5), &BORH6.QRP (Usage Count > 10 ), &BORH10.QRP (Usage Count > 10) or &BORH100.QRP (Usage Count > 20).
  4. Click the Select button.
  5. Type in a Description – for example: Usage Count > 6 Issues.
  6. Ensure the Update Entity (Y/N) column is set to N.
    clipboard_e95c2dfc3952aa4367d7dc4e6bb5f2aa5.png
  7. Click F3 Save.

Where search parameters

  1. Highlight the report and select the F7 Where button – the Borrower Reports – Where screen will open.
  2. Enter the following Where search:
    1. History Type LIKE READ
      (Use the Paste button to insert the parameter into the list at the bottom of the screen)
    2. Enter a start date: History Date >= enter a date in DD/MM/YYYY format – for example: 01/01/2010
    3. Enter a finish date: History Date <= enter a date in DD/MM/YYYY format – for example: 10/10/2010 (a finish date is optional – if not inserted, the report will go up to the current date).
    4. You may want to add other restrictors – for example: Borrower No = or Borrower Class =

3. Click the F3 Save button when complete – this will close the Borrower Reports – Where screen and return you to the Borrower Reports screen.

clipboard_eb1c98199cbabd4cb1fd7026969e918cf.png

Order by parameters

  1. Click the F9 Order button – the Borrower Reports – Order By screen will open.
  2. Select BorBarNo from the Columns list and arrow it across into the Order By list.
  3. Click the F3 Save button when complete – this will close the Borrower Reports – Order By screen and return you to the Borrower Reports screen.

clipboard_ef15d5ec91211e22801eb1616ac83e515.png

View/print report

  1. Highlight the report you wish to run and select the F8 View button.
  2. The following message will appear:
    clipboard_e9b564f36973645c1d1e9044178d4ffc0.png
  3. If you would like the report to run using the entire database (rather than a Saved List) then select No.
  4. The report will then display:
    clipboard_e7adcebddf35d3454d2117e8ea95c79b6.png
  5. Select the print button to print the report.