| Subject: | Pay Rate change recalculates Leave Liability and sends the difference into FMIS Integration |
| Summary: | When the pay rate is changed, we do not want the leave liability to be calculated and sent to FMIS for some leave codes. For example, for Sick Leave (ASL), and Bereavement Leave (BL3), the difference should not be sent to Liability, however, for Annual Leave (AAL), we want the liability to be sent.
Setup Details- Link: https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
- Version: 14.00.0729.GA
Steps to Replicate- Created Employee: EMP0001
- Pay Rate: $5 Hourly
- Pay Team: Weekly
- Allocated Leaves
- AAL10: Annual Leave
- BL3: Bereavement Leave
- ASL: Sick Leave
- Created Pay No: 486
- Changed Pay Rate to $6
- Created Pay No: 493. This creates Leave Liability Adjustment for;
- AAL10 - Correct
- BL3 - Incorrect
- ASL - Incorrect
|
| Audit Notes: | Edited by sanjay on 18/04/23 11:33. Edited by sanjay on 04/04/23 10:54. Edited by sanjay on 30/03/23 16:01. Edited by sanjay on 30/03/23 15:47. Edited by sanjay on 30/03/23 09:47. Edited by sanjay on 20/03/23 16:39. Edited by sanjay on 20/03/23 16:39. Edited by sanjay on 09/03/23 17:31. Edited by sanjay on 09/03/23 17:30. Edited by sanjay on 07/03/23 08:03. Edited by sanjay on 17/11/22 14:38. Edited by sanjay on 16/11/22 14:57. Edited by sanjay on 13/10/22 10:54. Edited by sanjay on 07/10/22 14:50. Edited by sanjay on 07/10/22 14:47. Edited by sanjay on 06/09/22 14:39. Edited by sanjay on 22/08/22 16:30. Edited by sanjay on 15/08/22 10:46. Edited by sanjay on 15/08/22 09:33. |
| 11 Aug 2022 | 01:32PM Comment 1 by Sanjay (Link Technologies) This comment has been removed |
| 12 Aug 2022 | 08:42AM Comment 2 by Vineshwar Prasad (Edge Business Solutions) This comment has been removed |
| 15 Aug 2022 | 09:33AM Comment 3 by Sanjay (Link Technologies) Case L12772 added to project 14.10 |
| 15 Aug 2022 | 09:33AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 17/08/2022 to 19/08/2022 |
| 06 Sep 2022 | 02:39PM Comment 5 by Sanjay (Link Technologies) Case L12772 added to project 14.20 |
| 13 Oct 2022 | 10:54AM Comment 6 by Sanjay (Link Technologies) Case L12772 added to project Review |
| 16 Nov 2022 | 02:56PM Comment 7 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 24-11-2022 02:48 PM |
| Teams - Sitla, Vineshwar, Navneet and Sanjay - Agreed to do teams and go through this design to work out how to make this configurable. Vineshwar to send a meeting request. |
|
| 16 Nov 2022 | 02:57PM Comment 8 by Sanjay (Link Technologies) ETC was changed from 12/11/2022 to 30/11/2022 |
| 17 Nov 2022 | 02:54PM Comment 9 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 24-11-2022 02:38 PM Time Taken: 3.00 |
| Sitla - The previous version was working differently. See version 12.42 which was working. Vineshwar - FICAC have a plugin - we do not know if this is currently activated or installed The issue is that when an employee Rate is changed, we do not want the Rate Change difference to go to FMIS for selected leave types. Next step: - Do not use any Plugins or customisations. - Setup 12.42. Install files are in QA3 d:\Temp. Setup an employee as explained in "Steps to replicate" - Vineshwar
- Setup 14.33. Setup an employee as explained in "Steps to replicate" - Vineshwar
- Perform a rate change and close pay. We should be able to see 12.42 JL Journal and 14.30 Journal and spot the difference. - Vineshwar
- Identity which leave types is affected by: - Vineshwar/Sitla/Sanjay
- Which Leaves should go or not go on Leave Accrual
- Which Leaves should go or not go on Leave Rollover
- Which Leaves should go or not go on Leave Adjustment
- Which Leaves should go or not go on Leave Allocation
- Which Leaves should go or not go on Rate Change
- Analyse the difference is the two versions - Sanjay
- Determine how to configure this to enforce rule 4 above - Sanjay
|
|
| 25 Jan 2023 | 10:01AM Comment 10 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 02-02-2023 09:58 AM Time Taken: 1.00 Notes: ETC extended from: 30/11/2022 to 02/02/2023 |
| Teams - Sitla and Sanjay - Setup 12.42 and confirm the issue is there
- Setup 14.30 and verify
- Sitla says it is a bug in 12.42 and has been corrected in 14.30
- Sanjay says we can add a config to allow this if needed
|
|
| 01 Feb 2023 | 02:38PM Comment 11 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 09-02-2023 02:31 PM Time Taken: 3.00 |
| Version 12.30 and 14.40 show similar results therefore we could not reproduce the Issue |
|
| 01 Feb 2023 | 02:43PM Comment 12 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-02-2023 02:38 PM Time Taken: 1.00 Notes: Edited by sanjay on 30/03/23 16:00. ETC extended from: 02/02/2023 to 09/02/2023 |
| Teams - Sanjay, Sitla & Vineshwar- By default, all Leave Transactions will flow into Integration
|
|
| 07 Mar 2023 | 08:03AM Comment 13 by Sanjay (Link Technologies) Case L12772 added to project 14.60 |
| 09 Mar 2023 | 05:31PM Comment 14 by Sanjay (Link Technologies) ETC was changed from 09/02/2023 to 31/03/2023 |
| 20 Mar 2023 | 04:39PM Comment 15 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 23-03-2023 04:38 PM |
| Moved to 14.70 due to urgent release with bug fixes in 14.50 |
|
| 20 Mar 2023 | 04:39PM Comment 16 by Sanjay (Link Technologies) Case L12772 added to project 14.70 |
| 30 Mar 2023 | 03:47PM Comment 17 by Sanjay (Link Technologies) ETC was changed from 31/03/2023 to 28/04/2023 |
| 30 Mar 2023 | 03:49PM Comment 18 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 06-04-2023 03:47 PM Time Taken: 3.00 Notes: Edited by sanjay on 30/03/23 16:01. |
| I have updated the case header to explain the problem better. I have also removed the comments that do not support the justification for change. |
|
| 30 Mar 2023 | 03:58PM Comment 19 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 07-04-2023 03:49 PM Time Taken: 6.00 Notes: ETC extended from: 28/04/2023 to 07/04/2023 |
| Hi Guys, I had a look at Quickbooks Payroll as an example to see how Employee Rate change is handled. In general, when an employee's rate changes, it affects the liability because it changes the amount of money that the employer owes to the employee is based on the New Rate. Therefore, by accounting standards, we must adjust the liability, otherwise, when the employee takes the leave, it will not balance in GL. If we choose not to update the leave liability when the rate changes, we have to Expense this difference. Either way, a GL entry is required. Can you elaborate on why you want to exclude the Pay Rate change? Is there legislation in Fii that says you can pay the employee based on the OLD rate? If so, please send me the reference documents so I can justify this. Next Steps: - Sitla, Vineshwar to provide references to the Rae Change omission from GL Transactions. Please attach hs by 7th March which is the cut-off date for V14.70
- Sanjay to Review and meet with EBD if required before working out how to handle this omission from GL Integration
|
|
| 04 Apr 2023 | 05:00PM Comment 20 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2023 04:53 PM Time Taken: 1.00 Notes: Edited by vineshwar on 04/04/23 17:00. ETC extended from: 07/04/2023 to 07/04/2023 |
| Hi Sanjay, yes you are correct.
However, only Annual Leave Liability should be affected when the Rate is changed. As Sick Leave, Bereavement Leave, and Other Leaves type are not treated as a Liability.
Sick Leave, Bereavement Leave, and Other Leaves type are only Expensed when they are taken.
We have stated the same in the case header. |
|
| 11 Apr 2023 | 02:51PM Comment 21 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 14-04-2023 02:34 PM Time Taken: 1.00 |
| Teams Discussion - Sitla, Sanjay, Vineshwar - Please attach a document showing a requirement for these leave types to be excluded from Leave Liability
- The document should be from the source. You can ask auditors to provide this document
|
|
| 11 Apr 2023 | 03:04PM Comment 22 by Sitla (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 14-04-2023 02:57 PM Notes: Edited by sitla on 11/04/23 15:07. |
| Hi Sanjay, Attached is the Accounting standard document which states how liabilities for employees are taken. Refer to Page A1172 & A1173 - Sections 11 to 18 which explains in detail. The full standard is attached herewith. Sitla.
|
|
| 13 Apr 2023 | 08:34AM Comment 23 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 20-04-2023 08:32 AM Time Taken: 2.00 |
| Hi Sanjay, Re Case L12772 - we have logged case L12875 as cannot modify case header.
L12875 - Leave Accrual & Pay Rate change recalculates Leave Liability and sends the difference into FMIS Integration Closing this case. Will continue this issue in case L12875 |
|