alongside New under Payment History on the sub-menu on the left. Additional options will be displayed.This facility extracts a report of the payment history for a specified period per beneficiary.
From the Beneficiary Fund menu, click alongside New under Payment History on the sub-menu on the left. Additional options will be displayed.
Click New below Payment History. The Payment History screen will be displayed.
Capture the relevant details as follows:
|
From Date |
The start date of the period. The capture of a date is mandatory. |
|
To Date |
The end date of the period. The capture of a date is mandatory. |
|
Payment Type |
Click on the drop-down list to display a list of Payment Types from which to select. The selection of a Payment Type is optional. The default selection is ALL. |
|
Scheme Code |
Capture the code for a specific scheme, or leave blank to display all schemes. |
|
Reference Number |
Capture the trust number for a specific member, or leave blank to display all members that fit the criteria specified. |
|
|
The email address to which the extract must be sent. The completion of this field is mandatory. |
Click GENERATE REPORT.
The system will retrieve the Business Transactions (BT’s) in the Beneficiaries’ INVESTMEMB accounts with an Accounting Activity of INITIAL PMT, AD HOC PMT or REGULAR PMT and for which the Transaction Date is greater than or equal to the From Date and less than or equal to the To Date.
If there is more than one BT with the same Transaction Date on the Beneficiary Payment History Report, the system will calculate the balance after the BT for the value that is displayed in the Balance column.
If a Scheme Code is captured, the system will retrieve the BT’s only for the Beneficiaries for the Scheme Code captured.
If a Reference Number is captured, the system will retrieve the BT’s only for the Beneficiary with the Reference Number captured.
If a Payment Type is selected only the BT’s with an Accounting Activity equal to the Payment Type selected will be retrieved.
For each BT retrieved, the balance on the Beneficiary’s INVESTMEMB account as at the Transaction Date of the BT will be retrieved.
The following information will be extracted for the BT’s retrieved:
- Membership Reference Number
- Surname and First Name
- Date of Payment (Transaction Date)
- Type of Payment (Accounting Activity Name)
- Payment Reason (Trust Payment Type)
- Amount Paid (BT Amount)
- Balance (INVESTMEMB account balance as at BT Transaction Date)
A message will indicate once the job has been successfully submitted (and an e-mail will be sent to the e-mail address provided).
Click View below Payment History. The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To display the Payment History, click the display hyperlink in the Action column. The following report will be displayed:
The following columns are displayed:
- Beneficiary Number
- Surname
- First Name
- Initials
- Date of Payment
- Type of Payment
- Adhoc Payment Reason
- Amount
- Balance