Company: Link Technologies
Case No: L11898. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 11 Feb 2020 08:54AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 7.00 (Weight: 7.00)
Version: 11.4.0903
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Sitla
Resolve By: Wednesday, 12 February 2020 12:00 AM [1745 days since logged date]
Status: Closed
Subject: EMS File Corrections in Version 11.
Summary:    

Hi Team, 

The following was discussed between Sitla and FRCS, 

  1. PayDay EMS reporting has been postponed to mid 2020.
    1. Users need to submit details in the format of  "EMS file prior to JAN 2020" as per  version 11.
  2. However, clients will use the PAYE formula updates made in July 2019.
Issue:
  1. FRCS has rejected the EMS file for prior 2020 format.
    1. The Header and Details length is 251 when it should be 250.
Please find attached the EMS file format and current output file.
Audit Notes:Edited by sanjay on 04/09/20 15:10. Edited by alvis on 25/02/20 16:29. Edited by alvis on 12/02/20 10:04. 
12 Feb 202010:04AM Comment 1 by Alvis (Link Technologies) Case L11898 added to project 11.5
12 Feb 202010:07AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-02-2020 04:04 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:11.5 0212

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

  1. Corrected the TaxID length in the EMS 2019 file submission format to 9 characters.
  2. The TaxID length is increased to 10 characters for new EMS 2020 file formats

2. Affected Areas:

  1. EMS 2019 file submission

3. The issue was caused by:

  1. Inconsistent length of TaxID was used for EMS 2019 (9 characters) and EMS 2020 (10 characters) file formats.

4. Notes: 
5. Next Step: UAT


19 Feb 202003:14PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-02-2020 08:24 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

Create a month for January 2019.

Generate the EMS file for date 01/01/2019 to 31/01/2019.

Validate that the file content is as per the attached format

Pass
2

Create a month for January 2020

Generate the EMS file for date 01/01/2020 to 31/01/2020

Validate that the file content is as per the attached format

Pass

Attached is the test results

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.5.0217
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: 

  1. We will forward the file to FRCS for a test upload and confirmation

    25 Feb 202003:33PM Comment 4 by Sitla (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 25-02-2020 09:29 PM Time Taken: 1.00

    Next Steps:

    1. Implement these changes in the current LinkSOFT production version (11.4). LT
    2. Package installation for deployment  - LT
    3. Upgrade clients to 11.4 - EBS

    25 Feb 202004:29PM Comment 5 by Alvis (Link Technologies) Case L11898 added to project 11.4
    26 Feb 202009:51AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-02-2020 03:43 PM Time Taken: 1.00

    Development work for this case has been completed.

    The change will be available in version:11.4

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

    1. Applied the fix to version 11.4

    2. Affected Areas:

    1. EMS 2019 file submission

    3. The issue was caused by:

    1. Inconsistent length of TaxID was used for EMS 2019 (9 characters) and EMS 2020 (10 characters) file formats.

    4. Notes: 
    5. Next Step    : UAT


    26 Feb 202003:28PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 27-02-2020 09:25 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

    Create a pay for date 31/12/2019.

    Generate EMS file. The content should be formatted as per attached version file specification v.5

    		Pass
    2

    Create a pay for date 01/01/2020.

    Generate EMS file. The content should be formatted as per attached version file specification v.5

    		Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 11.4.0226 GA
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-11-RASHNA

    Next Step: 

    1. Upgrade EBS to 11.4 as per comment 4.

      28 Feb 202002:14PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-02-2020 08:12 PM Time Taken: 1.00

      Internal System upgrade has been planned for 28/12/2020 at 4pm AEST. 

      This case is now closed.


      Attachments:
      General Documents - Case: L11898:111111111-099-2020-04-1.txt
      FRCS-Payroll-Speification-v5.01 (00000003).pdf
      Test File PAYE 2019.txt
      Test File PAYE 2020.txt
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11898 in the subject line of all emails regarding this issue.

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