Company: Link Technologies
Case No: L09394. Project: 09.40: LinkSOFT Version 9.4
Logged By: Rashna (Edge Business Solutions) on 04 Jul 2018 02:35PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 8.00 (Weight: 8.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Thursday, 05 July 2018 12:00 AM [2095 days since logged date]
Status: Closed
Subject: Payroll reports has incorrect amounts when pay is reversed
Summary:    

Hi Sanjay,  

Below has analysis has been done in version 948004.

  • Pay 439 was payrun 1.
  • Pay 440 was the reverse pay for payrun 1.
  • Pay Date is 16/01/2018 for both pays.
Test Environment
  • LINKSOFT on QA1
  • Backup - 10.0.0.11:\Temp\Case 9394
Item Report Issue
1YTD Listing Net Pay on the report is incorrect. Net Pay should be 0
2Pay Edt Report YTDNormal hours of 160 should be reflected under the "Norm' section. This is currently reflected under "Other".  
3Pay Audit Report

For Payrun 440

  • FPAYE should be negative
  • Super should be negative
  • Net Banking should be negative
  • Net Cash should be 0
  • Deduction to be negative

The above to be applied to the report and summary at the bottom of the report

4Pay Banking Report

For Payrun 440

  • Banking Amount should be negative
5Payslip Packet ReportRemove the "Employer Super" component from the report
6Pay Salary Deposit Slip

For Payrun 440 

  • Banking Amount should be negative.
7PaySlip A5

For Payrun 440

  • The deduction should be positive
  • Banking should be negative.
  • YTD amounts should be 0 for both pays.
8Payslip A6

For Payrun 440

  • The deduction should be positive
  • Banking should be negative.
9Pay Deduction Report

For Payrun 440

  • Deduction Amounts should be negative. Add positive and negative signs to the report
10Pay Analysis The HSUPE and ANZ Banking amounts are 0 on the report for both pays. Please advise if this is correct.
11Pay Code Summary Generate the report with dates 01/01/2018 to 31/01/2018 for paycode ANHRS. Total comes to 10615.38. The amount for pay 440 should be negative.
12Pay Slip A4

For Payrun 440

  • PAYE contribution should be positive.
  • Deductions should be positive
  • YTD for both pays should be 0
  • Remove "XXXXX Company Contribution" component from the pay slip.

Audit Notes:
04 Jul 201802:36PM Comment 1 by Alvis (Link Technologies) Case 9394 added to project 09.4
04 Jul 201804:04PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-07-2018 04:04 PM Time Taken: 2.00
Development work for this case has been completed.
The change will be available in version: 9.4.8.005

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

Item Report IssueChanges made
1YTD Listing Net Pay on the report is incorrect. Net Pay should be 0Removed absolute value from the report formula
2Pay Edt Report YTDNormal hours of 160 should be reflected under the "Norm' section. This is currently reflected under "Other".  Corrected procedure to use company code correctly. This report was not producing correct result from the first build.
3Pay Audit Report

For Payrun 440

  • FPAYE should be negative
  • Super should be negative
  • Net Banking should be negative
  • Net Cash should be 0
  • Deduction to be negative

The above to be applied to the report and summary at the bottom of the report

Removed absolute value from the report procedure and replaced with "paycode" sign
4Pay Banking Report

For Payrun 440

  • Banking Amount should be negative
Removed absolute value from the report procedure and replaced with "paycode" sign
5Payslip Packet ReportRemove the "Employer Super" component from the reportRemoved "Employer Super" from the report
6Pay Salary Deposit Slip

For Payrun 440 

  • Banking Amount should be negative.
Removed absolute value from the report procedure and replaced with "paycode" sign
7PaySlip A5

For Payrun 440

  • The deduction should be positive
  • Banking should be negative.
  • YTD amounts should be 0 for both pays.
Removed absolute value from the report procedure and replaced with "paycode" sign
8Payslip A6

For Payrun 440

  • The deduction should be positive
  • Banking should be negative.
Removed absolute value from the report procedure and replaced with "paycode" sign
9Pay Deduction Report

For Payrun 440

  • Deduction Amounts should be negative. Add positive and negative signs to the report
Removed absolute value from the report procedure and replaced with "paycode" sign
10Pay Analysis The HSUPE and ANZ Banking amounts are 0 on the report for both pays. Please advise if this is correct.Removed Net Pay column as this was showing incorrect value. Added Banking and Non-pay column.
11Pay Code Summary Generate the report with dates 01/01/2018 to 31/01/2018 for paycode ANHRS. Total comes to 10615.38. The amount for pay 440 should be negative.Removed absolute value from the report procedure and replaced with "paycode" sign
12Pay Slip A4

For Payrun 440

  • PAYE contribution should be positive.
  • Deductions should be positive
  • YTD for both pays should be 0
  • Remove "FNPF Company Contribution" component from the pay slip.

Removed "FNPF Company Contribution" from Payslip A4 report

Removed absolute value from the report procedure and replaced with "paycode" sign


2. The issue was caused by:

  1. Incorrect sign used in reports. Deductions and banking (Paycode Type=6 and 7) are stored as negative amounts.

    3. Next Step

    1. UAT

    04 Jul 201805:12PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-07-2018 05:12 PM
    Proceed with UAT 

    05 Jul 201810:01AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 06-07-2018 12:00 AM Time Taken: 1.00

    Hi Sanjay and Alvis, 

    I have created a pay employee E015. Refer to figure 1.

    However, I am unable to reverse the Banking and PAYE amounts.

    Please advise how I can reverse a full pay from the application.

    Thanks

    Rashna


    05 Jul 201801:45PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-07-2018 12:00 AM Time Taken: 5.00

    Hi Sanjay, 

    This case has been successfully tested.

    Documentation is not required for the case.

    Test Environment 

    • Version 9408 Beta 4
    • LINKSOFT on QA1

    Test Plan 

    tem Report IssueTest Results
    1YTD Listing Net Pay on the report is incorrect. Net Pay should be 0Net Pay shows the rounding figure, this will be corrected when pay reversal is redesigned to accommodate banks.
    2Pay Edt Report YTDNormal hours of 160 should be reflected under the "Norm' section. This is currently reflected under "Other".  Pass
    3Pay Audit Report

    For Payrun 440

    • FPAYE should be negative
    • Super should be negative
    • Net Banking should be negative
    • Net Cash should be 0
    • Deduction to be negative

    The above to be applied to the report and summary at the bottom of the report

    • FPAYE should be negative - Pass
    • Super should be negative - Pass
    • Net Banking should be negative
    • Net Cash should be 0
    • Deduction to be negative - Pass
    Since banking is accommodated in this version adjustment was made as CASH, hence Net Banking was 0 and Net Cash was negative.
    4Pay Banking Report

    For Payrun 440

    • Banking Amount should be negative
    Banking for pay reverse will be addressed in a future version.
    5Payslip Packet ReportRemove the "Employer Super" component from the reportPass
    6Pay Salary Deposit Slip

    For Payrun 440 

    • Banking Amount should be negative.
    Banking for pay reverse will be addressed in a future version.
    7PaySlip A5

    For Payrun 440

    • The deduction should be positive
    • Banking should be negative.
    • YTD amounts should be 0 for both pays.
    • The deduction should be positive - Pass
    • Banking should be negative - Banking for pay reverse will be addressed in a future version. 
    • YTD amounts should be 0 for both pays - Pass

    8Payslip A6

    For Payrun 440

    • The deduction should be positive
    • Banking should be negative.
    • The deduction should be positive - Pass
    • Banking should be negative - Banking for pay reverse will be addressed in a future version.  

    9Pay Deduction Report

    For Payrun 440

    • Deduction Amounts should be negative. Add positive and negative signs to the report
    • Deduction Amounts should be negative. Add positive and negative signs to the report - Pass

    10Pay Analysis The HSUPE and ANZ Banking amounts are 0 on the report for both pays. Please advise if this is correct.
    • Pass, HSUPE and Banking details are now updated on the pay.
    11Pay Code Summary Generate the report with dates 01/01/2018 to 31/01/2018 for paycode ANHRS. Total comes to 10615.38. The amount for pay 440 should be negative.
    • Pass
    12Pay Slip A4

    For Payrun 440

    • PAYE contribution should be positive.
    • Deductions should be positive
    • YTD for both pays should be 0
    • Remove "FNPF Company Contribution" component from the pay slip.
    • PAYE contribution should be positive - Pass
    • Deductions should be positive - Pass
    • YTD for both pays should be 0 - Pass
    • Remove "FNPF Company Contribution" component from the pay slip - Pass


    06 Jul 201802:01PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-07-2018 02:01 PM
    Thanks Rashna

    09 Oct 201908:14AM Comment 7 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: L09394 in the subject line of all emails regarding this issue.

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