Subject: | Add configurable "Payrun Type" to allow users to choose pay processing behaviour |
Summary: | Issue When pay codes with include "Super" flag set as No are processed in the special pay, pay code FESUPE is populated in the special pay. Business Scenario - A company pays overtime and meal allowance to employees as part of a special pay.
- Certain employees have employee additional Super (FESUPE) set to be deducted by value. This is set in employee deductions menu.
- Some employees are paid overtime and meal while others are only paid meal allowances. When pay is processed for these employees the FESUPE pay code is also added to the current pay.
- Payroll personnel does a pay verify so that PAYE and XXXXX calculations are accurately calculated for those employees who are paid overtime.
- Now if employee is paid EMEAL of $50 only and FESUPE is set as $150, the net pay for this employee becomes -$100.
- Current workaround given is to put this deduction on hold before making special pay, however due to the number of employees, this will cause issues if payroll personnel forgets to mark as active after processing the special pay.
- FESUPE added to the pay is not removed from "Mass Pay Code Processing".
Expected Behaviour - All deductions setup on menu 324, should flow into the normal pay only.
- Paying allowances with "Include Super" as "No" should not accommodate for FESUPE deduction. This should be treated as a fixed deduction.
Steps to Replicate - There is a pay code as EMEAL which has the following characteristic: [Refer to Figure 1.1]
- Classification: Non – Taxable Allowance
- Includes Super – NO
- Add the following deductions to an employee:
- FESUPE
- FDD
- Create Special Pay for that employee E069 using menu: 334-1
- Using menu: Edit Manual Pay 334-2:
- Add “EMEAL” to the employee
- Hours\Quantity = 1
- Save
- Open menu: 332-3: [Refer to Figure 1.2]
- Click on save
- The screen adds “FESUPE” to this employee.
[Refer to Figure 1.1]
[Refer to Figure 1.2]
|
Audit Notes: | |
23 Feb 2018 | 03:34PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-02-2018 03:34 PM Time Taken: 1.00 |
| Hi Alvis, I have verified the case in 9.2.4, issue remains the same. The following scenario breaks in Link Payroll. - Create a paycode as "EALLO" [Refer to Figure 1.1]
- Classification: Non – Taxable Allowance
- Includes Super – NO
- Add the following deductions to an employee:
- FESUPE - $100.00 every pay.
- FDD - $20.00
- Create Manual Pay for that employee E013 using menu: 334-1
- Using menu: Edit Manual Pay 334-2:
- Add “EALLO” to the employee
- Hours\Quantity = 1
- Save
- Open menu: 332-3: [Refer to Figure 1.2]
- Click on save
- The screen adds “FESUPE” to this employee.
Issue, is why is it adding FESUPE? - FESUPE is the excess FNPF deduction. FNPF is not enabled on EALLO.
- No other deduction paycode was added.
Setup - Database - LINKSOFT
- Server - QA1
|
|
23 Feb 2018 | 03:48PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-02-2018 12:00 AM Time Taken: 1.00 |
| This case is a change request. Hence will be discussed in the next development meeting. |
|
21 Mar 2018 | 02:22PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-03-2018 02:22 PM Time Taken: 1.00 |
| Hi Rashna, The workaround is to edit the deduction entry and mark it as hold, then process special pay, then un-hold deductions. We have agreed to make the following changes in version 9.4: - There are 4 types of pay, Normal, Special, Termination, Non-pay week. Each of these has several decisions that are currently not configurable.
The following decisions will be applicable for each pay type: - Include Timesheet entries
- Include Standard Pay
- Include Allowances from allowance screen
- Include Deductions from deduction screen
- Include Benefits from benefit screen
- Include Leave Transactions - Taken
- Include Leave Transactions - Sold
- Include final pay entries. creates leave balance payout, leave accrual payout, marks the employee as terminated after pay update.
- Create Normal Hours with zero quantity
- Include ESS time entries
- Include Achievement payments
- Include "Auto Reduct Hours for Contract Expiry"
- Include shift allowances
- include leave loading
- Include "Missing Time Entry Paycode". Changes pay method from "Direct" to "Cash" when employees have missing time on payday. Exceptions for an employee's having "Missing Time Paycode" which overrides the rule. Reverts payment method to "Direct" after pay update.
- Include customizations
- Calculate Super - Compulsory
- Calculate Super - Excess
- Calculate Tax
- Send Deductions over threshold alert
- Send super not deducted alert
- Send verification checks alert
- Close pay: update next pay details
- Send pay update alert to all employees
- Process leave accruals/rollover
- Automatically terminate an employee on contract expiry and send contract expired alert
Regards Alvis |
|
21 Mar 2018 | 02:22PM Comment 4 by Alvis (Link Technologies) Case 9112 added to project 9.4 |
26 Mar 2018 | 08:24AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-03-2018 08:24 AM |
| Development has agreed to perform the following changes in version 9.4: - Create a Transaction Rule menu
- Add "Payroll ~> PayrunType" as a Transaction Rule
- Add a list of Payrun Types
- Add a sub-grid to define rules
Proceed with Design and build in version 9.4 |
|
26 Mar 2018 | 04:37PM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-03-2018 04:37 PM Time Taken: 8.00 |
| Development work for this case has been completed. The change will be available in version: 9.4
1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Created new menu for "FR061 - Transaction Rules" URL: /Framework/TransactionRule.aspx
- Created maintenance tables "LT_SYS_TransactionCode, LT_SYS_TransactionCodeDetail, LT_SYS_TransactionCodeDetailRule"
- Created Select, insert and update procedures for above tables
- Created Transaction Code build script for Payrun type.
- Changed back-office "Create Pay and Create Manual Pay" screen for "Payrun type" lookup to view from "LT_SYS_TransactionCode -> PAY.PayrunType"
- Changed "Pay create process" to use pay run type rules defined in 4. above.
- Changed "Pay update process" to use pay run type rules defined in 4. above.
Assigned to Sanjay to create maintenance form in ESS for TransactionRule.
|
|
27 Mar 2018 | 09:38AM Comment 7 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 27-03-2018 09:38 AM Time Taken: 2.00 |
| Maintenance form for Transaction Rules has been added. Proceed with system test. |
|
27 Mar 2018 | 11:09AM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-03-2018 11:09 AM Time Taken: 0.50 |
| System test completed on the Transaction rule form. |
|
01 May 2018 | 09:58AM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-05-2018 09:58 AM Time Taken: 4.00 |
| System Test completed. The following were tested: - New configuration menu in the Web framework, tested the edit of the record.
- Tested each configuration rule for Payroll Processing -> Payrun Types
RuleCode | RuleDescription | Pass/Fail | AlertDeductionThreshold | Send Deductions over threshold alert | Pass | AlertPayUpdate | Send pay update alert to all employees | Pass | AlertSuperNotDeducted | Send super not deducted alert | Pass | AlertVerificationChecks | Send verification checks alert | Pass | CalculateSuperCompulsary | Calculate Super - compulsory | Pass | CalculateSuperExcess | Calculate Super - excess | Pass | CalculateTax | Calculate Tax | Pass | CreateMissingTimePaycode | Create "Missing Time Paycode". Changes pay method from "Direct" to "Cash" when employees have missing time on the payday. Exceptions for an employee's having "Missing Time Paycode" which overrides this rule. Reverts payment method to "Direct" after pay is updated. | Pass | CreateNormalHoursZeroQuantity | Create Normal Hours with zero quantity | Pass | IncludeAchievement | Include Achievement Entries | Pass | IncludeAllowance | Include Allowance Entries | Pass | IncludeBenefit | Include Benefit Entries | Pass | IncludeContractExpiry | Include Contract Expiry Entries. Automatically terminate an employee on contract expiry and send contract expired alert. | Pass | IncludeCustomization | Include customization entries | Pass | IncludeDeduction | Include Deduction Entries | Pass | IncludeESSTime | Include ESS Time Entries | Pass | IncludeFinalPay | Include Final Pay entries. Creates leave balance payout, leave accrual payout and marks the employee as terminated after pay update. | Pass | IncludeLeaveLoading | Include Leave Loading | Fail - Test in beta2 | IncludeLeaveTransactionsSold | Include Leave Transactions - Sold | Pass | IncludeLeaveTransactionsTaken | Include Leave Transactions - Taken | Pass | IncludeShiftAllowance | Include Shift Allowance | Pass | IncludeStandardPay | Include Standard Pay Entries | Pass | IncludeTimesheet | Include Timesheet Entries | Pass | IncludeTimesheetForNonTimesheetEmployee | Include timesheet entries for non-timesheet employees | Pass | ProcessLeaveAccrual/rollover | Process leave accruals/rollover | Pass | UpdateNextPay | Update Next Pay details | Pass |
|
|
09 May 2018 | 10:01AM Comment 10 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 10:01 AM Time Taken: 1.00 |
| System test completed. Verified the following: - Enabled Leave Loading Flag "Include Leave Loading"
- Configured an employee to receive leave loading
- Created Leave transaction
- Created pay and verified leave loading entries - pass
Regards Alvis |
|
22 May 2018 | 01:52PM Comment 11 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-05-2018 12:00 AM Time Taken: 5.00 |
| Hi Alvis, This case has been successfully tested. Documentation on the case has been updated. - ESS-- Administration -- Configuration
Please update the "Rule Description" of the configurations for clarity Test Environment - Version 9400 Beta 2
- Database - LINKSOFT on QA1
- Application on QA1
- OS - Windows 7
Test Plan System Test completed. The following were tested: - New configuration menu in the Web framework, tested the edit of the record.
- Tested each configuration rule for Payroll Processing -> Payrun Types
RuleCode | RuleDescription | Pass/Fail | AlertDeductionThreshold | Send Deductions over threshold alert | Pass | AlertPayUpdate | Send pay update alert to all employees | Pass | AlertSuperNotDeducted | Send super not deducted alert | Pass | AlertVerificationChecks | Send verification checks alert | Pass | CalculateSuperCompulsary | Calculate Super - compulsory | Pass | CalculateSuperExcess | Calculate Super - excess | Pass | CalculateTax | Calculate Tax | Pass | CreateMissingTimePaycode | Create "Missing Time Paycode". Changes pay method from "Direct" to "Cash" when employees have missing time on the payday. Exceptions for an employee's having "Missing Time Paycode" which overrides this rule. Reverts payment method to "Direct" after pay is updated. | Pass | CreateNormalHoursZeroQuantity | Create Normal Hours with zero quantity | Pass | IncludeAchievement | Include Achievement Entries | Pass | IncludeAllowance | Include Allowance Entries | Pass | IncludeBenefit | Include Benefit Entries | Pass | IncludeContractExpiry | Include Contract Expiry Entries. Automatically terminate an employee on contract expiry and send contract expired alert. | Pass | IncludeCustomization | Include customization entries | Pass | IncludeDeduction | Include Deduction Entries | Pass | IncludeESSTime | Include ESS Time Entries | Pass | IncludeFinalPay | Include Final Pay entries. Creates leave balance payout, leave accrual payout and marks the employee as terminated after pay update. | Pass | IncludeLeaveLoading | Include Leave Loading | Pass | IncludeLeaveTransactionsSold | Include Leave Transactions - Sold | Pass | IncludeLeaveTransactionsTaken | Include Leave Transactions - Taken | Pass | IncludeShiftAllowance | Include Shift Allowance | Pass | IncludeStandardPay | Include Standard Pay Entries | Pass | IncludeTimesheet | Include Timesheet Entries | Pass | IncludeTimesheetForNonTimesheetEmployee | Include timesheet entries for non-timesheet employees | Pass | ProcessLeaveAccrual/rollover | Process leave accruals/rollover | Pass | UpdateNextPay | Update Next Pay details | Pass |
Thanks Rashna
|
|
23 May 2018 | 02:18PM Comment 12 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-05-2018 02:18 PM Time Taken: 1.00 |
| Hi Rashna, We have put in more details in the configuration description. Please review and update documentation. regards Alvis |
|
24 May 2018 | 01:05PM Comment 13 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 01:05 PM Time Taken: 1.00 |
| System test completed. Verified the "Payroll Processing -> Payrun Type" configuration description has been changed to include more details.
|
|
25 May 2018 | 09:50AM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-05-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay,
This case has been successfully tested.
Documentation has been updated under ESS-- Administration -- Configuration. Test Environment - Version 9400 Beta 3
- Database - LINKSOFT on QA1. Demo Database.
- Application on QA1
- OS - Windows 7.
Test Plan - Rule Description under configuration should be updated with details.
Thanks
Rashna |
|
25 May 2018 | 02:51PM Comment 15 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2018 02:51 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 16 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |