The following parameters must be set up:
Global data
Accounting
Annuity payment run
Set up the following parameters and values:
Batch Parameters:
- Payment File
- Rejection/redirections File
- Email Address
Payment Type
Bank Interface Type
Batch Parameter
Payment File (Multidata incoming)
Set up a batch parameter called MULTIDATA IN with the name of the file and the details of the directory where the Multidata payments file must be placed.
The following is the format of the file name:
SEB INSTALMENTS\INCOMING\TX128926.KOS. DATE&TIMESTAMP.TXT
The components of the file name are as follows:
|
128926 |
Company Code |
|
KOS |
|
|
DATE&TIMESTAMP |
Date and time that the file is created in format CCYYMMDDHHMMSS |
The file must be placed on the FTP server FTP.sanlam.co.za in the folder defined in the MULTIDATA IN batch parameter.
Note:
INCOMING indicates from Multidata’s perspective that this is a payment file.
Rejection/redirections File (Multidata outgoing)
Set up a batch parameter MULTIDATA OUT with the name of the file and the details of the directory from where the Multidata rejections / redirections file must be fetched.
The following is the format of the file name:
SEB INSTALMENTS\OUTGOING\TX128926.DATE&TIMESTAMP.RDS
The file will be placed on the FTP server FTP.sanlam.co.za in the folder defined in the MULTIDATA OUT batch parameter.
Note:
OUTGOING indicates from Multidata’s perspective that this is a rejection file.
Email Address
Set up a batch parameter MULTIDATA MAIL with the email address to which an email must be sent when the payment file has been created and placed on the FTP server. The address to be used is:
Payment Type
Add the value of NO PAYMENT to the UDPV Object Payment Type.
Bank Interface Type
Add the value of MULTIDATA to the UDPV Object Bank Interface Type.
Set up the following in respect of:
Annuity
EFT Rule
Deductions
Alexander Forbes & ABSA Schemes
Annuity
The Payment Method on the JU4DD Membership Payment Details screen must be BANK TRANSFER.
The MEMPENPAID Accounting Activity must be set up with the Money Movement Indicator selected.
The FNDPENPAID Accounting Activity must be set up with the Money Movement Indicator not selected.
EFT Rule
Select the Interface Type of MULTIDATA on the Bank Account to be used for the payments, (Sanlam Employee Benefits 1017102342).
Note:
The individual annuity payments are paid out of the Multidata bank account and the total is then paid from the Sanlam Employee Benefits bank account into the Multidata bank account. However, for the purposes of defining the type of EFT file that must be created, the Sanlam Employee Benefits bank account is used and linked to the Accounting Activity via the EFT Rule.
Set up the EFT Rule for the MPENPAIDBTRF Accounting Activity with the Sanlam Employee Benefits bank account (1017102342).
Deductions
The Payment Method for deductions to be paid to external third parties must be BANK TRANSFER
The Payment Method for deductions to be transferred to internal divisions must be JOURNAL ENTRY.
The FNDPENDED Accounting Activity must be set up with the Money Movement Indicator selected.
The FNDPENDEDJNL Accounting Activity must be set up with the Money Movement Indicator not selected.
Alexander Forbes & ABSA Schemes
The annuitants for Schemes administered by Alexander Forbes (AF) and ABSA are insured with Sanlam, but the annuitants are paid by Alexander Forbes and ABSA respectively.
Sanlam process the individual annuitants in a monthly annuity payment run and so know how much needs to be paid over to AF and ABSA each month.
The Membership Payment Details for these schemes must be set up with a Payment Method of NO PAYMENT.
In the Annuity Payment run, if the Payment Method on the JU4DD Membership Payment Detail is MULTIDATA, processing will take place in the same way as for BANK TRANSFER.
If the Payment Method field on the JU4DD Membership Payment Details screen is NO PAYMENT, the Business Transaction will be created with the following Accounting Activity in place of the MEMPENPAID Accounting Activity:
|
Process |
Accounting Activity |
Stakeholder |
DR Account |
CR Account |
|
ANNUITY PAYMENT |
MEMPENNOPM |
MEMBER |
DR PENSIONPAID |
CR MEM DEPOSIT |
The Money Movement Indicator on the Accounting Activity must be set to N.
In all other respects, process in the same way as for Payment Method BANK TRANSFER i.e. sum the Member BT’s and create the Fund BT with the Accounting Activity FNDPENPAID for the total.