Conversion (Debit Order Umbrella Fund)

There are various steps to the conversion process:

-        a file is uploaded to the application server

-        the file is read into the conversion tables

-        the file is authorized

-        MEMBER.BAT is initiated (if applicable)

From the Products menu, click  alongside Conversion on the sub-menu on the left.  Additional options will be displayed.

Load file

Click Load File below Conversion on the sub-menu on the left.

The JU3EA Batch Job will be started and the following message will be displayed on the Umbrella Batch Selection screen.

Batch (JU3EA) started.

Monitor the log for completion of the batch.

The file will be read into the conversion tables.  The progress of the batch job can be monitored on the log.

Authorise file

Files relating to the organization structure (i.e. broker, participating employers, pay centres) are authorized here.

Click Authorise File below Conversion.  The JU3EB Batch Job will be started and the following message will be displayed on the Umbrella Batch Selection screen.

Batch (JU3EB) started.

Monitor the log for completion of the batch.

The file will be authorized.  The progress of the batch job can be monitored on the log.

Authorise bank and address details

Files relating to bank and address details are authorized here.

Click Authorise Bank and Address Details below Conversion on the sub-on the left.  The JU3AA Batch Job will be started and the following message will be displayed on the Umbrella Batch Selection screen.

Batch (JU3AA) started.

Monitor the log for completion of the batch.

The file will be authorized.  The progress of the batch job can be monitored on the log.

Member data

If member data is being loaded, MEMBER.BAT must be initiated.  Refer to

Auxiliary Activities

Submitting batch Jobs

Addresses

This report is available for viewing once the files have been loaded.

Click Addresses below Conversion on the sub-on the left.  The Umbrella Address Report screen will be displayed.

The following columns are displayed:

-        Organization

-        Address lines 1 - 5

-        Postal code

-        E-mail address

Bank details

Click Bank Details below Conversion on the sub-menu on the left.  The Umbrella Bank Account Report screen will be displayed.

The following columns are displayed:

-        Organization

-        Bank account number

-        Account holder

-        Account type

-        Bank branch code

Participating employer

Select Participating Employer below Conversion on the sub-menu on the left.  The Umbrella Participating Employer Report screen will be displayed.

The following columns are displayed:

-        Organization name

-        Organization code

-        Cheque or EFT

-        Active or suspended

-        Collection effected

-        Collection end

-        Collection LPD

-        Invoiced

-        Intermediary / Intermediary GP

-        COMM membership group

-        Income type

Pay centre

Select Paycentre below Conversion on the sub-menu on the left.  The Umbrella Paycentre Report screen will be displayed.

The following columns are displayed:

-        Organization name

-        Organization code

-        Cheque or EFT

-        Active or suspended

-        Collection effected

-        Collection end

-        Collection LPD

-        Invoiced

-        Intermediary / Intermediary GP

-        COMM membership group

-        Income type

Upload files

Select Upload Files below Conversion on the sub-menu on the left.  A screen for the file upload will be displayed.

Click BROWSE.  This will allow you to search the available drives (user network or local) for the file to be loaded.

Highlight the required file, then click OPEN.

The file name will appear in the box.  Click SUBMIT FILE.  The file will be moved to the application server.