Setting up Calculations

Log in to the system from the Logon page.

 

Click processes, then click contributions.

 

Note:

This will only be available to users with PAYROLL or SUPER USER security access.

 

The Welcome screen will be displayed.

 

 

From the main menu on the top, select Payroll.  The Payroll screen will be displayed.

 

 

From the menu on top, select System Administration.  The Payroll sub-menu will be displayed on the left.

 

 

Click  alongside Global Data on the sub-menu.  Additional options will be displayed.

 

 

Select Calculations below Global Data on the menu on the left.

 

The Calculations screen will be displayed.

 

This screen displays a list of calculations that have already been set up on the system.

 

To create a new calculation, click ADD A CALCULATION

 

The Add a Calculation screen will be displayed.

 

 

Select an income and expense type from the drop-down box.  Some of the options available are listed below:

 

 

Once the income and expense type has been selected, provide a description for the calculation.

 

The input box above the keypad is used to create the calculation formulae.  Formulae can either be input manually or built by selecting values from the keypad and the drop-down box below it.

 

To build a formula, select the required formula type from the drop-down box, then click INSERT TYPE.  The value will be copied to the input box.  Use the keypad to as required to add other values.

 

Descriptions of the input fields on this screen appear below.

 

Sequence Number

This is used to sequence the calculation, i.e. at which point the calculation should be executed.

Is Exclusive

A tick in this box indicates that the calculation must be used on its own and cannot be used with other calculations.

Sum of Members?

A tick in this box indicates that the sum of all members' values will be combined in the remittance level calculation.

Generate Stored Procedure?

A tick in this box indicates that the stored procedure for this calculation to be applied to the database will be generated.

Use Stored Procedure?

A tick in this box indicates that the stored procedure should be used when performing this calculation.

Stored Procedure Applied?

This is used to indicate whether the stored procedure has been applied to the database.  This would automatically be completed once the stored procedure has been successfully applied to the database.

Stored Procedure Name

Displays the stored procedure name for identification purposes.

 

To generate a stored procedure for this calculation only, tick the Generate Stored procedure box.

 

Once the formula has been created, click SAVE.

 

The Edit a Calculation screen is displayed.

 

 

Click REBUILD CALCULATION.  The Calculations screen will be re-displayed.

 

This calculation will be rebuilt, and the stored procedure selected will be generated and e-mailed to the address specified in the global settings of the system (normally the system administrator).

 

Once the e-mail (containing the calculation stored procedure) has been received, the system administrator will forward this e-mail to the database administrator to apply to the specified database.

 

To generate all the calculations that currently exist and have them e-mailed in a single stored procedure to the intended recipient (defaults to the e-mail address specified under global settings), click REBUILD ALL CALCULATIONS

 

The Calculation Re-Build Settings screen will be displayed.