New (System Reports General Commission)

To create a new report, select New from the sub-menu on the left. The Commission Report screen will be displayed.

To generate a report, capture details as follows:

From Date	The date from which commission must be displayed. The completion of this field is mandatory.
To Date	The date to which commission must be displayed. The completion of this field is mandatory.
Product	Select a Product from the drop-down list.
Intermediary	Click the LIST button to display the Intermediary Search screen and select an Intermediary. (For more details refer to Intermediary Search below).
Email	Capture the email address to which the report must be sent. The completion of this field is mandatory.

Intermediary support

The upper section of the screen displays a list of criteria to be captured in order to search for an Intermediary.

The lower section of the screen displays a list of Intermediaries for selection.

Intermediary Search

To search for an Intermediary, capture data in one or more of the following fields and click SEARCH:

- Surname

- Name

- ID Number

- Code

If an Intermediary is found that matches the data captured, the Intermediary will be displayed in the lower section of the screen.

To display all Intermediaries that match the data captured, click LIST ALL.

Intermediary

To select an Intermediary, click on an Intermediary displayed in the lower section of the screen. Click Prev / Next to scroll through the list of Intermediaries.

The selected Intermediary will be highlighted on the screen.

Once an Intermediary has been highlighted, click SELECT.

The system will return to the Commission Report screen and the Intermediary field will display the Intermediary selected.

Once all of the data has been captured on the Commission Report screen click GENERATE REPORT.

A message will confirm that the job has been submitted successfully:

Report job submitted successfully

Once the batch run that produces the report has completed, a confirmation e-mail message will be sent to the address that was provided on the Commission Report screen.

The report will be available for viewing.

Processing

When GENERATE REPORT is selected, the system will extract the information for the report based on the Product selected.

If the Product selected is INVESTMENT, LIVING ANNUITY, PRESERVATION FUND or RETIREMENT ANNUITY:

If the Product selected is INVESTMENT, LIVING ANNUITY, PRESERVATION FUND or RETIREMENT ANNUITY, the system will extract the data as follows:

The system will retrieve the BT’s in the Members’ CONTRIBUTION account with a Transaction Date greater than or equal to the From Date and less than or equal to the To Date for all Schemes.

The system will read the Accounting Activity Association with a Bulk Purpose Type of COMM REPORT and extract the BT’s in the Members’ CONTRIBUTION account with a Transaction Date greater than or equal to the report From Date and less than or equal to the report To Date, and with an Accounting Activity equal to the Accounting Activities found in the Accounting Activity Association.

The Accounting Activities that are associated to each other will be summed per Member.

Single Investment

The system will retrieve the BT’s with an Accounting Activity of CONTRIBUTION and with an Accounting Activity equal to any of the Accounting Activities associated to it via the Accounting Activity Association with a Bulk Purpose Type of COMM REPORT. If more than one BT is retrieved the amounts will be summed.

Initial Commission

The system will retrieve the BT’s with an Accounting Activity of COMMISSION and with an Accounting Activity equal to any of the Accounting Activities associated to it via the Accounting Activity Association with a Bulk Purpose Type of COMM REPORT. If more than one BT is retrieved the amounts will be summed.

Vat on Initial Commission

The system will retrieve the BT’s with an Accounting Activity of MEMVATONCOMM and with an Accounting Activity equal to any of the Accounting Activities associated to it via the Accounting Activity Association with a Bulk Purpose Type of COMM REPORT and for which Expense Type is equal to the Expense Type for B.

If more than one BT is retrieved the amounts will be summed.

Annual Commission

The system will retrieve the BT’s with an Accounting Activity of MEM COMM and with an Accounting Activity equal to any of the Accounting Activities associated to it via the Accounting Activity Association with a Bulk Purpose Type of COMM REPORT. If more than one BT is retrieved the amounts will be summed.

Vat on Annual Commission

Market Value

The Market value of the Member’s investments on which recurring commission was calculated.

If the Earning Allocation Basis for the Portfolio is UNITISED, the system will retrieve the unit balance on the Member’s IINVSTMEMUNIT account per Portfolio as at the Due Date of the MEM COMM BT retrieved in D. The system will retrieve the unit prices per portfolio as at the same date and calculate the market value per Portfolio.

If the Earning Allocation Basis for the Portfolio is BONUS, the system will retrieve the monetary balance on the Members’ INVESTMEMB account as at the Due Date of the MEM COMM BT.

The market values will be summed.

The following information will be extracted for each Membership for which BT’s are retrieved:

Field	Definition
Intermediary Group	Intermediary Group to which the Intermediary is linked
Intermediary	Intermediary to which the Membership is linked
Scheme Code
External Code	External Code on Client record for the Membership
Number	Membership Reference Number
Name	Surname if Natural Person or Name if Organisation Unit
Initials	If Natural Person
Investment Amount	Sum of CONTRIBUTION BT’S and BT’s with associated Accounting Activities
Initial Commission	Sum of COMMISSION BT’S and BT’s with associated Accounting Activities
Vat on Initial Commission	Sum of MEMVATONCOMM BT’S and BT’s with associated Accounting Activities
Market Value	Market Value as at the Due Date of the MEM COMM BT
Annual Commission	Sum of MEM COMM BT’S and BT’s with associated Accounting Activities
Vat on Annual Commission	Sum of MEMANNCOMVAT BT’S and BT’s with associated Accounting Activities
Total	Sum of all of the BT’s

If an Intermediary has been selected, the system will find all of the Memberships to which the Intermediary is linked and retrieve the BT’s for these Members.

If the Intermediary selected is an Intermediary Group, the system will find the Intermediaries linked to the Intermediary Group and then find the Memberships linked to these Intermediaries and retrieve the BT’s for these Members.

If there are no Intermediaries linked to the Intermediary Group, the system will find the Memberships linked to the Intermediary Group and retrieve the BT’s for these Members.

If the Product selected is ENDOWMENT:

If the Product selected is ENDOWMENT, the system will retrieve the BT’s in the Members’ CONTRIBUTION account with a Transaction Date greater than or equal to the From Date and less than or equal to the To Date.

The Accounting Activities that are associated to each other will be summed per Member and per Income Type and per Expense Type.

The following information will be extracted for each Membership for which BT’s are retrieved:

Field	Definition
Distribution Channel	Intermediary Group to which the Intermediary is linked
Agent	Intermediary to which the Membership is linked
Product	Scheme Code
Policy Number	Membership Reference Number
Name	Surname if Natural Person or Name if Organisation Unit
Initials	If Natural Person
Premium Type	Income Type of BT’s for which the Global Group Type is CONTRIBUTION
Premium	Sum of CONTRIBUTION BT’S
Distribution Fee Type	Expense Type of BT’s for which the Global Group Type is COMMISSION
Distribution Fee	Sum of COMMISSION BT’S per Income Type
Total Fee	Sum of all of the COMMISSION BT’s

The information will be sorted by Intermediary Group and then by Intermediary.

If the Intermediary is not linked to an Intermediary Group then the Intermediary Group column will be left as blank and these Intermediaries will be listed after the Intermediary Groups.