Doorgaan naar de website
OCLC Support

Delete Borrower - Single entry financials in 5.3 and 5.4

Learn how to delete borrower single entry financials in Amlib 5.3 and 5.4.

This report allows the deletion of paid Borrower Financial Transactions. Care should be taken when deleting Financial records as once the entry has been deleted it cannot be retrieved.

It should be noted that only Financials will be deleted if the Borrower:

  • Has transactions which are paid and balanced
  • Owes $0.00
  • Are more than those required to keep as set in Supervisor>Installation>Circulation > Keep the last ### history (this applies to History transactions to be left in the Borrower Financial)

Financial Reports

Update Report Templates

The following report templates can be used in the Reports module to delete Financials if Update Entity is set to Y, and the report is run via the report Scheduler. The F7 Where statement is used to determine which records will be deleted.

Templates

  • &BORFINP.QRP – Deletes Borrower Financial Transactions records and creates a list of EVERY Borrower and Transaction . Send to File for record purposes??
  • &BFINSU.QRP – Deletes Borrower Financial Transactions records & produces a count of the records deleted (based on &BORFINP.QRP)

Financial Reports for Borrower (&borfinp.qrp)

This report will perform differently depending on the Supervisor parameter (Supervisor/LibraryMenu/Installation/System/Use Double Line Accounting). These instructions are for Single line accounting (Use Double Line Accounting = N).
clipboard_ebd0d105c7817b83f1bb6937d2dbf3126.png

 Note: Ensure the Template is a Purge Financial Report Type

Because the Report is large, you may like to send it to a File rather than Paper.

Create Financial Deletion Report

Step 1: Creating a Full Report to File for Checking

  1. Go to Main > Reports > RepBorrower.
  2. Click the F1 New button – the Select Report Format screen will appear
  3. Highlight the Borrower Financial report template you would like to use – &BORFINP.QRP (Borrower financial Summary). You should locate these templates via Template name rather than Description, as these are multi-function templates and sometimes the Description refers to this alternate functionality. If it does not exist it can be created in Reports > RepAddNew or contact Amlib Support if unsure.
  4. Click the OK button.
  5. Type in a Description – for example: Delete Financials more than 6 Years Old
  6. Ensure the Update Entity (Y/N) column is set to N
  7. Click the F3 Save button.
  8. Select the F7 Where button to set up the selection parameters – this will bring up the Borrower Reports – Where screen
  9. Enter the following Where search:
    1. Enter a start date: FinTrans Date <= enter a date in DD/MM/YYYY format – for example: 01/01/2005 or use the Special Button. Select Current Date and enter 72 in the Months Box (for 6 years).
    2. It is possible to use other Where conditions e.g. for Financial Types, or Borrower Types etc. if you want only specific Financials deleted.
    3. Click the F3 Save button when complete.
  10. Click the F9 Order button – this will bring up the Borrower Reports – Order By screen.
    1. Select BorBarcode from the Columns list and arrow it across into the Order By list.
    2. Click the F3 Save button when complete.
  11. Print F6 Print. It is suggested File is chosen to send the Report to an rtf File.
    clipboard_eaa8676bc419666ec5e8581861396bc55.png
  12. Click OK.
  13. Enter the File name and Browse to the Destination Location.
    clipboard_e48065bd16340f8aae4d5fdab4001c7c6.png

Schedule Report

Start the Scheduler

  1. From the Reports screen, select Application > RepStartSchedule.
    clipboard_e51ca1650b1556cde9e20d8b93253a021.png
  2. The Report Scheduler screen will then open.
  3. Select your printing options: Ensure Save to File is ticked (you can tick all three if you intend on printing up multiple reports using multiple formats during a session).
  4. Also decide If a report is scheduled by another user do you still want to print it? = Yes/No
    clipboard_e6866162df7d6b7c0be47304b362bb486.png
  5. Then click the OK button.
  6. After clicking OK, if you go back into the Application menu you will see that RepStartSchedule is now greyed out with a tick next to it – this indicates that the Scheduler is now running
    clipboard_e1cd34b2a47cae1dbb9827a6374ee48c5.png

     Note: If you need to restart the scheduler at any point, you will need to log out of all Report screens (Ctrl + L) and start at the beginning of these instructions.

Check Print Progress

  1. You can check the progress of your reports at any time by going into Main > Reports > RepPrintProgress.
  2. If your library uses the scheduler for a lot of reports, you can select a frequency type from the Filter drop-down menu at the top:
    clipboard_ece005bf7febecaddb269f0d70def5b28.png
  3. You can also click through the three tab options at the top to see the ones that are Waiting, Running, or have already been Printed.
    clipboard_e98244c0898ce921034b726733ff79f0d.png
  4. Your report will show up in “Printed” when it is complete

Example of Listing (&borfinp.qrp)

clipboard_e4aa05f86debdd79bd272591ad7b519be.png

 

Step 2: Creating the Summary and Clearing the Financials

  1. Go to Main > Reports > RepBorrower.
  2. Highlight the Report that was run earlier to get the listing.
  3. Click the F2 Modify button – the Select Report Format screen will appear.
  4. Highlight the Borrower Summary Financial report template– &BORFINSU.QRP (Borrower financial Summary). If it does not exist it can be created in Reports > RepAddNew or contact Amlib Support if unsure.
  5. Click the OK button.
  6. Ensure the Update Entity (Y/N) column is set to Y
  7. Click the F3 Save button.
  8. Print F6 Print. It is suggested File is chosen to send the Report to an rtf File.
    clipboard_e1e944601a1b1b3dc52ff3d346b06aedc.png
  9. Click OK.
  10. Enter the Summary File name and Browse to the Destination Location.

Schedule Report

Start the Scheduler

  1. From the Reports screen, select Application > RepStartSchedule.
    clipboard_ee1c559d6abd9294fb02e28668df0b39c.png
  2. The Report Scheduler screen will then open.
  3. Select your printing options: Ensure Save to File is ticked (you can tick all three if you intend on printing up multiple reports using multiple formats during a session).
  4. Also decide If a report is scheduled by another user do you still want to print it? = Yes/No
    clipboard_e496551545a81ef515857c238bbe73df7.png
  5. Then click the OK button.
  6. After clicking OK, if you go back into the Application menu you will see that RepStartSchedule is now greyed out with a tick next to it – this indicates that the Scheduler is now running.
    clipboard_e6dcd2eb8b515ef0f52c7b48fd8882b5b.png

     Note: If you need to restart the scheduler at any point, you will need to log out of all Report screens (Ctrl + L) and start at the beginning of these instructions.

Check Print Progress

  1. You can check the progress of your reports at any time by going into Main > Reports > RepPrintProgress.
  2. If your library uses the scheduler for a lot of reports, you can select a frequency type from the Filter drop-down menu at the top:
    clipboard_efa356bd2611e0a51b388e04f4d248483.png
  3. You can also click through the three tab options at the top to see the ones that are Waiting, Running, or have already been Printed.
    clipboard_e8be33edfdaa32203cd92c47bd013fad7.png
  4. Your report will show up in “Printed” when it is complete

Example of Summary (&borfinsu.qrp)

clipboard_edbf20e6a711adb3c4c1d22c5bfe65266.png