Stockitem usage count - no date
Learn how to create and view the Stockitem usage count report in Amlib.
There are several report templates to count Stockitem usage. The report templates are designed to show usage statistics displayed in a number of ways:
- &STKTUR1.QRP – count of items and turnover (by Stats and Form codes)
- &STKTUR2.QRP – count of items and turnover (by Cat Ref)
- &STKTUR3.QRP – count of items and turnover (Summary by Stats code)
- &STKTUR4.QRP – count of items and turnover (by Author)
Create Report
- Launch the Amlib client
- Go to Main > Reports > RepStockitem – the Stockitem Reports screen will open
- Select the F1 New button – the Select Report Format screen will appear
- Highlight the Stockitem usage report template you would like to use
- Click the OK button
- Type in a Description – for example: Usage Count (DVDs)
- Ensure the Create Fin (Y/N) column is set to N
- Click the F3 Save button
Where Search and Order By Parameters
- Highlight the report and select the F7 Where button – this will bring up the Stockitem Reports – Where screen
- Enter a Where search:
- Restrict your list to a particular Form or Stats Code - for example: Form = DVD or StatsCode = FIC
- Click the F3 Save button when complete – this will close the Stockitem Reports – Where screen and return you to the Stockitem Reports screen
- Select the F9 Order button
- Set the Order By parameters and click the F3 Save button – the &STKTUR2.QRP report MUST be ordered by CatRef
View Report
- Highlight the report you wish to run and select the F8 View button
- 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?
- If you would like the report to run using the entire database (rather than a Saved List) then select the No button
- The report will then display:
- Select the print button to print the report