Stockitem history report

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

The following report displays the stockitem history.

Please Note: This report is 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. Select the F1 New button – the Select Report Format screen will appear
  4. Highlight the Stockitem History report template you would like to use – &STKHIST.QRP
    (Stockitem History list)
  5. Click the OK button
  6. Type in a Description – for example: DVD Usage History
  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/2011
    4. Enter a finish date: History Date <= enter a date in DD/MM/YYYY format – for example: 11/11/2011 (a finish date is optional – if not inserted, the report will go up to the current date).
    5. You can further restrict your list to a particular Form or Stats Code - for example: Form = DVD or StatsCode = FIC or Item 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

View Report

  1. Highlight the report you wish to run and select the F8 View button
  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