Company: Link Technologies
Case No: L11878. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 09 Jan 2020 01:05PM
Priority: High
Product: Payroll & HR
Group: Change Request
Time Taken: 10.00 (Weight: 10.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Monday, 16 December 2019 11:59 PM [1565 days since logged date]
Status: Closed
Subject: Reddy Group GL Enhancements
Summary:    

Bula Alvis,

Reddy Group required the below enhancement to their existing format: 

  1. Change in the current file name. 
    The current file name is "2019-11-20T101955-102101.csv" from which users are not able to identify which company and which pay team the file belongs too.
    For better understanding they required the file to be in the format of CompanyID- PayTeam-PayrunID-PayNo-PayDate.csv, for example: 1001-BIMTH-6099-20-20191231.csv



  2. Enhancement required in Rule 4: 

    Rule 4 : Rules to apply for entries where the GL account is defined in 233 as "GL Account Government Levy", "GL Account Leave Liability", "GL Account Super Liability", "GL Account Tax on Benefit Liability", "GL Account Non-Cash Benefit", "GL Account Non-Pay Items Liability " 

    1. All accounts set at payroll configuration (Menu 233) should display the account number in column C.

    2. For these entries, Columns F to Column M will be left blank except for leave liability GL. For leave liability GL, all dimensions needs to be displayed

     

    Business Scenario for Rules 4

    Employee 1155 is paid the following items in pay number 33

    • Normal Hours of $215.20 (ANHRS)

    • Night Allowance of $15   (NTALLOW)

    • Employer Superannuation deducted of $23.02 (HSUPE)

    • Employee Superannuation of $18.42 (FSUPE)

    • Pay as you earn Tax of $10 (FPAYE)

    • Leave Accruals of $9.93 (ALH1)

    • Employees Net Wages is Deposited in Westpac Bank  $201.78 (WBC)

    Employees Dimensions

    • The GL code set at branch for this employees is TIH

    • The GL code set at Cost Centre for both employees is ADM

    • The employee manning is set as A02.

    Pay code Setup:

    • ANHRS "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

    • NTALLOW "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

    • HSUPE  "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

    • FSUPE "GL account Code" is blank, "Creditor Code" is set as "VF008" and "Group GL transactions" is set to "Yes"

    • FPAYE "GL account Code" is blank, "Creditor Code" is set as "VF036" and "Group GL transactions" is set to "Yes"

    • WBC "GL account Code" is blank, "Creditor Code" is set as "TANOA" and "Group GL transactions" is set to "Yes"

    • GL Account Leave Liability at menu 233 is set as 6109

    • GL Account Government Levy at menu 233 is set as VF006

    • GL Account Super Liability at menu 233 is set as VF008

    The GL output file for Superannuation Liability (Credit Entry), Government Levy Liability (Credit Entry), Pay as You earn Liability (Credit Entry), Leave Liability (Credit Entry), Banking amount (Credit Entry) and Duavata Saminiti Club Refund (Debit Entry)would look as below:

    14/08/2018

    33-2018

    VF008

    Employer Super Contribution 

          - 23.02


     

     

     

     

     

     

    14/08/2018

    33-2018

    VF008

    Employee Superannuation Fund 

        - 18.42


     

     

     

     

     

     

    14/08/2018

    33-2018

    VF006

    Government Levy

    -   2.30








    14/08/2018

    33-2018

    VF036

    PAYE

    -    10








    14/08/2018

    33-2018

    6109

    Annual Leave Hotel 0-4

    - 9.93

    TIHADM



    A02

    14/08/2018

    33-2018

    TANOA

    Westpac Banking Cooperation

    -201.78








Please review.

Regards
Aarti

Audit Notes:Edited by alvis on 08/12/20 09:36. Edited by alvis on 13/01/20 15:20. 
16 Dec 201908:57AM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) Created from case T11757
13 Jan 202009:56AM Comment 2 by Alvis (Link Technologies) Case L11878 added to project 10.1
13 Jan 202003:19PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-01-2020 05:58 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:10.155 & 11.5

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

  1. Changed Journal file name format in version 11.5 to <CompanyID>-<PayTeamCode>-<PayrunID>-<PayNo>-<PayDate in format YYYYMMDD>-<datetimestamp>.<FileExtension>. We cannot change the filename format in version 10 due to framework limitations.
  2. Changes to rule 4 as requested in case header

2. Affected Areas:

  1. Reddy Group GL Journal Output file

3. The issue was caused by:

  1. Change request

4. Notes
5. Next Step
: UAT


14 Jan 202003:50PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 14-01-2020 03:39 PM Time Taken: 3.00 Notes: Edited by rashna on 14/01/20 15:53. 
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

Setup  the paycodes as below.

  • ANHRS "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

  • NTALLOW "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

  • HSUPE  "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

  • FSUPE "GL account Code" is blank, "Creditor Code" is set as "VF008" and "Group GL transactions" is set to "Yes"

  • FPAYE "GL account Code" is blank, "Creditor Code" is set as "VF036" and "Group GL transactions" is set to "Yes"

  • WBC "GL account Code" is blank, "Creditor Code" is set as "TANOA" and "Group GL transactions" is set to "Yes"

  • GL Account Leave Liability at menu 233 is set as 6109

  • GL Account Government Levy at menu 233 is set as VF006

  • GL Account Super Liability at menu 233 is set as VF008

Generate the Journal File the Account No should be reflected as above

Fails, the "Account No" is not generated for pay codes where the code is set at "Creditor Code".

This does not meet the result in the case header



Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 10.155.0113
  3. Setup: Demo
  4. Server : LINKQA4\CP42
  5. Database: CLIENT-REDDY-LINKSOFT
  6. Payrun -2600

Next Step

  1. Review

    15 Jan 202010:04AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-01-2020 01:23 PM Time Taken: 2.00

    The account code is blank because there is no GL Account Code in the pay code setup. Refer to custom rule 5.


    16 Jan 202009:46AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-01-2020 01:43 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
    1FSUPE "GL account Code" is blank, "Creditor Code" is set as "VF008" and "Group GL transactions" is set to "Yes"
    The "GL account code" from "pay codes" menu should be displayed in column C. - Passing case based on custom rule 5.

    Environment Details

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

    Next Step: 

    1. Closure

      08 Dec 202009:36AM Comment 7 by Alvis (Link Technologies) ETC was changed from 16/12/2019 to 16/12/2019
      Attachments:
      General Documents - Case: L11878:Results Rule 4.csv
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11878 in the subject line of all emails regarding this issue.

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