I wish to know the balances owing as a summary by financial type
- Amlib Borrower Reports
A report template exists in your Amlib Reports folder that can be created in Main > Reports > RepAddNew as a Borrower (List) Financial style. If this is not yet created for you please contact OCLC Support.
- Go to Main > Reports > RepBorrower.
- Click F1 New.
- Highlight the Borrower Owing by Type (&bofinto.qrp) template (as named when created in RepAddNew).
- Click Select.
- Enter a description and click F3 Save.For example, Owing summary by Financial Type.
- Click F7 Where.
- Highlight Transactions Owing from Box 1. Click the > Operator from Box 2 and enter 0 in Box 3 and click Paste.
- Highlight Owing from Box 1. Click the > Operator from Box 2 and enter 0 in Box 3 and click Paste.
- Enter any other Where parameters that are required. For example, to target a particular Location or Transaction Date range etc.
- Save the Where parameters with F3 Save.
- This report is split into Financial Types so it is essential to sort the list by Financial Type as the primary Sort Option. Click F9 Order. Arrow across Financial Type, then Surname and lastly BorBarNo. Click F3 Save.
- Click F8 View to check the report. It will show the following:
- Borrower Type
- Amount owed
- Amount paid
- Amount remaining
- The Totals for each Financial Type displayed
- The Grand Total at the end of the report for the amount still outstanding.
- Transactions Owing is a special parameter (shown in blue) and cannot be the only Where parameter
- This report is suitable for both Double and Single line accounting