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

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"

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.

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

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