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 STATEMENTS.
Specify either the FROM EFFECTIVE DATE or 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
Infrastructure
Batch
Click View below Investment Statements.
The Investment Statements screen will be displayed.
The following columns are displayed:
- Scheme Code
- Date Effective Run
- Date Effective To
- Transaction Date From
- Transaction Date To
- Date Extracted
- User ID
- Auth User ID
- Action
The following fields are available as search criteria:
- Date Effective From
- Date Effective To
- Date Extracted
Refer to Searching for Records for an explanation of the search process.
View investment statements
To view the investment statement batch, click display at the end of the required line.
The Investment Statements screen will be displayed.
The following columns are displayed:
- Timestamp
- Date Effective
- Scheme Code
- Membership Group
- Branch
- Membership No
- Company Reference Number
- Surname
- Init
- DOB
- ID Number
- Start Date
- Retirement Date
- Ret Age
- Pay Centre
- Action
The following fields are available as search criteria:
- Membership Group
- Branch
- Membership No
- Company Reference No
- Surname
For the purpose of bulk printing, up to three of the following fields can be used as sorting criteria:
- Membership Group
- Branch
- Membership No
- Company Reference No
- Surname
Extract investment statements to Excel
To extract the investment statement batch, click extract at the end of the required line.
The Investment Statements screen will be displayed.
Enter an e-mail address to which the Excel extract should be sent, then click SUBMIT QUERY. A message will confirm that the extract has been sent.
A separate Excel spreadsheet will be created for each of the following:
- Member details
- Contributions
- Investment transactions
- Investment splits
- Fund value investments
- Benefits
If any of the data extracts is too large for one file, multiple files will be created.
View investment statement rates
To view the investment statement rates used, click rates at the end of the required line.
The Investment Statements Rates screen will be displayed.
The following columns are displayed:
- Type
- Date
- Unit Price
- Bonus Rate
- Portfolio
Enter the e-mail address to which the report should be sent, then click EXPORT. The report will be e-mailed as a CSV file.
To print benefit statements for specific members only, click CREATE PDF in the Action column alongside the appropriate member. The investment statement will be displayed (in PDF format).
The following sections (as applicable to the individual member) will be displayed after the block of text (if any) following the Personal Information block:
Fund Value Summary
Fund Value
Contribution Investment Splits
Individual investment transactions report for the period
Individual investment summary for the period
To print the statements, click 
. The standard Windows print options will be displayed for selection.
To view the complete batch of investment statements on the screen, click CREATE BULK PDF - SCREEN. The investment statements will be displayed (in PDF format), as described above.
If there are more than a pre-determined number of benefit statements, the following message will be displayed:
To view the statements in the browser, click OK.
To print the investment statements to a file instead, click CANCEL (or press ESCape), then continue as described under Print all benefit statements below.
To print the complete batch of investment statements, click CREATE BULK PDF - FILE.
A confirmation message will be displayed.
Click OK. The Investment Statements screen will be re-displayed, and a message will confirm that the job has been submitted successfully.
Note:
When extracting large numbers of investment statements, you can use the search criteria and printing order features to make the output more manageable. Refer to Searching for Records.
Click List below Investment Statements.
The View Investment Statements screen will be displayed.
Open the required file by clicking the hyperlinked file name.
Note:
Where large investment statement files have been split into smaller files (refer to Note above), the files names will include wording that indicates the sequence of each file.
Refer to Print individual investment statements above for an example of an investment statement.
To print the statements, click . The standard Windows print options will be displayed for selection.
You are able to set the font for the various sections of the investment statement.
Click Text Font below Investment Statements.
The Text Font Settings screen will be displayed.
Use the FONT drop-down list to select the required font, and enter the font size in the SIZE box alongside. This is done for each section of the benefit statement, as required.
Place a tick in any or all of the Bold, Underline and Italic boxes to set the font as bold underlined or italic.
Use the CASE drop-down list to select the required case.
Click SAVE to save the settings. A confirmation box will be displayed.
Click LAST SAVED DATA to revert to the last saved settings.
Note:
In the column headed PDF font, the following section of the investment statement is Heading.
In the column headed PDF font, the following section of the investment statement shows Detail Heading (Contribution Investment Splits), Detail Sub Heading (Effective Date) and Detail.
The investment statement text editor enables you to create and edit the text that appears at the top, middle and bottom of the investment statements. It also enables you to add text to the various sections of the investment statement.
This option can be used in conjunction with the facility to add free-form text to benefit statements. Refer to
Auxiliary Activities
Document Customization
Customization
This facility enables you to set standard formatting options, e.g. font, font size, bold, underline, italics, etc.
The first time you access the editor, a blank text field will be presented. This field is used to input the text that must appear on the investment statement. A preview facility is available for you to see the layout of the text.
Click Text Editor below Investment Statements.
The Text editor screen will be displayed.
A summary of previous text created (if any) will be displayed.
The following columns are displayed:
- Date effective
- Date captured
- User ID
- Auth User ID
- Action
Add new text
To add new text, click NEW. Date input boxes will be displayed.
Enter the effective date of the investment statement, then click CREATE. The Text Editor screen will be displayed, providing text input boxes.
Note:
If text is being created for the first time, the text input box will be blank.
If previous text exists, the text input box will display the text that exists for the effective date immediately prior to the effective date now being created.
Text controls
Use the drop-down list at the top to select the section of the investment statement for which the text is being created or edited.
Whether or not the options available appear on the benefit statement are determined by the configuration of the investment statement format. Refer to
Scheme Launch Requirements
Additional Menu Options
Formats
The layout and format of the text is controlled by the options to the left of the text field.
Use the FONT drop-down list to select the required font, and enter the font size in the SIZE box alongside.
Place a tick in the CR box if you want the text to start on a new line.
Place a tick in any or all of the B, U and i boxes to set the font as bold (B), underlined (U) or italic (i).
Click 
to open another text field.
Text input
Type the first line of text, then click 
. The text, with all formatting options applied, will be displayed in a window below.
All formatting within the text field must be the same, but different formatting can be applied to each line.
To save the text, click SAVE.
Text deletion
To delete lines of text, highlight the text, then press the DELETE button on the keyboard. Click SAVE. Text fields that are completely blank will be removed from the screen. One blank text field will always remain on the screen.
Actions
Existing text can be displayed, edited and deleted. There is a facility to authorize text, and once authorized, it cannot be edited or deleted.
These actions are all initiated from the Text editor screen.
Display
To display text previously added, click Display in the Action column for the required effective date. The Text editor screen will be displayed.
This is for viewing only, and no updating can be done on this screen.
Edit
To edit text previously added, click Edit in the Action column for the required effective date. The Text editor screen will be displayed. Refer to Add new text above.
Authorize
To authorize text previously added, click Authorise in the Action column for the required effective date. A confirmation message will be displayed.
Click OK. The Text editor screen will be re-displayed, and the Edit, Authorise and Delete Actions will no longer be available.
Delete
To delete text previously added, click Delete in the Action column for the required effective date. A confirmation message will be displayed.
Click OK. The Text editor screen will be re-displayed, and the effective date just deleted will no longer appear.
