Stocktake: Report missing items

Report on missing item

This procedure is for use when: you have completed a stocktake and need a list of all items that were not present during the stocktake.

Check individual items

Individual items can be checked from the Main> Stockitems > Stockitem - Item > History. This screen displays the last StockTake date. If the flags have been set, this will be empty (until counted). This is the field that is updated if the item has been wanded using Offline, Online, on Issue or on Return.

Reports

Reports can be done either via a Where Search or set up as a Stockitem Report.

Recommended Where Searches for Stocktake missing items:

• They can be saved and adapted to report various sections of the database, for example, Missing NF can be set up for Call Numbers > 0 and < 299 ZZZ, saved and adapted for Call Numbers > 300 and < 499 ZZZ
• The same report can be viewed as a Count, a Query table or QueryInto File
• When the items are to be changed (for example: to Missing 2011) as a Process, then a Stockitem Wand Change can used to save the Where Search or File created:

Where statement

The Where Clauses used will depend on the site and the report required. The most important

WhereSearch clauses will be Stocktake Date is NULL. Other conditions to include could be:

• • Location – for example: Branch, Campus, Dept, LIB only, etc
  • Stats Code – for example: JF (Junior Fiction) only
  • Form Code – for example: BK (Books) only
  • Loan Status – for example: On Loan = N
  • Call Number range – for example: F AAA to F CZZ
  • Item received by date – for example: Items received before Stocktake started
  • Process – for example: exclude Damaged or Missing
  • On Order – for example: exclude On Order items
  • InterLibrary Loan – for example: exclude all ILLs

This table contains a list of column names from which to choose (use the scroll bar to move up and down this list):

1. Type the Where Condition (box 1)
2. Choose an Operator (box 2)
3. Type your search term for the chosen field (box 3) OR use the Special button, which enables you to choose useful fields (for example: Current Date) that can be used for any mathematical operand (for example: , , , , , )
4. Click the Paste button to add in each statement

Get your results

• Click the F5 Query button to view the records contained in the Query
• Click the F6 Count button to Display the number of matching records
• Click the F7 QtoFile button to save the results of the query in a file. Either select a file or create a new file and then click the F9 Select button. The number of records inserted into the file will be displayed. If the file already contains data the new records will be added to the file and existing data remains. It is possible to empty the contents of the file by selecting the F2 Empty button before selecting the file:
  
  

Saving where searches

1. Where searches can be saved by selecting the F2 Insert button
2. Type a Description so that they can be recalled for execution at another time from Stockitem (Item menu)

Alternatively the search can be saved from the Where Search screen by choosing the F4 Select button. This is useful for calling up queries used on a regular basis and can be used when updating Process to MISSING in Stockitem Wand Change.

It is also very useful for Stocktake Reports as the parameters can be set and then altered slightly for a different area of Stocktake – for example: the Missing Fiction Where search can be edited when the non-fiction area is counted – just change the Stats code to be NF rather than F.

Accessing the saved searches

Saved Where Searches can be accessed either through:

• The Where Search Window by clicking the F4 Select button OR
• From the Stockitem screen menu, select Item > SavedWhereSearch (the searches can be executed or counted from this option)
• Reports cannot be edited here; editing is only done within the Where Application

Printing a list

A printed listing of missing items is usually required so they can be checked on the shelf.

1. From the table of items generated from the Where Search (by using F5 Query) highlight the items to be included in the report
2. Click the F6 (to print) or F7 (to report) key on your keyboard OR from the Amlib client menu, select Table > Print or Table > Report