Borrower and stockitem memo lists
Learn how to create a report based on both the Borrower and StockItem memo lists in Amlib.
It is possible to produce a report based on both the Borrower and Stockitem Memo lists.
Supervisor Settings
Memo Types – pre-formatted memos that can then be reported on – for both Borrowers and Stockitems can be set up in Supervisor module.
- Launch the Amlib client
- Open the Supervisor module
- Select LibraryMenu > MemoTypes – the Memo Types table will display:
- To insert a new Memo Type:
- Click the F1 New or F2 insert button – a new entry will appear in the table
- Type in a Memo Type – for example: NEWCARD
- Type in a Description – for example: Borrower Issued New card
- If you would like this Memo Type to be available as a Stockitems memo, then Valid for Holdings = Y
- If you would like this Memo Type to be available as a Borrower memo, then Valid for Members = Y
- Show as Default: If set to Y, then the memo will automatically display when the borrower or stockitem record is opened
- Expires n days time: this is the number of days you would like the memo to stay in the borrower or stockitem record before being automatically deleted – for example: 365 = 1 year
- Click the F3 Save button when complete
- Exit and restart the Amlib client for the new Memo Type to be available in the individual modules
Adding a Memo to a Borrower or Stockitem Record
- Launch the Amlib client
- Open the Borrower or Stockitem module
- Locate a record to which you would like to add a memo
- Select Borrower > Memos or Item > Memos (depending on the module you’re in) – the Memos for this Borrower/Stockitem table will appear
- To insert a new memo:
- Click the F1 New or F2 insert button – a new entry will appear in the table
- If you would like to use an existing Memo Type, then that should be entered first, as this will automatically populate most of the other fields. Use . <tab> to bring up the list of available Memo Types
- Double-click on a Memo Type Code to select it – the memo details will be added to the new entry and the Show, End Date, Type and Memo Details fields adjusted according to the default Memo Type details set up in the Supervisor module
- You may then adjust the Show (which will automatically display the memo when the record is opened if set to Y), End Date (the date you would like the memo to be automatically deleted) and Memo Details fields
Note: When adjusting the Memo Details field, it is a good idea to add to existing text rather than overwriting it, as this will help with any searching – for example: Borrower Issued New card – as borrower changed surname - Click the F3 Save button when complete
- To delete an existing memo:
- Highlight the entry in the table to be deleted
- Click the F4 Delete button – this will mark the memo for deletion
- Click the F3 Save button to remove marked memos from the list
Load the Template
It is sometimes necessary to load a memo template (particularly on older setups)
- Launch the Amlib client
- Go to Main > Reports > RepBorrower or Main > Reports > RepStockitem – depending on the type of template you would like to load (a Borrower Memo template or a Stockitem Memo template)
- From the main menu, select Application > RepAddNew
- The Report Files window will open – ensure that the Report Entity = Borrower or Stockitem (whichever is relevant)
- Check if the Memo template has been added:
- Borrower Memos: &BORMEMO.QRP
- Stockitem Memos: &STKMEMO.QRP
- To add a new template:
- Click the F1 New button
- Type in a Description – for example: Borrower Memos or Stockitem Memos
- Browse to the Amlib/Reports folder on your Amlib Server and locate the template to be loaded (if the template has been loaded onto your PC – then navigate to the local folder) – you will need to change the Files of Type dropdown to System Report Templates (*.QRP) to be able to locate templates that have filenames beginning with an &
- Click on Open
- Choose Type = Memos
- You can leave Default Stats Code blank
- Update Entity (Y/N) = N
- Click on the F3 Update button when complete
- Close out of the Report Files window
Create a Memo Report
- Go to Main > Reports > RepBorrower or Main > Reports > RepStockitem – depending on the type of report you would like to run
- Click on the F1 New button – the Select Report Format screen will appear
- Scroll down and select the relevant memo report template:
- Borrower Memos: &BORMEMO.QRP
- Stockitem Memos: &STKMEMO.QRP
- Create Fin (Y/N) = N
- Click the F3 Save button
- Click the F7 Where button to set up the selection parameters – this will bring up the Borrower/Stockitem – Reports screen
- Enter a Where search:
- Memo Type = (type in a pre-existing Memo Type code – for example: Memo Type = NEWCARD)
- You may want to add other restrictors – for example: End Date = or BorBarNo = or Item No =
- Click the F3 Save button when complete
- Click the F9 Order button and select BorBarNo or Item No from the Columns list and arrow it across into the Order By list, then click the F3 Save button when complete
- Select the F8 View button to view report results:
- Click the print button to print the report