Company: Link Technologies
Case No: L12195. Project: 12.30: LinkSOFT Version 12.30
Logged By: Alvis (Link Technologies) on 09 Mar 2021 04:55PM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 20.00 (Weight: 20.00)
Version: 12.32
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Tuesday, 09 March 2021 12:00 AM [1136 days since logged date]
Status: Closed
Subject: Tax Submission Data View Improvements

When viewing data in Tax Submission, the system recomputes the values then displays the data in grid.

The following issues can arise from this method:

  1. History data can be different when the pay code classification changes.
  2. Recompute of view data takes approx 40-50s on a large database and can have huge impact on performance.

Recommended solution:

  1. Create a detail table that holds the values for the tax submission. This table is populated as part of the background process that creates the file.
  2. When viewing data, do not recompute values, rather pick these from the detail table.

Audit Notes:Edited by sanjay on 12/03/21 15:52. 
10 Mar 202110:01AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2021 01:55 PM Time Taken: 18.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.32.0310

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

  1. Created a database table to store data for the tax submission. This table is populated as part of the background process that creates the file.
  2. When viewing data, we do not need to recompute the values, rather pick these from the detail table
  3. If data is not available, the system will compute the data and store it in the new table. This means that "Tax Submissions" that were done before this change is applied will take some time to compute for the first time. After the compute, the view will be fairly quick.

3. Affected Areas:

  1. Payroll Tax Submission

4. The issue was caused by:

  1. Performance improvement. View data for tax submissions had a lot of computations and was taking over 40 seconds for 200 records on MLC database. 

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


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

1. Changes implemented was according to the approved design (Y/N): Yes

2. Other relevant notes:

12 Mar 202103:52PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-03-2021 07:52 PM Time Taken: 1.00

16 Mar 202110:39AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-03-2021 02:34 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
1Validate that a table has been added for "Tax Submission" Pass
2Generate an EMS file for a pay run. This should update the record in the "LT_Pay_Submission" table.Pass
3View data from LinkSOFT, this should load the record without much delayPass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.32.32BETA
  3. Setup: Demo
  4. Server :
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Closure

    18 Mar 202108:48AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-03-2021 12:48 PM
    Thanks Rashna

    If you have any queries regarding this support incident, please email and include the Case No: L12195 in the subject line of all emails regarding this issue.

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