User Defined Formula

You can define User Defined Formula for

e.g.

    • [BasicSalary] / [DaysInMonth] / 8

    • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5

    • [12MthsAverageDailyRate] / 8 / 60 * 2

1. Examples for Rate Factor in OT Type

    • 150

    • [CurrentMonthHourlyRate]*1.5

    • [CurrentMonthDailyRate] / 8

    • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5

    • IIF([CurrentMonthHourlyRate]*1.5>80,[CurrentMonthHourlyRate]*1.5,80)

2. Examples for Rate Factor in Late Deduction Type

    • 50

    • [BasicSalary] / 30 / 9 / 60 * 10

3. Examples for Final Payment for Annual Leave Balance based on

    • [12MthsAverageDailyRate] (Statutory)

    • [AnnualLeaveDailyWages]

    • [CurrentMonthDailyRate]

    • [BasicSalary]/[DaysInMonth]

    • [BasicSalary]/[WorkdaysInMonth]

    • [BasicSalary]/30

    • IIF([IsEAO2007], [12MthsAverageDailyRate], [CurrentMonthDailyRate])

4. Examples for Payment in Lieu of Notice Daily Rate

    • [12MthsAverageDailyRate] (Statutory)

    • [CurrentMonthDailyRate]

    • [BasicSalary]/[DaysInMonth]

    • [BasicSalary]/[WorkdaysInMonth]

    • [BasicSalary]/30

5. Examples for Auto Bonus

    • [BonusAverageRegardedWages]

    • [BonusLastBasicWages]

    • [BonusAverageBasicWages]

    • ([BasicSalary]+[Allowance]) * 2

    • [BonusLastBasicWages] * [BonusEmploymentDays] / [BonusElapseDays]

6. Examples for Regular Payments in Employee Master or Employee Class

    • Working years Subsidy: IIF([YearsOfService]>=4,400,IIF([YearsOfService]>=3,300,IIF([YearsOfService]>=2,200,IIF([YearsOfService]>=1,100,0))))

    • Mid-Month Prepaid Allowance: IIF([IsMidMonthPayroll], 2000, 0)

    • Service-End Gratuities: IIF([IsFinalPayment], 20000,0)

    • Probation-End Bonus: IIF([IsProbationEndPayment], 500,0)

    • Travel Allowance (prorata on Join and Termination period): 1000 * [ProratedFactor]

    • Bonus after Probation: IIF([IsProbationPayment], 0,1000)

    • Attendance Bonus: IIF([IsFullAttendance],800,0)

    • Contract End Bonus: IIF([IsContractEndPayment],[BasicSalary],0)

    • Per Job wages (assumed With Unit Rate is turned on for this Pay Type) : UnitRate: 500

    • Birthday Bonus: IIF([IsBirthdayMonth],500,0)

    • Statutory Holiday Overtime Allowance: [OTDays4] * 50


The following characters/variables are acceptable in User Defined Formula

Internal

Numeric Variables (Wage related)

Numeric Variables (Statistical Information)

Numeric Variables (Bonus related)

Boolean Variables (for boolean_expression in IIF)

Keyword

1 Depending on the settings Payroll Considers Appointment History

2 Depending on the settings Daily Salary based on and works for Monthly, Daily, Hourly Rate Employees

3 Depending on the settings Daily Salary based on and How to calculate Hourly Rate from Daily Rate

4 "Working Days" definition

5 What is Average Monthly Wage

6 How to determine Daily Salary? for Monthly, Daily, Hourly Rate Employees

7 How to enable USD Employee Salary Package