Company: Link Technologies
Case No: L11972. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 12 May 2020 03:35PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 4.00 (Weight: 4.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Coca Cola, Rashna, Vineshwar Prasad
Resolve By: Tuesday, 12 May 2020 08:22 PM [1443 days since logged date]
Status: Closed
Subject: Issues with GL integration Report
Summary:    Hi Rashna,

As discussed on the call, the following 2 issues exist in the GL report in version 11:
  1. The debit and credit amounts are not tying at the employee level due to FNPF and Insurance commission amounts.
Audit Notes:Edited by rashna on 12/05/20 15:35. Edited by alvis on 12/05/20 14:22. Edited by rashna on 12/05/20 13:25. 
12 May 202001:36PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 12-05-2020 07:25 PM Time Taken: 1.00

Hi Alvis, 

I have verified the case in version 11.5.0508.

  1. The issue is not in the standard "GL Integration Report".
  2. The issue occurs when the Coca Cola Customization is enabled in "Lt_SYS_Customisations".

Issue:

  1. The pay values for "HSUPE" Liability, "LICI Commission" and "FBSPIN Commission" are summed and printed on the top of the report.
  2. Since, the above are missing on the individual employee record the GL report shows balances for all employee record. However, the report summary shows the report is balanced.  Refer to Figure 1.
  3. I tested the case as below:
    1. Disabled "GL Grouping" for HSUPE, LICI and FBSPIN.
    2. Created pay for employee 100035. Payrun 267.
    3. Validated the "GL Integration Report". Refer to Figure 1.
Setup:
  1. DB - CLIENT-CCA-LINKSOFT-TRG
  2. Server - LINKQA4\CP42

Figure 1: GL Integration Report - Coca Cola.

Thanks
Rashna


12 May 202002:22PM Comment 2 by Alvis (Link Technologies) Case L11972 added to project 11.5
12 May 202002:23PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-05-2020 08:22 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:11.5.0512

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

  1. Changed Coca-Cola GL Integration customization to tag employee for Super Liability and Commission journals.

2. Affected Areas:

  1. Coca-Cola GL Integration

3. The issue was caused by:

  1. Change request

4. Notes
5. Next Step
: UAT


12 May 202003:35PM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 31/05/2020 to 12/05/2020
13 May 202010:17AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-05-2020 04:12 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Upgrade database to version 11.5.0512.

  1. Create pay for employee 100035.
  2. Add "LICI" and "FBSPIN" to the pay.
  3. Generate the "Gl Integration Report". Validate that the report shows all components on the employee level.
  4. The total balance should be 0 for the employee
Pass

Figure 1:  GL Integration Report

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.5.0512
  3. Setup: Demo
  4. Server : 10.0.0.14\CP42
  5. Database:CLIENT-CCA-LINKSOFT-TRG

Next Step

  1. Closure

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

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