Subject: | Annual Salary is rounded up on the Payslip |
Summary: | 1. Problem DetailsAnnual Salary is rounded up on the Payslip Details of setup; - Created Employee E003
- Pay Rate: 35,250.75
- Created Pay: 495
- Generated Payslip which shows the Annual Salary as 35,251.00
2. Error Message (screenshot of the error) 3. Environment Details
- URL: https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
- Version: 15.10.231218.GA
- Company: 1001
|
Audit Notes: | Edited by sanjay on 26/03/24 16:55. Edited by sanjay on 14/03/24 11:53. Edited by sanjay on 14/03/24 09:32. Edited by sanjay on 06/03/24 18:51. Edited by sanjay on 06/03/24 18:50. Edited by vineshwar on 01/03/24 17:23. |
27 Feb 2024 | 10:07AM Comment 1 by Sitla (Edge Business Solutions) ETC was changed from 20/02/2024 to 07/03/2024 |
27 Feb 2024 | 10:08AM Comment 2 by Sitla (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 04-03-2024 10:07 AM Notes: ETC extended from: 07/03/2024 to 04/03/2024 |
| Hi Vineshwar, Can get a meeting sorted with Sanjay. Sitla. |
|
06 Mar 2024 | 11:21AM Comment 3 by Sanjay (Link Technologies) Case L13009 added to project 15.20 |
06 Mar 2024 | 06:42PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-03-2024 12:15 AM Time Taken: 6.00 Notes: Edited by sanjay on 11/03/24 10:17. Edited by sanjay on 08/03/24 10:05. Edited by sanjay on 08/03/24 09:42. ETC extended from: 01/03/2024 to 07/03/2024 |
| Hi Vineshwar, the cause is that we must round Deductions and Payments to 2DP, which causes a few cents off during rounding. In this example, Employee E003 has a Pay Rate = 16.9475, Pay Frequency = 26, Hours per pay = 80. The Annual Salar is calculated at 35250.80 which was rounded to 0 DP giving 35251.00 I have changed the "Salary Display" in the Pay Slip to round to 2DP in the report giving 35250.80.
Here is the Salary Design: - We start with the Salary from the "Pay Rate" screen at the time the Pay is being processed
- The system then calculates the "Hourly Rate" based on "Hours Per Day" and "Pay Frequency"
- The "Hourly Rate" is then used to process the pay. Keep in mind here that we must round all amounts to "2 Decimal Place" to make deductions and payments. For example, if a deduction or Banking is calculated at $100.1255, we can only use $100.13. Therefore, the Salary for the employee for a particular pay will not be exactly what is in the "Pay Rate", there will be a slight difference (usually a few cents)
- We can show the Salary without taking into account the rounding for Deductions and Payments; however this would be misleading as it will not match the actual amounts Deducted or Paid.
The changes have been applied to the Demo Environments. Please verify and get back with feedback. Thanks. |
|
08 Mar 2024 | 09:43AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-03-2024 03:42 PM Time Taken: 1.00 Notes: ETC extended from: 07/03/2024 to 08/03/2024 |
| *** Skype Message *** 2024/03/07 3:15 PM @Vineshwar, please test case L13009 when you get a chance
|
|
11 Mar 2024 | 10:19AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-03-2024 04:18 PM Time Taken: 1.00 Notes: ETC extended from: 08/03/2024 to 11/03/2024 |
| Hi guys, The changes have been applied to the Demo Environments. Please verify and get back with feedback. Thanks. |
|
11 Mar 2024 | 03:34PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-03-2024 03:15 PM Time Taken: 4.00 Notes: ETC extended from: 11/03/2024 to 11/03/2024 |
| Hi guys, Since we cannot get this case tested and passed by the initiator, we have reversed the change and will consider this in a future release. |
|
14 Mar 2024 | 09:32AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-03-2024 03:31 PM Notes: ETC extended from: 11/03/2024 to 14/03/2024 |
| Moved to version 15.30 |
|
14 Mar 2024 | 09:32AM Comment 9 by Sanjay (Link Technologies) Case L13009 added to project 15.30 |
18 Mar 2024 | 09:25AM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-03-2024 03:25 PM Notes: ETC extended from: 14/03/2024 to 22/03/2024 |
| Further investigation in progress |
|
19 Mar 2024 | 03:07PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-03-2024 08:46 PM Time Taken: 2.00 |
| Teams discussion with Vineshwar and Sanjay Discussion notes: - Refer to comment 4
- Agreed that 4DP is required to display on the LinkSOFT Forms, and to allow users to manually calculate the rate for Allowances/Deductions/Banking amounts
- If we increase this to 6DP, we can only show the first 4DP on the screens, resulting in confusion on how the amounts have been rounded
- We agreed that calculating the Rate to 4DP was acceptable
- The salary in the payslip, is calculated using the 4DP rate calculated during pay processing,. This is rounded to 0DP as we expect annual salaries to be in whole dollars, example: 50,123 instead of 50,123.25
- Similar design comcept aplied to Hourly Rates which can be rounded to the nearest cent. Example, an hourly rate of 25.29 is acceptable, while an hourly rate of 15.2912 will cause slight rounding differences
Agreed to close the case as further inestigation is no longer required. |
|
19 Mar 2024 | 03:08PM Comment 12 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-03-2024 09:07 PM |
| Closing case - refer to comment 11 |
|