Stockitem high usage count

Learn how to create and view the Stockitem high usage count report in Amlib.

There are several report templates to count high Stockitem usage. The report templates are designed to show items used more than 5, 10 or 20 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 Stockitem History. Users that delete data from the Stockitem History table need to be aware of the limitations of results.

Create Report

  1. Launch the Amlib client
  2. Go to Main > Reports > RepStockitem – the Stockitem Reports screen will open
  3. Click the F1 New button – the Select Report Format screen will appear
  4. Highlight the Stockitem History report template you would like to use – &STKH5.QRP (Usage Count > 5), &STKH10.QRP (Usage Count > 10) or &STKH20.QRP (Usage Count > 20).
  5. Click the Select button
  6. Type in a Description – for example: Usage Count > 5 Issues
  7. Ensure the Create Fin (Y/N) column is set to N
  8. Click the F3 Save button

Where Search and Order By Parameters

  1. Highlight the report and select the F7 Where button – this will bring up the Stockitem Reports – Where screen
  2. Enter the following Where search:
    1. History Type = ISSUE
      You can use ISSUE, RENEW OR RETURN
      (Use the Paste button to insert the parameter into the list at the bottom of the screen)
    2. If using History Type = Issue, you may want to exclude any alterations made to the due date after renewals: History Contents NOT LIKE Due Date Altered
    3. Enter a start date: History Date >= enter a date in DD/MM/YYYY format – for example: 01/01/2010
    4. 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).
    5. You may want to add other restrictors – for example: Borrower No =
    6. Click the F3 Save button when complete – this will close the Stockitem Reports – Where screen and return you to the Stockitem Reports screen
  3. Click the F9 Order button – this will bring up the Stockitem Reports – Order By screen
    1. Select Item No from the Columns list and arrow it across into the Order By list
    2. Click F3 Save – this will close the Stockitem Reports – Order By screen and return you to the Stockitem Reports screen

View Report

  1. Highlight the report you wish to run and select F8 View
  2. The following message will appear: This type of report may use a Saved File as the Source. Do you want to select the file now?
  3. If you would like the report to run using the entire database (rather than a Saved List) then select the No button
  4. The report will then display:
  5. Select the print button to print the report