Company: Link Technologies
Case No: L11871. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 07 Jan 2020 07:25AM
Priority: Medium
Product: Payroll & HR
Group: New Feature
Time Taken: 5.00 (Weight: 5.00)
Version: 11.4.0903
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Thursday, 09 January 2020 09:32 AM [1780 days since logged date]
Status: Closed
Subject: Develop the EMS "ECAL" file for Fiji
Summary:    

Hi Alvis, as per FRCS requirement we need to create a new EMS file for ECAL - Environmental Levy.

Below are the requirements:

  1. FRCS has classified two file formats:
    1. Pre- Ecal EMS File - This contains the lump amounts paid in a period. ECAL calculated in LinkSOFT is not sent.
    2. Post- Ecal EMS File - This contains the lump amounts paid in a period and the ECAL amount calculated by LINKSOFT

Clients should have the option to select the file to submit.

Please find attached the file formats.

Audit Notes:Edited by rashna on 08/01/20 09:34. Edited by alvis on 08/01/20 09:33. Edited by rashna on 07/01/20 07:25. Edited by rashna on 07/01/20 07:24. 
08 Jan 202009:33AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-01-2020 09:32 AM

Development work for this case has been completed.

The change will be available in version:11.4.0108

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

  1. Added "Banking", "Super" & "Tax" submission forms in "payroll processing" in link web.
  2. ?Removed banking, super and PAYE electronic files from back-office
  3. Added dropdowns for "Bank File Format" and "Tax File Format"

2. Affected Areas:

  1. Banking Pay Submission
  2. ?Super Submission
  3. Tax Submission

3. The issue was caused by:

  1. New feature legislation

4. Notes
5. Next Step
: UAT


08 Jan 202009:33AM Comment 2 by Alvis (Link Technologies) Case L11871 added to project 11.4
09 Jan 202002:34PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-01-2020 02:13 PM Time Taken: 4.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 the "Bank File", "Superannuation" and "Tax File" menus are removed from BOPass
2

Generate the bank file for ANZ from "Bank Pay Submission".

  1. Process SYS001 should be executed without errors.
  2. The file should be generated without errors.
  3. The bank file should be added as an attachment.
  4. Users should be able to generate the "Banking Report".
Pass
3

Generate the EMS file from "Tax Submission".

  1. ?Process SYS001 should be executed without errors.
  2. The file should be generated without errors.
  3. The EMS file should be added as an attachment.


Pass
4

Generate the Super file from "Super Submission".

  1. ?Process SYS001 should be executed without errors.
  2. The file should be generated without errors.
  3. The Super file should be added as an attachment.

Pass
5

Generate and valid the contents of the Pre-Ecal Submission file.

  1. The file content should be as per the attached FRCS specification
Pass - See attached results.

Generate and valid the contents of the Post-Ecal Submission file.

  1. The file content should be as per the attached FRCS specification

Pass - See attached results

Environment Details

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

Next Step

  1. Documentation

    10 Jan 202008:24AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-01-2020 08:22 AM Time Taken: 1.00

    Hi Sanjay documentation has been completed. Documented following areas:

    1. Linkweb - Payroll Processing - Bank Pay Submission.
    2. Linkweb - Payroll Processing - Tax Submission
    3. Linkweb - Payroll Processing - Super Submission.
    4. Migrated documentation on "Bank File Formats" to LinkSOFT\LinkWebApplicationsPortal\Payroll Processing

    Thanks
    Rashna


    Attachments:
    General Documents - Case: L11871:Post ECAL - Test Results.csv
    Post-ECAL EMS Excel File Format.docx
    Pre ECAL - Test Results.csv
    Pre-ECAL EMS Excel File Format (003).docx
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11871 in the subject line of all emails regarding this issue.

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