Stockitem dusty items

Learn how to create and view the Stockitem dusty items report in Amlib.

Stockitem dusty items report

There are two main ways to do a dusty items report – in Stockitem Where and as a Stockitem Report.

There are several report templates to count Stockitem usage. The report templates are designed to show usage statistics displayed in a number of ways:

The last two 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.

Never Borrowed (via Stockitem Where)

  1. Launch the Amlib client
  2. Go to Main > StockItems > StockitemWhere – the Stockitem Where Search screen will display
  3. Enter the following Query Description:
    1. Times Borrowed < 1
    2. On Loan = N
    3. (optional) Location Perm =
    4. (optional) Form – for example: Form = DVD
    5. (optional) Sts Code – for example: Sts Code = FIC
  4. Click the F5 Query button to see a list of items
  5. Click the F6 Count button to see a count of items
  6. Click the F7 QtoFile button to save the list to a Saved File

Last Borrowed 12 Months Ago (via Stockitem Where)

  1. Go to Main > StockItems > StockitemWhere – the Stockitem Where Search screen will display
  2. Enter the following Query Description:
    1. Last Active <= Current Date – 12 months (via the Special button)*
    2. (optional) Location Perm =
    3. (optional) Form – for example: Form = DVD
    4. (optional) Sts Code – for example: Sts Code = FIC
  3. Click the F5 Query button to see a list of items
  4. Click the F6 Count button to see a count of items
  5. Click the F7 QtoFile button to save the list to a Saved File

*Using Last Active has limitations because an item may have been returned as part of a Stocktake (or other process) without necessarily being borrowed beforehand. If this is the case, then you might want to consider substituting the following for Last Active:

  1. Stk History Type IN ISSUE,RETURN (or Stk History Type = ISSUE if you just want to count when an item last went out)
  2. Stk History Date <= Current Date – 12 months (via the Special button)

Create Report

    1. Go to Main > Reports > RepStockitem – the Stockitem Reports screen will display
    2. Select F1 New – the Select Report Format screen will display
    3. Highlight the report template you would like to use – if you want to use Last Active date then try &STKTITL.QRP. If you would like to search against the History Type/Date then use one of the history count templates (&STKHCC.QRP or &STKHCSC.QRP)
    4. Click the Select button
    5. Type in a Description – for example: Items Never Borrowed
    6. Ensure the Create Fin (Y/N) column is set to N
    7. Click F3 Save

Where Search and Order By Parameters

  1. Highlight the report and select the F7 Where button –the Stockitem Reports – Where screen will display
  2. Never Borrowed: enter the following Where parameters:
    1. ItemNo IS NOT NULL
    2. Times Borrowed < 1
    3. IsOnLoan = N
    4. (optional) PermLoc =
    5. (optional) Form – for example: Form = DVD
    6. (optional) StatsCode – for example: StatsCode = FIC

      (Use the Paste button to insert the parameters into the list at the bottom of the screen)
       
  3. Last Borrowed: enter the following Where parameters:
    1. ItemNo IS NOT NULL
    2. LastActive <= Current Date – 12 Months (via the Special button)
    3. (optional) PermLoc =
    4. (optional) Form – for example: Form = DVD
    5. (optional) StatsCode – for example: StatsCode = FIC

      (Use the Paste button to insert the parameters into the list at the bottom of the screen)
       
  4. Last Borrowed by History: enter the following Where parameters:
    1. ItemNo IS NOT NULL
    2. History Type IN ISSUE,RETURN (or History Type = ISSUE if you just want to count when an item last went out)
      You can use ISSUE, RENEW OR RETURN
    3. 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
    4. History Date <= Current Date – 12 months (via the Special button)
    5. (optional) PermLoc =
    6. (optional) Form – for example: Form = DVD
    7. (optional) StatsCode – for example: StatsCode = FIC
    8. Click F3 Save when complete – this will close the Stockitem Reports – Where screen and return you to the Stockitem Reports screen
  5. Select the F9 Order button –the Stockitem Reports – Order By screen will display
  6. Use the arrow keys to enter the following Order By statement (&STKTITL.QRP only):
    1. Call Number ASC
    2. Click the F3 Save button when complete – 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 click the F8 View button – a prompt with the following message will display: This type of report may use a Saved File as the Source. Do you want to select the file now?
  2. If you would like the report to run using the entire database (rather than a Saved List) then select the No button
  3. The report will then display:
  4. Select the print button to print the report