This report is the same as the Member Investment Value report but uses Effective Date balances and includes the contributions that have been received with a Due Date less than or equal to the Effective Date of the report but with a Transaction Date greater than the report Effective Date.
As the Effective Date balances are used, backdated transactions for which the Effective Date is less than or equal to the report Effective Date are automatically included. This includes backdated distributions, bonus corrections and re-unitisations.
This report is generated by a batch run. The process involves four distinct steps:
- schedule the batch run
- submit the batch run job
- monitor the progress of the batch run
- view the report
These steps are described elsewhere in the manual. For details, refer to
Reports
Batch Runs
For information on scheduling and submission of the batch run for this report, refer to
Infrastructure
Batch
Create a new batch run, or change the parameters of an existing batch run.
For information on scheduling a batch run, refer to Schedule a batch run under
Infrastructure
Batch
From the JAJU Batch Structure screen, select the batch group named MEMVALDUEDATE.
Specify the FROM EFFECTIVE DATE and TO EFFECTIVE DATE values.
Specify the Report Criteria that must be used for this report.
Refer to Submit a batch run job and Monitor progress of the batch run under
Infrastructure
Batch
The following is the batch job to be submitted.
Once the batch run has taken place, the report will become available.
Refer to
Reports
Accessing the Reports
To view the report, click By Due Date below Member Investment Values.
The Report Selection screen will be displayed listing the reports generated for the selected scheme.
The following columns are displayed:
- Scheme Code
- S_Timestamp (Date report was created)
- Date Captured
- Report Type
- Report Sequence No
- Action
To select a report, click on the hyperlinked display in the Action column alongside the required report. The following Report Selection screen will be displayed.
The following columns are displayed:
- Scheme code
- Pay Centre Code
- Membership reference
- Surname
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Switch in Process
- Unitised After Due Date
- Total
- Bonus Portfolio
- Bonus Portfolio Add Conts
- Bonus Rate (bonus rate used in interest calculation)
- Contribution Category
- Benefit Category
- Investment Category
- Monthly Contribution
- Additional Contribution
The report details are displayed as per the existing Member Investment Values report with the exception of an additional column Bonus Portfolio Add Conts for the Bonus Portfolio contributions with an Effective Date after the report Effective Date.
Note:
This additional column is included to be able to clearly identify the additional contributions included as it would be inappropriate to include the Bonus transactions in the Not Yet Unitised column and because separate totals are displayed for the unitized and bonus portfolios.
Enter the e-mail address to which the report should be sent, then click EXPORT.
A message will confirm that the e-mail has been sent.
Export started to email address: [email protected]
The report will be e-mailed as a CSV file, and it will be zipped. Once unzipped, the file can be viewed in Excel.
The following e-mail will be sent:
The extract completed and was saved for download.
Please download the file via the website.
If the Membership is linked to a Client with a Client Type of EXTERNAL ORG UNIT, the system will display the value for Name on the Organisation Unit record to which the Membership is linked in the Name column and leave the Date of Birth column blank: