Skip to main content
OCLC Support

Borrower financial entity

Find information about the Borrower financial entity in Amlib OpenReports.

Owing money by financial type

The Entity to select will depend on whether Double Line Accounting is being used or not. The Database Fields will be different depending on which mode is being run. To find out which mode is being run, see Appendix 1 under Borrower Financials

  1. Select New from the buttons of the Report Designer
  2. The Edit Report Window will display
  3. Enter a Report Title in the Report Title section. This can display at the top of the report. For the sample we can give a Title of “Owing money
  4. Enter a Group if the Reports for example Financials
  5. Enter a Sub Group for example Borrowers
  6. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  7. Select Orientation
    • Landscape (select for the sample)
  8. Leave Show sql
  9. Show details: For this sample Report we will leave as the Defaults
    • All: To display all the details
  10. Show Sub totals if a calculation based on Groups is required (Default is unticked). For the sample tick this
  11. Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample tick this
  12. Tick Private For our sample leave this unticked.
  13. Show header on first page. For our sample leave this ticked
  14. Show header on next pages. For our sample leave this unticked

Display Fields

  1. Highlight the Entity from the Entities / Data Fields
  2. For this sample, select the entity of Borrower Financial – Single Entry
  3. Drag and drop the required Data Fields into the Display Field Column. In this sample we have Transaction Borrower Name, Transaction comments, Charge amount, paid and date
  4. Change the Function to $ amounts if required

Group

  1. Highlight the Borrower Financial Entity from the Entities/Data fields column
  2. Drag and drop Transaction Type to the Group fields column which will base the Report by Transaction Type

Filter

  1. Return to Report Designer
  2. Select the Borrower Financial Entity
  3. Drag and drop Transaction Amount Owing to the Filter
  4. Select Greater than from the Drop-down Options
  5. Enter 0.00 or the relevant amount for the report

Order by

It is useful to have an Order sequence to ensure it orders correctly

  1. Drag and drop Transaction Type over to the Order by section
  2. Select Ascending from the drop-down box

Preview

Select Preview to view the Report

Note: It would be a good idea to alter the Headings as they are wrapping and making them hard to read

Save

Once the Report is successful, save so it can be used again in the Viewer or Designer