Dear Team,

System deducts incorrect SRL (FJ Social Responsibility Tax) & ECAL (Environment and Climate Adaptation), based on the following scenario:

1. Created an employee: E069
   • Start Date: 01/01/2018
   • PayRATE: $400,000
   • Monthly Employee
   • SRL & ECAL are tagged
2. Created standard pay:
   • Correct deduction of PAYE & XXXXX
3. Created first pay:
   • Pay Date: 31/01/2018
   • Pay Team: MT
   • Paid the normal 160 hours
   • Paid commission using “BCOMM” paycode of $6447.67
   • PAYE, SRL & ECAL calculated corrected – system amount matched with the FRCA Formula 6 Excel Sheet
   • Update pay
4. Management decided to do a backpay of $16666.67:
   • On menu 311-2, changed the “MT” date to 31/01/2018
   • Created a “Special” Pay:
     1. Pay Date: 31/01/2018
     2. Pay Team: MT
     3. Pay Type: Special
   •  Added “ABPAY” of $16666.67
   • Compared the PAYE Reconciliation Report with the FRCA Formula 6 Excel Sheet:
     1. PAYE – correct
     2. SRL – Incorrect
     3. ECAL – Incorrect

Refer to Table Below:

       5.  Update this pay, Performed "End of Month" and create the next normal pay. The PAYE is correctly calculated for this normal pay however, the SRL and ECAL are still incorrectly calculated.

Refer to Table Below:

Environment Details:

1. QA: 4
2. Database: CASE9237_LINKSOFT 
3. V: 933
   
   
   

Note: Attached is the FRCA Formula 6 Excel Sheet. Refer to the Monthly sheet. Requesting for an update on version 933.

Kindly take a look.

Regards
Aarti

Dear Sanjay,

Please review this case,

Regards
Aarti

Hi Aarti, this functionality is by design. We will need to review this in the development meeting if this needs to change. Can you get Vineet or Rashna to bring this to the next development meeting?.

Regards
Sanjay

Dear Vineet,

Please take this case to the next development meeting.

Regards
Aarti

Development meeting - 19/04/18. 

Vineet is saying that there are more issues relating to this case relating to Normal Pay tax calculations.

Case review by Vineet in prep for next development meeting.

Hi Alvis, Address the issue reported in this case and we will attend to the other issues when Vineet logs the new case.

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

1. Changed the tax calculation function to calculate remaining pays when a normal pay has been completed and special pay is made on the same date.

System test completed.

Verified the following:

1. Configured payroll database as per details in case header.
2. Created pay 1 dated 31/01/2018 and verified tax. Failed. Resolved issue in beta2.
3. Created special pay dated 31/01/2018 and verified tax. Tax figures matched after calculation was resolved in 2. above.
4. Created Pay 2 dated 28/02/2018 and verified tax. Tax figures match the excel sheet provided.

regards
Alvis

System test completed.

Verified the following:

1. Configured payroll database as per details in case header.
2. Created pay 1 dated 31/01/2018 and verified tax. - Pass
3. Created special pay dated 31/01/2018 and verified tax. Tax figures matched. - Pass
4. Created Pay 2 dated 28/02/2018 and verified tax. Tax figures match the excel sheet provided. - Pass

regards
Alvis

Hi Alvis, 

I have tested the case. Below is the results.

Test Environment

• Version 9400 Beta 2
• Database - LINKSOFT on QA1
• Application on QA1.
• OS - Windows 7.
• Backup of the database is placed at C:\Temp on QA1. Backup Name: LINKSOFTCASE9237.bak

Test Plan.

• Employee ID - E073.
• Start Date: 01/01/2018
• PayRATE: $400,000
• Monthly Employee
• SRL & ECAL are tagged

Table 1 : Expected Results

Figure 1: PAYE Report

Hi Rashna,

I have tested this and the tax figures are calculating correctly. 

I checked your database and the tax rates used is different from the demo setup. Can you manually calculate the tax value and confirm the values match with your payroll tax setup.

regards
Alvis

We have also increased the width of columns in the "paye reconciliation report" to allow for 7 digits including 2dp for Bonus and Other field.

can you confirm all other fields are showing data for 7 digits?

Hi Team, 

This case has been successfully tested. System calculated PAYE matched the FRCS calculations.

Test Environment

• Version 9400 Beta 2
• Database - LINKSOFT9237 on QA1
• Application on QA1.
• OS - Windows 7.

Test Plan.

• Employee ID - E073.
• Start Date: 01/01/2018
• PayRATE: $400,000
• Monthly Employee
• SRL & ECAL are tagged

Table 1 : Result Analysis.

Figure 1: PAYE Report

Figure 2: FRCS Calculation.

This case is now closed.

Thanks