Company: Link Technologies
Case No: L12878. Project: 14.70: LinkSOFT Version 14.70 - May 2023
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 20 Apr 2023 11:50AM
Priority: Low
Product: Payroll & HR
Group: Software Defect
Time Taken: 20.00 (Weight: 8.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Irfaz Ahmad, Sanjay, Vineet
Resolve By: Wednesday, 26 April 2023 11:07 AM [364 days since logged date]
Status: Closed
Subject: FNPF Report had empty rows on some pages and does not use up the whole page
Summary:    

Dear Vineet,

 

As discussed, please find attached our Superannuation report. This is an issue in version 12.32 as well as recent version 14. The FNPF report has so many spaces. Attached is a report for your verification please review pages 2 and 6.


Hitesh Kumar

Manager Infrastructure

ICT

Audit Notes:Edited by sanjay on 20/04/23 11:50. 
17 Aug 202201:15PM Comment 1 by Vineet (Link Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 18-08-2022 01:13 PM Time Taken: 1.00 Notes: Edited by sanjay on 20/04/23 11:51. 

Bula Hitesh

I have seen the issue. Let us discuss this internally and come back to you. Since I was not able to reproduce the same on our internal Demo setup, we will need a copy of your database to set up on our internal server and verify the same. It may be due to some data issue but we will confirm the same once we have received your database.

Regards
Vineet Ram


13 Apr 202303:09PM Comment 2 by Irfaz Ahmad (Link Fiji) Assigned To: Irfaz Ahmad (Link Fiji) Followup Date: 14-04-2023 12:27 PM Time Taken: 1.00 Notes: Edited by sanjay on 20/04/23 11:51. Edited by aarti on 20/04/23 10:02. Edited by aarti on 20/04/23 09:54. Edited by sanjay on 20/04/23 09:25. 

Bula Sanjay

We diagnosed the below in a copy of the client's database restored in QA4. Refer environment below:

  1. Server Name: LINKQA4
  2. Database: CLIENT-XXX-LINKSOFT
  3. URL: Link Technologies - Linksoft
  4. Login: default admin login
  5. Version: 14.60.0327.GA

Steps to replicate:

  1. Navigate to the Reports menu
  2. Select report ‘Superannuation Report - Detail by Month’
  3. Select the following report filter:
    1. Company: 
    2. Superannuation Fund: 'SUPE'
    3. Year: 2022
    4. Period: 7
  4. Generate using ‘PDF
  5. The file outputs extra spaces in between the whole document then records continue from the next page



Kindly request if you can verify this.


Kind regards
Irfaz


19 Apr 202301:55PM Comment 3 by Irfaz Ahmad (Link Fiji) Assigned To: Irfaz Ahmad (Link Fiji) Followup Date: 26-04-2023 12:00 AM Time Taken: 1.50 Notes: Edited by sanjay on 20/04/23 11:52. Edited by aarti on 20/04/23 10:01. 

Bula Team

Upon further diagnosis, our development team has identified that when exporting the report in pdf, the data on some pages are broken causing spacing issue in the report.

This has been identified as an intermittent issue whereby when we generated the report the issue was depicted on page 16 of 31 and when we re-generated the report for the second time, the issue was depicted on page 11 of 31.

Our development team has given a workaround to generate the report in 'View Crystal' format. The view image of the report in Crystal format doesnt have this issue, however, when the same will be downloaded using PDF, the spacing issue will exist.

This issue is not in the report file, however, its related to the SAP Crystal Reports. Our development team is currently looking into ways on how to resolve via SAP Crystal Reports and will advise us on the next step.

Kind regards
Irfaz


20 Apr 202309:18AM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 21-04-2023 03:12 PM Time Taken: 0.50

Bula Sanjay

Kindly refer to MCL case for FNPF report having spaces when generated in PDF.

Regards
Aarti


20 Apr 202310:35AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 20-04-2023 04:32 PM Time Taken: 4.00 Notes: ETC extended from: 18/08/2022 to 20/04/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.70

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

  1. Reviewed Report Paging formula. The report was initiating a new page after 20 records. Removed this paging formula.

3. Affected Areas:

  1. Superannuation Report - Monthly

4. The issue was caused by:

  1. The paging formula won't work where the employee's name wraps into the next line causing less than 20 records per page.

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


PART B -
Development Reference (Place descriptor for objects changed)
:


20 Apr 202311:49AM Comment 6 by Sanjay (Link Technologies) Case L12878 added to project 14.70
20 Apr 202302:28PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2023 04:24 PM Time Taken: 2.00
The following tests were performed:

Table 1 - Test Results

NoTest CaseExpected ResultPass/FailComments
1Generate report: Superannuation Report - Detail by Month" where data has pages where the number of rows exceeds 20 and some lines wrap into the next line (Long employee names)
The full page should be used. 
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


21 Apr 202307:58AM Comment 8 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2023 09:42 AM Time Taken: 2.00 Notes: Edited by aarti on 21/04/23 09:06. 
Bula Vinaka Sanjay

The following tests were performed: please connect the vertical lines so that they reach the bottom of the table. Kindly refer to Figure 1 and 2..

As discussed (Aarti & Sanjay), we can combine the First, Middle and Last Name to ensure that there are no name wraps.

The change should just be in report and the CS file should not be affected.

Test Setup Instructions:

  1. URL: 10.0.0.18/Linksoft
  2. Navigate to the Reports menu
  3. Select report ‘Superannuation Report - Detail by Month’
  4. Select the following report filter:
    1. Company: 
    2. Superannuation Fund: 'SUPE'
    3. Year: 2022
    4. Period: 7
  5. Generate using ‘PDF’ we noticed table format inconsistencies and this was the same issue when the report was generated in Crystal and then exported to PDF. Refer to Figure 1
  1. Select the following report filter:
    1. Company:
    2. Superannuation Fund: 'SUPE'
    3. Year: 2022
    4. Period: 8
  2. Generate using ‘PDF’ we noticed table format inconsistencies and this was the same issue when the report was generated in Crystal and then exported to PDF. Refer to Figure 2

Figure 1: Table Format Inconsistencies

Figure 2: Table Format Inconsistencies


21 Apr 202309:51AM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2023 11:07 AM Time Taken: 6.00 Notes: ETC extended from: 20/04/2023 to 26/04/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.70

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

  1. Changed vertical lines to reach the bottom of the page even when there are name wraps
  2. Merged "First Name, Middle Name and Last Name" into "Members Name" to save space
  3. Left Aligned "Member Number, Members TaxID, Employment Status, Employment Status Date and Payment Frequency" as these are Text Fields and it makes it easier to read
  4. Vertical Centered fields in the detail form
  5. Moved the "Powered By" outside the table

3. Affected Areas:

  1. Superannuation Report

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


21 Apr 202310:39AM Comment 10 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2023 12:33 PM Time Taken: 1.00
The following tests were performed:  Test Setup Instructions:


Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Superannuation Report - Detail by Month for Month of 7
Table should be consistent, "First Name, Middle Name and Last Name" should be under one column 
Pass
Both PDF and Crystal Reports displayed as required
2Superannuation Report - Detail by Month for Month of 8
Table should be consistent, "First Name, Middle Name and Last Name" should be under one column 
Pass
Both PDF and Crystal Reports displayed as required
3Superannuation Report - Detail by Month for Month of 10
Table should be consistent, "First Name, Middle Name and Last Name" should be under one column 
Pass
Both PDF and Crystal Reports displayed as required
4



5



Environment Details

  1. OS version: Win11
  2. Application version: 14.
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT-Client
    3. LinkSOFT URL: HTTP://LinkQA18/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


21 Apr 202310:49AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2023 12:48 PM Time Taken: 1.00
Thanks Aarti

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

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