When Gross Pay is changed, ECAL and SRL calculations are incorrect. In scenario 1 below, there are no changes and the tax calculations are correct.

However in Scenario 2, when we reduce ANHRS to 24 and Add 16 hrs of AINC, SRL and ECAL are not calculated. See figure 2.

This is not an issue when we replace AINC with AAL

Scenario 1: Standard Process - All Calculations are correct

1. Employee EMP0001 is on a Salary Scale of $350,000
2. The employee is on Standard Pay - Pay Frequency with 40 Hours per Pay 

1. Employee EMP0002 is on a Salary Scale of $350,000
2. The employee is Paid 24 Hours as Normal Pay
3. The employee is Paid 16 Hours as Incentive Payment (AINC) due to getting injury sustained at work and missing 2 Days

Figure 2 - SRL and ECAL is missing

Scenario 3 - Reduce ANHRS to 24 and Add 16 hrs of AAL - This is CORRECT

Setup Details

Meeting with Vineshwar and Sanjay:

1. Rewrite the case header to explain the issue clearly
2. The issue is that the Tax Bracket is based on ANHRS, not on the Component type "Gross". This needs to be addressed as it is handled for AAL, but not other Components with type "Gross"
3. Sanjay to investigate the issue further in Development 

Transferring this case to DEVELOPMENT.

1. The change will be available in versions: 14.00 and 13.40 PATCH

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

1. Changed Gross Pay Determination to base on the Component Type instead of Hours Paycode

3. Affected Areas:

1. Pay Calculations

4. The issue was caused by:

1. Design issue

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

UAT Notes:

1. Please test All Fiji and PNG Pay Calculations. I have applied the change to: https://www.linktechnologies.com.au/DEMO-LinkSOFT-EDGE 

Environment Details

1. OS version: Win11
2. Application version: 14.00
3. Setup on:
   1. Server: LinkQA4
   2. Database: LinkSOFT
   3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
4. Login Details: Standard username and password for user "admin"

Next Step: Closure

1. The Calculations on Scenario 2 is Correct
   1. When Normal Hours is reduced, SRL & ECAL will not be calculated as the Standard Pay has reduced
   2. Normal Hours - 4038.46 x 52 Pay = 209,999.92. This is below the SRL & ECAL Tax Threshold
   3. PAYE is correct as Incentive Payment is treated under the Bonus column and thus included in Tax Calculation
2. The Calculations on Scenario 3 is Correct
   1. When Normal Hours is reduced, Annual Leave makes up the Hours as the employee was on Leave
3. We will need to reverse this change

Hi Vineshwar, I have reversed this change. Patch for 13.40 is: LinkSOFT_13.40.0728.zip

Can you put your test results in this case and assign the case back to me?

Please test this function thoroughly.

1. Employee T0001 is on a Salary Scale of $350,000
2. The employee is on Standard Pay - Pay Frequency with 160 Hours per Pay
3. Pay is processed for February 2022 on a monthly basis

Figure 1 - Standard Process - All Calculations are Correct

Figure 2 - FRCS Tax Calculation Sheet


Scenario 2 - Standard Pay ANHRS 160 Hrs with Additional 5 Hrs Time & Half (CORRECT)

1. Employee T0001 is on a Salary Scale of $350,000
2. The employee is on Standard Pay - Pay Frequency with 160 Hours per Pay
3. Pay is processed for February 2022 on a monthly basis
4. The employee is Paid 160 Hrs as Normal Pay
5. The employee is Paid 5 Hrs as Time & Half

Figure 3 - Normal Hours plus Time & Half


Figure 4 - FRCS Tax Calculation Sheet


Note

1. All Calculations are correct
2. Time & Half is treated as Additional from your Base Pay

Scenario 3 - Normal Hours is reduced to 140 Hrs (CORRECT)

1. Employee T0001 is on a Salary Scale of $350,000
2. The employee is on Standard Pay - Pay Frequency with 160 Hours per Pay
3. Pay is processed for February 2022 on a monthly basis
4. The employee is Paid 140 Hrs as Normal Pay

Figure 5 - Normal Hours reduced


Figure 6 - FRCS Tax Calculation Sheet

Note

1. All Calculations are correct
2. SRL and ECAL are not calculated because the Base Pay is reduced. As a result, SRL and ECAL are making a recovery

Scenario 4 - Normal Hours is reduced to 140 Hrs with an Additional 5 Hrs Time & Half (CORRECT)

1. Employee T0001 is on a Salary Scale of $350,000
2. The employee is on Standard Pay - Pay Frequency with 160 Hours per Pay
3. Pay is processed for February 2022 on a monthly basis
4. The employee is Paid 140 Hrs as Normal Pay
5. The employee is Paid 10 Hrs as Time & Half

Figure 7 - Normal Hours reduced plus Time & Half


Figure 8 - FRCS Tax Calculation Sheet

Note

1. All Calculations are correct
2. Time & Half is treated as Additional from your Base Pay

Environment Details

1. OS version: Win 10
2. Application version: 13.40.0728.GA
3. Setup on:
   • Server: LINK-VINESHWAR
   • Database: LinkSOFT
   • LinkSOFT URL: HTTP://localhost/LinkSOFT
   • Login Details: Standard username and password for user "admin"

Regards
Vineshwar