Value of the collection
Learn how to find the value of the collection using Stockitem reports in Amlib.
How to find the value of the collection
Several templates can be used in the Stockitem Reports screen to determine the value of the collection.
The choice of report will determine the Sort option. The one used in the example is by Form and Stats.
- Launch the Amlib client
- Go to Main > Reports > RepStockitem – the Stockitem Reports screen will display
- Click the F1 New button – the Select Report Format screen will display:
- Highlight this report Count by Form & Stats (&STKCFS.QRP) and click the Select button
- Type in a Report Description – for example: Value of the Library Collection
- Click the F3 Save button
- Click the F7 Where button – the Stockitem Reports – Where screen will display
- The Where parameters will depend on what you want to list:
- To report on the entire collection:
- Select ItemNo from box 1
- Select is not equal to () from box 2
- Leave box 3 blank
- Click the Paste button
- To report on what has been received this year:
- Select Recd from in box 1
- Select >= in box 2
- Type the date for the start of the year (for example: 01/01/2011) in box 3
- Click the Paste button
- To report on just one Location:
- Select PermLoc from box 1
- Select = in box 2
- Enter the relevant Location code in box 3 – for example: CHELSEA or LIB
- Click the Paste button
- Click the F3 Save button when complete
- To report on the entire collection:
- The order will be fixed, so the F9 Order button should be greyed out:
- If you wish to view the Report before printing, click the F8 View button:
- Once the first page is displayed, click the print icon to send the report to the printer
- Alternatively, click the F6 Print button to schedule the report, and select Application > RepStartSchedule from the menu (the Scheduler must be active in order for the scheduled report to print)
All the reports give details of:
- Total of items in each category (Count is the No of Stockitems) Unique Cats is the Count of the No of Catalogues referenced by the Stockitems) – for example: there may be one Unique catalogue that has 16 Stockitems referenced
- Total number of Issues, Reserves, Renewals and Value
- Grand totals for all locations