alongside Bank Mandates on the sub-menu on the left. Additional options will be displayed.This functionality generates a report of all new policies or amendments to the name, bank account or debit order date for existing policies for the Endowment Product.
From the Audit menu, click alongside Bank Mandates on the sub-menu on the left. Additional options will be displayed.
Click New below Bank Mandates. The Bank Mandates screen will be displayed.
Capture the From Date and To Date and the email address to which notification of the availability of the report must be sent.
Note:
The dates captured in the From Date and To Date fields can be the same so that a report for a single date can be extracted.
Click GENERATE.
A message will confirm that the report has been submitted:
Report submitted
The system will extract all the changes to Surname, Client DTI Account or Debit Order payment date for the period captured.
The system will find all of the Natural Person records linked to a Membership for the Scheme selected with a Timestamp date greater than or equal to the From Date captured and less than or equal to the To Date. The system will find the JUH02 record for each of the Memberships linked to the Natural Person records found with a Timestamp date equal to the Natural Person record Timestamp date.
The JUH02 record will be compared with the latest previous JUH02 record and if the Surname is different, the Membership will be included in the extract. If there is no previous JUH02 record then it will be treated as a new record.
The system will find all the DTI Account records with a Timestamp date greater than or equal to the From Date captured and less than or equal to the To Date and linked to a Membership linked to the Scheme selected and include the Membership in the extract.
The system will find all of the Membership Payment Detail records with a Timestamp date greater than or equal to the From Date captured and less than or equal to the To Date captured and linked to a Membership linked to the Scheme selected. The record found will be compared with the latest previous record and if one of the values that has changed is the Pay Day, the Membership will be included in the extract. If there is no previous record then the Membership will be included in the extract as it will be a new Membership.
For each Membership, the system will find the latest DTI Account record and extract the following information for each Membership:
- Surname and First Names
- ID Number
- Bank Name
- Branch Name
- Branch Code
- Bank Account Number
- Premium Amount (Regular Payment Amount on current active Membership Payment Detail record)
Click View below Bank Mandate. The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To view details, click on the hyperlinked display in the Action column. The Report Selection screen will be displayed.
The following columns are displayed:
- Surname
- First Names
- ID Number
- Bank Name
- Branch Name
- Branch Code
- Account Number
- Amount (Premium)
Capture an email address and click the EXPORT button to email the report in a csv format to the email address captured.