Company: Link Technologies
Case No: L11767. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 17 Oct 2019 01:06PM
Priority: Low
Product: Payroll & HR
Group: Enhancement
Time Taken: 10.00 (Weight: 10.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 30 October 2019 11:19 AM [1654 days since logged date]
Status: Closed
Subject: Incorporate Family Care GL code
Summary:    

Bula Vinaka Sanjay,

Colgate's GL customization is currently hardcoded in the system. There has been an introduction of a new leave this year as "Family Care".

Colgate wants to setup a different GL code for "Family Care" leave.

Please advise on the next step?

Regards
Aarti

Audit Notes:Edited by sanjay on 08/12/20 09:15. Edited by alvis on 29/10/19 08:10. Edited by alvis on 28/10/19 11:19. Edited by alvis on 17/10/19 13:06. Edited by alvis on 15/10/19 08:29. Edited by alvis on 09/10/19 16:49. Edited by alvis on 09/10/19 08:33. Edited by alvis on 08/10/19 11:13. Edited by alvis on 08/10/19 11:10. 
30 Sep 201905:28PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-09-2019 05:28 PM Time Taken: 4.00 Notes: Edited by alvis on 08/10/19 16:25. Edited by alvis on 08/10/19 11:12. 

Development work for this case has been completed.

The change will be available in version:11.004

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

  1. Removed hardcoded GL Account codes
  2. Created additional fields to build the GL Account code. See notes.

2. Affected Areas:

  1. Payroll FMIS integration to CSV file. Customized for Colgate

3. The issue was caused by:

  1. Improvement

4. Notes: 

  1. Additional Fields have been added to Pay Team.
  2. Additional Fields have been added to Paycode screen.
  3. Rules for building GL Account code:
  1. Paycode matches with "Pay Team ~> Paycodes" then: See Figure 1 
    - Br    anch code matches with "Pay Team ~> Branch Codes" then use "Pay Team ~> Branch GL Account Code". 
    - Branch code does NOT match with "Pay Team ~> Branch Codes" then use "Pay Team ~> GL Account Code".
  2. If GL Account is not configured above, then use "Paycode ~> GL Account". 
  3. If "Paycode ~> GL Account" is not configured then use: See Figure 2  
  1. Branch code matches with "Paycode ~> Branch Codes" then use "Paycode ~> Branch GL Account Code".
  2. Branch code does NOT match with "Paycode ~> Branch Codes" then use "Paycode ~> GL Account Code".
Figure 1:

Figure 2:


5. Next Step:

  1. UAT
  2. Send an invoice for 4 hours to Link Business Solutions

09 Oct 201908:33AM Comment 16 by Alvis (Link Technologies) Case 11767 added to project 11.004.BETA
09 Oct 201904:49PM Comment 17 by Alvis (Link Technologies) Case 11767 removed from project 11.004.BETA
09 Oct 201904:49PM Comment 18 by Alvis (Link Technologies) Case 11767 added to project 11.004.BETA
15 Oct 201908:29AM Comment 19 by Alvis (Link Technologies) Case 11767 removed from project 11.004.BETA
15 Oct 201908:29AM Comment 20 by Sanjay (Link Technologies) Case 11767 added to project 11.004.BETA
17 Oct 201901:06PM Comment 21 by Alvis (Link Technologies) Case 11767 removed from project 11.004.BETA
17 Oct 201901:06PM Comment 22 by Alvis (Link Technologies) Case 11767 added to project 11.004.BETA
25 Oct 201911:46AM Comment 23 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 02-10-2019 11:26 AM Time Taken: 2.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 new leave code as AFAMC - Family Care Leave.

Set the GL code at "Pay Code - Additional Fields "- GL Account Code" as 400080011.

Create and generate pay for employee 39100071  and verify that code for AFAMC in the GL integration report is 400080011  

Fails,

The GL section for AFAMC is blank in the "GL Integration Report"

2

Employee 39100071 belongs to pay team SAL.

Under SAL -  Set the GL code at "Additional Fields "- GL Account Code" as 400080012. Add "AFAMC' to the paycode list.
Set the GL code at "Pay Code - Additional Fields "- GL Account Code" as 400080011.

Create and generate pay for employee 39100071  and verify that code for AFAMC in the GL integration report is 400080012 

Pass


If a GL code is set at the PayTeam (Additional Fields)  and Pay code (additional field), systems should pick the GL at the PayTeam (Additional Fields). 

3

Employee 39100071 belongs to pay team SAL.

Under SAL -  Set the GL code at "Additional Fields "- GL Account Code" as 400080012. Add "AFAMC' to the paycode list
Under SAL -  Set the GL code at "Additional Fields "-Branch GL Account Code" as 400080013 and Branch as HQ.
Set the GL code at "Pay Code - Additional Fields "- GL Account Code" as 400080011.

Create and generate pay for employee 39100071  and verify that code for AFAMC in the GL integration report is 400080012

Pass
If a GL code is set at the PayTeam (Additional Fields), Branch Codes (Pay Team - Additional Filds)  and Pay code (additional field), systems should pick the GL at the Branch Codes (Pay Team - Additional Filds) 
4If a GL code is not set Paycode (Additional Filds) and Payteam then the system should pick the "GL Account" in the paycode headerPass
5If a code is set in all setups than the system should pick the code in this sequence - "PayTeam --Branch Code"Pass

Environment Details

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

Next Step: 

  1. Review

    28 Oct 201911:20AM Comment 24 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-10-2019 11:19 AM Time Taken: 2.00

    Development work for this case has been completed.

    The change will be available in version:11.4.1025

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

    1. Corrected blank GL account code as per test scenario 1

    2. Affected Areas:

    1. Payroll FMIS integration to CSV file. Customized for Colgate

    3. The issue was caused by:

    4. Notes: 
    5. Next Step    : UAT


    29 Oct 201910:36AM Comment 25 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 31-10-2019 10:35 AM 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 new leave code as AFAMC - Family Care Leave.

    Set the GL code at "Pay Code - Additional Fields "- GL Account Code" as 400080011.

    Create and generate pay for employee 39100071  and verify that code for AFAMC in the GL integration report is 400080011 

    		Pass

    Environment Details

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

    Next Step: 

    1. Documentation

      04 Dec 201902:31PM Comment 26 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-12-2019 02:03 PM Time Taken: 1.00

      Hi Sanjay, 

      Documentation has been updated at this link.

      Thanks
      Rashna


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

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