Company: Link Technologies
Case No: L12837. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 02 Feb 2023 04:10PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 20.00 (Weight: 24.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Sanjay, Vineet, Vineshwar Prasad
Resolve By: Friday, 17 February 2023 02:30 PM [441 days since logged date]
Status: Closed
Subject: Public Holiday "Rate" and "Amount" is picked as ZERO when entries are created using the Process ESS001
Summary:    

Our Client advised that the Public Holiday Rate is picked as ZERO in the pay despite the pay code having the rate set as 1.

The client is on version: 13.40.0722 GA and requested a patch.

---------------------------------------------------------------------------------------------------------------------------------------------

We diagnosed the below in a copy of the demo database. Refer environment below:

  1. Server Name: LINKAD
  2. Database: DEMO-LinkSOFT-LBS
  3. URL: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS/Account/login.aspx
  4. Login: default admin login
  5. Company: Link Technologies - Demo
  6. Version: 14.40.0130.GA

Steps:

  1. Activity "Public Holiday Entitled" was created successfully - the same way Normal Hours, Time & Half Hours, and Double Time Hours
  2. The pay code tagged to Activity "Public Holiday Entitled" is APHOL
  3. Public Holiday created for 14/02/2023
  4. Employee: E008
  5. TNA Entries created for 13/02/2023 and 14/02/2023 - refer to Figure 1
  6. Process: ESS001 executed
  7. The Public Holiday Entitled was created successfully but with a rate = 0.00 - refer to Figure 2
  8. When the pay was created - pay run ID: 634 - The pay code: APHOL rate was 0.00.  Refer to Figure 3


Figure 1: TNA Entries for employee E008

Figure 2: Timesheet Entries for employee E008

Figure 3: Pay Entries for employee E008

Audit Notes:Edited by sanjay on 17/02/23 11:31. Edited by sanjay on 03/02/23 15:15. Edited by sanjay on 02/02/23 16:10. Edited by sanjay on 02/02/23 16:04. 
02 Feb 202303:09PM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 03-02-2023 03:05 PM Time Taken: 2.00

Discussion with Sanjay and Aarti:

  1. Pay code - use Staff Rate = Y:
    1. The Time Entry for Public Holiday will be created at the rate of 1
    2. The Amount = Quantity * Rate
    3. The pay will display the staff rate
  2. Pay Code - use Staff Rate = N:
    1. There must be a value defined in Pay Code
    2. The Time Entry for Public Holiday will be created based on the value defined in Pay Code
    3. The Amount = Quantity * Rate
    4. The pay will display the rate and amount from the Time Entry

Next Step:

  1. Sanjay will look at how to display the rate if "Staff Rate = N" and "Rate By = Percentage"

02 Feb 202304:01PM Comment 2 by Sanjay (Link Technologies) Case L12837 added to project 14.50
02 Feb 202304:04PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 23/12/2022 to 08/02/2023
03 Feb 202304:01PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-02-2023 09:15 PM Time Taken: 7.00 Notes: Edited by sanjay on 07/02/23 12:28. Edited by sanjay on 06/02/23 14:48. ETC extended from: 08/02/2023 to 06/02/2023

Teams discussion with Aarti, Vineshwar and Sanjay - discussion notes:

  1. When public holiday entries are created by the system, the RATE and AMOUNT fields are set to ZERO instead of following the configuration setup for the PAY CODE, Project and Activity.
  2. Users have to edit this entry and update the Rate and Amounts before approving the time entry for Payroll to correctly calculate the Pay Amount.
  3. We checked all the way back to Version 9 and found the Rate and Amounts were always Zero.

To implement a correction, the following design/business rules will be used:

  1. Public Holiday Time Entries are created by Process "ESS001"
  2. The following is configured automatically:
    1. A Customer Record is created (If it doesn't already exist) as  the Company name defined in the menu "Global Administration ~> Company"
    2. A Project is Created with the Description "Time Entry"
    3. The following Activities are created:
      1. "Normal Hours" Paycode: "ANHRS"
      2. "Time & Half Hours" Paycode: "ADHLF"
      3. "Double Time Hours" Paycode: "ADTIM"
      4. "Public Holiday Hours" Paycode: "APHOL"
      5. "Non-Taxable Allowance" Paycode: "EALLOW"
      6. "Taxable Allowance" Paycode: "BALLOW"
      7. "Time & Helf Hours" Paycode: "ADHLF
    4. The Project in 2.2. The above is allocated to the Customer in 2.1
    5. The Activities in 2.3 are allocated to the Project in 2.2
  3. The following new configurations will be added to process ESS001 to make the system more flexible and user-configurable.
    1. Project description. Default Value: "Time Entry"
    2. ActivityDescription. Default Value: "Public Holiday Entitled"
  4. The process will be changed to execute using the parameters in 3. above
  5. When the Public Holiday Time Entry is created, the following rules will apply:
    1. The PAY Code for "Public Holiday Entitled" will use the pay code from the Activity where the description is "Public Holiday Entitled"
    2. If this pay code has "Use Staff Rate" Checked, the Time Entry will be created using the Rate defined in the fields "Rate By" and "Rate", both defined in the Pay Code
    3. If this pay code has "Use Staff Rate" UN-Checked, the system will use the rates defined in the PROJECT/Activity

Additional Changes:

  1. When the PAYCODE (APHOL) has "UseStaffRate" checked, set the Public Holiday entry to "1" as the "Standard Pay Create" functions will use the Paycode settings to calculate the employee rate.

Next Step:

  1. Aarti and Vneshwar to review the above design and provide feedback for development to proceed with changes. Please respond by COB Monday 6th Feb 2023. Thanks.

07 Feb 202312:29PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-02-2023 06:28 PM Time Taken: 1.00

Hi Guys, can you please review and add your comments so I can proceed with this change?  thanks.


08 Feb 202308:32AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-02-2023 02:30 PM Time Taken: 8.00 Notes: ETC extended from: 06/02/2023 to 17/02/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50

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

  1. When the PAYCODE (APHOL) has "UseStaffRate" checked, set the Public Holiday entry to "1" as the "Standard Pay Create" functions will use the Paycode settings to calculate the employee rate.

3. Affected Areas:

  1. Create Public Holiday Entry Process - ESS001

4. The issue was caused by:

  1. Change in design

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


01 Mar 202309:25AM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2023 03:24 PM Time Taken: 2.00
Tested and passed in V14.30

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12837 in the subject line of all emails regarding this issue.

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