Company: Link Technologies
Case No: L11979. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 18 May 2020 03:55PM
Priority: Medium
Product: Payroll & HR
Group: Enhancement
Time Taken: 10.00 (Weight: 10.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Coca Cola, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Wednesday, 20 May 2020 08:32 AM [1648 days since logged date]
Status: Closed
Subject: GL Integration Report - Summary of GL Transactions does not Group by Financial Dimensions
Summary:    from: Jessica Lum <Jessica.Lum@ccamatil.com>

Hi Rashna,

As discussed on the call, the following issue exists in the GL report in version 11:
  1. The summary does not include the financial dimensions( these are the same as that at the employee level but summarized).
For any question please call @Neeraj Solanki on 7707310


Regards
Audit Notes:Edited by alvis on 21/05/20 15:05. Edited by rashna on 19/05/20 13:18. Edited by rashna on 18/05/20 15:55. 
14 May 202010:47AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 14-05-2020 10:46 AM
----- Response from Rashna -----

This is an update from our team.
  1. The summary does not include the financial dimensions( these are the same as that at the employee level but summarized). - As per conversations over the call , we need clarification of the financial dimensions on the GL report. This request was not highlighted in the initial design for GL integration. We need to review which GL accounts should print the dimensions and where in LinkSOFT are the dimensions stored. 
CC: Vineshwar please contact Jessica and document the requirements for item 2. 

14 May 202010:48AM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 14-05-2020 10:47 AM

----- Response from Jessica (Coca Cola) -----

Hi Vineshwar,

Neeraj has advised the GL summary to show GL-TT-TP-Loc-CC-SA-PC


14 May 202011:16AM Comment 3 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 19-05-2020 10:51 AM Time Taken: 2.00 Notes: Edited by vineshwar on 14/05/20 11:17. 
Bula Team,

We had a discussion with Jessica and below is the update;

Version 10.151 Output
In version 10.151 the GL Integration report shows the Summary of GL Transactions grouped by the Financial Dimensions as shown in Fig 1 below;

Fig 1


Version 11.5 Output
In version 11.5 the GL Integration report does not group the Financial Dimensions in the Summary of GL Transactions as shown in Fig 2 below;

Fig 2


Change Required
  1. The Summary of GL Transactions needs to be Grouped by Financial Dimensions
  2. Example of Grouping;
    • GL-TT-TP-LOC-CC-SA-PC
    • 810104200-000-0000-30-41-00-020
    • 810104200-000-0000-30-26-00-090
Regards
Vineshwar Prasad

18 May 202003:55PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-05-2020 03:50 PM Time Taken: 1.00

Hi Sanjay, 

As per the GTM session, the GL Integrations summary should group  GL Transactions by segments.

  1. The data in the report is customised for Coca Cola.
  2. Segments for the report are saved under :
    1. Employee Maintenance - Additional Fields
    2. Pay Code - Additional Fields
Case assigned for development .

Thanks
Rashna

18 May 202003:55PM Comment 5 by Rashna (Edge Business Solutions) Case L11979 added to project 11.5
19 May 202008:54AM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 20-05-2020 08:32 AM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version: 11.5.1905

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

  1. Added grouping for segments in the summary section of the report.

2. Affected Areas:

  1. GL Integration Report

3. The issue was caused by:

  1. Improvement

4. Notes: 
5. Next Step: UAT


19 May 202001:18PM Comment 7 by Rashna (Edge Business Solutions) ETC was changed from 31/05/2020 to 20/05/2020
21 May 202001:49PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 22-05-2020 01:47 PM Time Taken: 1.00

Hi Alvis, 

I am unable to generate the "GL Integrated Report". Tested in client and demo database.

Error - Missing Parameter Values

Test Environment

  1. Server - LINKQA4\CP42
  2. Database - CLIENT-CCA-LINKSOFT-TRG
  3. Version - 11.5.0521
Thanks
Rashna

21 May 202003:05PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-05-2020 03:03 PM Time Taken: 1.00

Development work for this case has been completed.

The change will be available in version:11.5.0521

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

  1. Resolved issue with the GL Integration report by correcting the subreport links.

2. Affected Areas:

  1. GL Integration Report

3. The issue was caused by:

  1. Subreport links were incorrect.

4. Notes: 
5. Next Step: UAT


22 May 202008:51AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 26-05-2020 08:33 AM 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

Create a pay for employee 100035.

Generate the GL Integration Report and validate that the GL Summary list shows the GL code with defined segments in format GL-TT-TP-LOC-CC-SA-PC 

The segments are printed but the layout is not aligned. 

For example, 030 on the report is the "PC" segment but the data is printed under "Line Description". Refer to Figure 1.  


Figure 1: Sample

Environment Details

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

Next Step: 

  1. Review

    22 May 202003:01PM Comment 11 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-05-2020 02:52 PM Time Taken: 1.00

    Development work for this case has been completed.

    The change will be available in version:11.5.0522

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

    1. Changed GL integration report file to show the summary section group title and hide the page header.

    2. Affected Areas:

    1. GL integration report

    3. The issue was caused by:

    1. The summary section was showing the page header in the next page instead of the group title.

    4. Notes: 
    5. Next Step    : UAT


    29 May 202001:06PM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-06-2020 01:04 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
    1Generate the GL Integration Report and validate that the GL Summary list is aligned in format GL-TT-TP-LOC-CC-SA-PC 
    		Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 11.5.0528
    3. Setup: Demo
    4. Server : 10.0.0.14
    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: L11979 in the subject line of all emails regarding this issue.

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