Company: Link Technologies
Case No: L09112. Project: 09.40: LinkSOFT Version 9.4
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 15 Feb 2018 01:40PM
Priority: High
Product: Payroll & HR
Group: Change Request
Time Taken: 26.50 (Weight: 26.50)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 16 February 2018 12:00 AM [2255 days since logged date]
Status: Closed
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

  1. A company pays overtime and meal allowance to employees as part of a special pay.
  2. Certain employees have employee additional Super (FESUPE) set to be deducted by value. This is set in employee deductions menu.
  3. 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.
  4. Payroll personnel does a pay verify so that PAYE and XXXXX calculations are accurately calculated for those employees who are paid overtime.
  5. Now if employee is paid EMEAL of $50 only and FESUPE is set as $150, the net pay for this employee becomes -$100.
  6. 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.
  7. FESUPE added to the pay is not removed from "Mass Pay Code Processing". 
Expected Behaviour
  1. All deductions setup on menu 324, should flow into the normal pay only.
  2. Paying allowances with "Include Super" as "No" should not accommodate for FESUPE deduction. This should be treated as a fixed deduction.

Steps to Replicate

  1. There is a pay code as EMEAL which has the following characteristic: [Refer to Figure 1.1]
    1. Classification: Non – Taxable Allowance
    2. Includes Super – NO
  2. Add the following deductions to an employee:
    1. FESUPE
    2. FDD
  3. Create Special Pay for that employee E069 using menu: 334-1
  4. Using menu: Edit  Manual Pay 334-2:
    1. Add “EMEAL” to the employee
    2. Hours\Quantity = 1
    3. Save
  5. Open menu: 332-3: [Refer to Figure 1.2] 
  1. Click on save
  2. The screen adds “FESUPE” to this employee.


[Refer to Figure 1.1]

 

[Refer to Figure 1.2]




Audit Notes:
23 Feb 201803: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.

  1. Create a paycode as "EALLO" [Refer to Figure 1.1]
    1. Classification: Non – Taxable Allowance
    2. Includes Super – NO
  2. Add the following deductions to an employee:
    1. FESUPE - $100.00 every pay.
    2. FDD - $20.00
  3. Create Manual Pay for that employee E013 using menu: 334-1
  4. Using menu: Edit  Manual Pay 334-2:
    1. Add “EALLO” to the employee
    2. Hours\Quantity = 1
    3. Save
  5. Open menu: 332-3: [Refer to Figure 1.2] 
  6. Click on save
  7. 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 201803: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 201802: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:

  1. 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:

  1. Include Timesheet entries
  2. Include Standard Pay
  3. Include Allowances from allowance screen
  4. Include Deductions from deduction screen
  5. Include Benefits from benefit screen
  6. Include Leave Transactions - Taken
  7. Include Leave Transactions - Sold
  8. Include final pay entries. creates leave balance payout, leave accrual payout, marks the employee as terminated after pay update.
  9. Create Normal Hours with zero quantity
  10. Include ESS time entries
  11. Include Achievement payments
  12. Include "Auto Reduct Hours for Contract Expiry"
  13. Include shift allowances
  14. include leave loading
  15. 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.
  16. Include customizations
  17. Calculate Super - Compulsory
  18. Calculate Super - Excess
  19. Calculate Tax
  20. Send Deductions over threshold alert
  21. Send super not deducted alert
  22. Send verification checks alert
  23. Close pay: update next pay details
  24. Send pay update alert to all employees
  25. Process leave accruals/rollover
  26. Automatically terminate an employee on contract expiry and send contract expired alert

Regards
Alvis


21 Mar 201802:22PM Comment 4 by Alvis (Link Technologies) Case 9112 added to project 9.4
26 Mar 201808: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:

  1. Create a Transaction Rule menu
  2. Add "Payroll ~> PayrunType" as a Transaction Rule
  3. Add a list of Payrun Types
  4. Add a sub-grid to define rules

Proceed with Design and build in version 9.4


26 Mar 201804: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):|

  1. Created new menu for "FR061 - Transaction Rules" URL: /Framework/TransactionRule.aspx
  2. Created maintenance tables "LT_SYS_TransactionCode, LT_SYS_TransactionCodeDetail, LT_SYS_TransactionCodeDetailRule"
  3. Created Select, insert and update procedures for above tables
  4. Created Transaction Code build script for Payrun type.
  5. Changed back-office "Create Pay and Create Manual Pay" screen for "Payrun type" lookup to view from "LT_SYS_TransactionCode -> PAY.PayrunType"
  6. Changed "Pay create process" to use pay run type rules defined in 4. above.
  7. 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 201809: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 201811: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 201809: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:

  1. New configuration menu in the Web framework, tested the edit of the record.
  2. 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 201810: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:

  1. Enabled Leave Loading Flag "Include Leave Loading"
  2. Configured an employee to receive leave loading
  3. Created Leave transaction
  4. Created pay and verified leave loading entries - pass

Regards
Alvis


22 May 201801: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:

  1. New configuration menu in the Web framework, tested the edit of the record.
  2. Tested each configuration rule for Payroll Processing -> Payrun Types
RuleCodeRuleDescriptionPass/Fail
AlertDeductionThresholdSend Deductions over threshold alert Pass
AlertPayUpdateSend pay update alert to all employees Pass
AlertSuperNotDeductedSend super not deducted alert Pass
AlertVerificationChecksSend verification checks alert Pass
CalculateSuperCompulsaryCalculate Super - compulsory Pass
CalculateSuperExcessCalculate Super - excess Pass
CalculateTaxCalculate Tax Pass
CreateMissingTimePaycodeCreate "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
CreateNormalHoursZeroQuantityCreate Normal Hours with zero quantity Pass
IncludeAchievementInclude Achievement Entries Pass
IncludeAllowanceInclude Allowance Entries Pass
IncludeBenefitInclude Benefit Entries Pass
IncludeContractExpiryInclude Contract Expiry Entries. Automatically terminate an employee on contract expiry and send contract expired alert. Pass
IncludeCustomizationInclude customization entries Pass
IncludeDeductionInclude Deduction Entries Pass
IncludeESSTimeInclude ESS Time Entries Pass
IncludeFinalPayInclude Final Pay entries. Creates leave balance payout, leave accrual payout and marks the employee as terminated after pay update. Pass
IncludeLeaveLoadingInclude Leave Loading Pass
IncludeLeaveTransactionsSoldInclude Leave Transactions - Sold Pass
IncludeLeaveTransactionsTakenInclude Leave Transactions - Taken Pass
IncludeShiftAllowanceInclude Shift Allowance Pass
IncludeStandardPayInclude Standard Pay Entries Pass
IncludeTimesheetInclude Timesheet Entries Pass
IncludeTimesheetForNonTimesheetEmployeeInclude timesheet entries for non-timesheet employees Pass
ProcessLeaveAccrual/rolloverProcess leave accruals/rollover Pass
UpdateNextPayUpdate Next Pay details Pass


Thanks

Rashna




23 May 201802: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 201801: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 201809: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
  1. Rule Description under configuration should be updated with details.
Thanks

Rashna

25 May 201802:51PM Comment 15 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2018 02:51 PM
Thanks Rashna 

09 Oct 201908: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
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09112 in the subject line of all emails regarding this issue.

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