Company: Link Technologies
Case No: L12772. Project: 14.70: LinkSOFT Version 14.70 - May 2023
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 12 Aug 2022 08:38AM
Priority: Low
Product: Payroll & HR
Group: Change Request
Time Taken: 21.00 (Weight: 16.00)
Assigned To: Vineshwar Prasad (Edge Business Solutions)
Circulation: Development, Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Friday, 07 April 2023 04:53 PM [619 days since logged date]
Status: Closed
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
  1. Link: https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
  2. Version: 14.00.0729.GA
Steps to Replicate
  1. Created Employee: EMP0001
    • Pay Rate: $5 Hourly
    • Pay Team: Weekly
  2. Allocated Leaves
    • AAL10: Annual Leave
    • BL3: Bereavement Leave
    • ASL: Sick Leave
  3. Created Pay No: 486
  4. Changed Pay Rate to $6
  5. 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 202201:32PM Comment 1 by Sanjay (Link Technologies) This comment has been removed
12 Aug 202208:42AM Comment 2 by Vineshwar Prasad (Edge Business Solutions) This comment has been removed
15 Aug 202209:33AM Comment 3 by Sanjay (Link Technologies) Case L12772 added to project 14.10
15 Aug 202209:33AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 17/08/2022 to 19/08/2022
06 Sep 202202:39PM Comment 5 by Sanjay (Link Technologies) Case L12772 added to project 14.20
13 Oct 202210:54AM Comment 6 by Sanjay (Link Technologies) Case L12772 added to project Review
16 Nov 202202: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 202202:57PM Comment 8 by Sanjay (Link Technologies) ETC was changed from 12/11/2022 to 30/11/2022
17 Nov 202202: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. 

  1. Setup 12.42. Install files are in QA3 d:\Temp. Setup an employee as explained in "Steps to replicate" - Vineshwar
  2. Setup 14.33. Setup an employee as explained in "Steps to replicate" - Vineshwar
  3. 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
  4. Identity which leave types is affected by:  - Vineshwar/Sitla/Sanjay
    1. Which Leaves should go or not go on Leave Accrual
    2. Which Leaves should go or not go on Leave Rollover
    3. Which Leaves should go or not go on Leave Adjustment
    4. Which Leaves should go or not go on Leave Allocation
    5. Which Leaves should go or not go on Rate Change
  5. Analyse the difference is the two versions - Sanjay
  6. Determine how to configure this to enforce rule 4 above - Sanjay

25 Jan 202310: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

  1. Setup 12.42 and confirm the issue is there
  2. Setup 14.30 and verify
  3. Sitla says it is a bug in 12.42 and has been corrected in 14.30
  4. Sanjay says we can add a config to allow this if needed

01 Feb 202302: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 202302: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
  1. By default, all Leave Transactions will flow into Integration

07 Mar 202308:03AM Comment 13 by Sanjay (Link Technologies) Case L12772 added to project 14.60
09 Mar 202305:31PM Comment 14 by Sanjay (Link Technologies) ETC was changed from 09/02/2023 to 31/03/2023
20 Mar 202304: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 202304:39PM Comment 16 by Sanjay (Link Technologies) Case L12772 added to project 14.70
30 Mar 202303:47PM Comment 17 by Sanjay (Link Technologies) ETC was changed from 31/03/2023 to 28/04/2023
30 Mar 202303: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 202303: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:

  1. 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
  2. Sanjay to Review and meet with EBD if required before working out how to handle this omission from GL Integration

04 Apr 202305: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 202302: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

  1. Please attach a document showing a requirement for these leave types to be excluded from Leave Liability
  2. The document should be from the source. You can ask auditors to provide this document

11 Apr 202303:04PM Comment 22 by Sitla Sharma (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 202308: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 


Attachments:
General Documents - Case: L12772:ias-19-employee-benefits.pdf
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12772 in the subject line of all emails regarding this issue.

Document size: 7.2 KB
For call complaints, please contact the Managing Director of the company using this form