Scenario


You have a list of debtor accounts that have been referred to debt recovery and you need to know what new payments / charges have been added to these accounts from a given date. 


The ETL generated as part of ticket SR-72798 can help with this. It takes in a list of debtor IDs and a date chosen by you, and spits out a summary of payments and charges broken down by revenue type and entity ID. 


Steps to Execute


You will need:

  • A list of debtor accounts in the format of the attached file. 
  • It must be saved as a .csv
  • It must have only valid debtor IDs
  • It must have no duplicates of debtor IDs.
  • It must be named "rnr_debtor_list.csv"


Steps:

  1. Upload your CSV to your USRAREA server folder in the P&R suite. 
  2. If you've done this before, your old one may still be in there - make sure you overwrite the old file. 
  3. Navigate to the ETLs screen and run the ETL
  4. Enter the "as-of" date - this filters the transaction dates - if a given transactions' date is on or after the provided date, it will be included in the summary. Otherwise the transaction will be ignored.
  5. Hit run and wait for the ETL to run. It can take some time so be patient.
  6. When the ETL is finished you will have an email in your inbox with the results.