Merge Members Accounting Activities and Associations

Purpose

Where Members of a scheme are duplicated because they leave and then later rejoin with slightly different details, the system can identify these members and allow an authorized user to merge the duplicated record(s) with the membership number for the oldest contributions. 

All accounting balances i.e. investment and contribution balances, will be transferred automatically to the one membership number unless an exit has commenced.

 

For existing members on the system that could be possible duplicates, the members can be merged.  All individual investment and contribution transactions will be moved. 

A batch job will run and create a pre-authorised record.  Once authorized, all accounting transactions will be reversed from the new membership number to the oldest membership number via the MERGE MEMBERS accounting process using the MERGEMEMREV and MERGEMEMNEW bulk purpose update.  Once the accounting has moved, the membership status of the old membership number/s will be set to MERGED.

 

For more information, refer to

Supplements

Processes

Merge Members

 

For more information, refer to

Clients

Merge Members

 

For more details refer to Member Merge in Data Capture Summary under

Processes

Contributions

Payroll

Data Capture

 

For more information, refer to Membership Merge and Member Extract under

Reports

Member

 

Accounting activities and associations

The following Accounting Activities must be setup for the Accounting Process of MERGE MEMBERS:

 

ACCOUNTING ACTIVITY

STAKEHOLDER

DR ACCOUNT

CR ACCOUNT

MGCONTRIB

MEMBER

MEM DEPOSIT

CONTRIBUTION

MGCONTRIBNG

MEMBER

CONTRIBUTION

MEM DEPOSIT

MGCONINV

MEMBER

INVESTMEMB

MEM DEPOSIT

MGCONINVNG

MEMBER

MEM DEPOSIT

INVESTMEMB

MGCONDED

MEMBER

CONTRIBUTION

MEMDEPOSIT

MGCONDEDREV

MEMBER

MEM DEPOSIT

CONTRIBUTION

MGBONUS

MEMBER

INVESTMEMB

MEMBONUS

MGBONUSNG

MEMBER

MEMBONUS

INVESTMEMB

MGUNITSATION

MEMBER

INVSTMEMUNIT

INVESTMEMB

MGUNITISNEG

MEMBER

INVESTMEMB

INVSTMEMUNIT

 

The following Accounting Activity Associations must be setup for the Bulk Purpose Types of MERGEMEMNEW and MERGEMEMRE as per table below:

 

 

 

ASSOCIATION

PROCESS

ACCOUNTING ACTIVITY

PROCESS

ACCOUNTING ACTIVITY

INCOME

CONTRBNEG

MERGE MEMBERS

MGCONTRIBNG

INCOME

SFCONTRB

MERGE MEMBERS

MGCONTRIB

INCOME

SFCONINVREB

MERGE MEMBERS

MGCONINVNG

INCOME

SFCONINV

MERGE MEMBERS

MGCONINV

INCOME

SFCONDEDREV

MERGE MEMBERS

MGCONDEDREV

INCOME

SFCONDED

MERGE MEMBERS

MGCONDED

BONUS ALLOCATION

MEMBONUSNEG

MERGE MEMBERS

MGBONUSNG

BONUS ALLOCATION

MEMBERBONUS

MERGE MEMBERS

MGBONUS

UNITISATION

UNITISATNEG

MERGE MEMBERS

MGUNITISNEG

UNITISATION

UNITISATION

MERGE MEMBERS

MGUNITSATION

MANUAL INITIATE

SFCONTRBREV

MERGE MEMBERS

MGCONTRIBNG

MANUAL INITIATE

SFCONTRB

MERGE MEMBERS

MGCONTRIB

MANUAL INITIATE

SFCONINVREV

MERGE MEMBERS

MGCONINVNG

MANUAL INITIATE

SFCONINV

MERGE MEMBERS

MGCONINV

MANUAL INITIATE

SFCONDEDREV

MERGE MEMBERS

MGCONDEDREV

MANUAL INITIATE

SFCONDED

MERGE MEMBERS

MGCONDED

 

The following Accounting Activities must be associated to MERGE REV:

 

 

 

ASSOCIATION

PROCESS

ACCOUNTING ACTIVITY

PROCESS

ACCOUNTING ACTIVITY

INCOME

CONTRBNEG

MERGE MEMBERS

MGCONTRIB

INCOME

SFCONTRB

MERGE MEMBERS

MGCONTRIBNG

INCOME

SFCONINVREB

MERGE MEMBERS

MGCONINV

INCOME

SFCONINV

MERGE MEMBERS

MGCONINVNG

INCOME

SFCONDEDREV

MERGE MEMBERS

MGCONDED

INCOME

SFCONDED

MERGE MEMBERS

MGCONDEDREV

BONUS ALLOCATION

MEMBONUSNEG

MERGE MEMBERS

MGBONUS

BONUS ALLOCATION

MEMBERBONUS

MERGE MEMBERS

MGBONUSNG

UNITISATION

UNITISATNEG

MERGE MEMBERS

MGUNITSATION

UNITISATION

UNITISATION

MERGE MEMBERS

MGUNITISNEG

MANUAL INITIATE

SFCONTRBREV

MERGE MEMBERS

MGCONTRIB

MANUAL INITIATE

SFCONTRB

MERGE MEMBERS

MGCONTRIBNG

MANUAL INITIATE

SFCONINVREV

MERGE MEMBERS

MGCONINV

MANUAL INITIATE

SFCONINV

MERGE MEMBERS

MGCONINVNG

MANUAL INITIATE

SFCONDEDREV

MERGE MEMBERS

MGCONDED

MANUAL INITIATE

SFCONDED

MERGE MEMBERS

MGCONDEDREV

 

When Bonus Transactions are reversed and processed for the new record, the Bonus Indicator will also be moved across so that the bonus program does not calculate interest on the transactions again.