Company: Link Technologies
Case No: L09519. Project: 10.10: LinkSOFT Version 10.1
Logged By: Vineet (Link Business Solutions) on 17 Aug 2018 07:58AM
Priority: High
Product: Payroll & HR
Group: Change Request
Time Taken: 42.25 (Weight: 42.25)
Version: 10.155.0117
Assigned To: Development
Circulation: Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Friday, 17 August 2018 07:58 AM [2073 days since logged date]
Status: Closed
Subject: Reddy Group GL Customization rebuild. [Created from case 9374]
Summary:    

Reddy Group GL Customization Details:

-------------------------------------------------------------------------------------------
1. File Definition. This will state the file type, fields, field lengths etc. This file needs to be output in CSV format.


Field

Type

Size

Column

Posting Date

Date

 

A

Document No.

Text

20

B

Account No.

Code

20

C

Description

Text

30

D

Amount

Decimal

 

E

Shortcut Dim 1

Code

20

F

Shortcut Dim 2

Code

20

G

Shortcut Dim 3

Code

20

H

Shortcut Dim 4

Code

20

I

Shortcut Dim 5

Code

20

J

Shortcut Dim 6

Code

20

K

Shortcut Dim 7

Code

20

L

Shortcut Dim 8

Code

20

M

  1. Column A = pay period ending date. (This is the Pay Bank Date from Linksoft)
              Format: dd/mm/yyyy
  2. Column B = paysequence number (pay number and pay run year from Linksoft)
  3. Column C = GL Account code/ Vendor code/ Bank Account code (Paycode GL Field from Linksoft)
  4. Column D = (max  30 characters, free text) (This is the description of the pay code from Linksoft)
  5. Column E = debits (positive value), credits (negative value)
  6. Column F =  Dim 1 (GL Code from Branch Table)
  7. Column G =  Dim 2 (GL Code from Cost Center  Table)
  8. Column H =  Dim 3 (Leave Blank)
  9. Column I =   Dim 4  (Leave Blank)
  10. Column J =   Dim 5  (Leave Blank)
  11. Column K =  Dim 6  (Leave Blank)
  12. Column L =  Dim 7  (Additional Field 1 of the Position in Linksoft)
  13. Column M = Dim 8 (Leave Blank)

2. For each rule, provide a sample and explain how the GL report will convert into the file. You can create a single sample that covers all rules


Rule#Rule DescriptionFunctioning ProperlyCommentsCase NumberNotes  (Development Design Notes)
1.

Grouping to be done by "Pay code", "GL Account", Branch, "Cost Centre" and "Additional field 1" in the Position Form( aka Manning)

  1. Description of "Pay code" needs to be populated in Column D.
  2. Group by Pay code, Branch, Cost Centre, and Manning
  3. Any GL account code that has a debit and credit of its own should not net off each other. Debit and Credit to show separately in the GL file.

Refer to Annexure 1, Rule 1 GL Grouping for details on this functionality.

No

Currently, we have a Group GL transactions at Pay codes menu of Linksoft. This Groups GL Journal lines by the full GL Account Code which is based on the configuration.

6777, 6830,9734

Design complete. Ok to proceed.

2.

Deductions with Group GL transactions flagged as No.

  1. For Deduction PayCodes, display "employee id" in column C instead of "GL account" from  Pay codes.
  2. The employee id should have a prefix 'E'.
  3. Deduction Pay codes should also display the GL code defined at "Branch Maintenance"  in column F. 

Refer to Annexure 1, Rule 2 Deduction Rule with GL Grouping as No for details on this functionality. 

Yes
7123


Design complete. Ok to proceed.

3.

NonTaxable Allowances Refund for Deductions with GL Grouping as No

  1. For non-taxable allowances "pay code" that have  "additional field 1" mapped to a deduction  "pay code" is treated as a refund for that deduction.
  2. The Group GL transactions for such pay codes is also set to No.
  3. The GL file for this line should display the "employee id" in column C instead of "GL account" 
  4. The "employee id" should have a prefix 'E'.
  5.  This entry should display the GL code defined at "Branch Maintenance" in column F. 


Refer to Annexure 1, Rule 3 Refund of Deduction with GL Grouping as No for a business scenario for details on this functionality.  

Yes
8399


Design complete. Ok to proceed.

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. 
Refer to Annexure 1, Rule 4&5  for details on this functionality.
Yes

1. It works fine for accounts set at 233.

6777, 6830


Design complete. Ok to proceed.

5

Rule to apply for pay code where pay classification is Banking or Deduction. The "GL grouping" for these pay codes is Yes

  1. The "GL account code" from "pay codes" menu should be displayed in column C. 
  2. Columns F to Column M will be left blank. 
Refer to Annexure 1, Rule 4&5  for details on this functionality.



Design complete. Ok to proceed.



6. 

Leave flagged as "One Time Accrual = Yes" and "Rollover Method = Calendar" should be expensed when taken.


 Refer to Annexure 1, Rule 6 Accrual of Leave Liability for details on this functionality.

No

7123

Design complete. Ok to proceed. 

Implement this in Standard Patch

7.

Create 10% Employer Superannuation and 1% Government Levy on leave accrual amount for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)

Yes



7123,8399

Design complete. Ok to proceed. 

8.

Commission on Pay Codes 

  1. All "Pay codes" with "Commission %" and "Commission GL code", should display the "Commission GL account" in Column C and calculated commission amount in Column E.
  2. The Description for this GL transaction to be "Commission"-"Commission%Value"-"Description of the Pay code".
  3. The Dimension for this GL Transaction should be left as blank
Refer to Annexure 1, Rule 8 Commission on Pay Codes for details on this functionality 
Yes



Design completed. OK to proceed.
9.

Employer Superannuation and Government Levy Debits Entries

Employer Superannuation and Government Levy will now have separate accounts. It will NO LONGER Split Employer Compulsory Super and Government Levy Expense account to the GL account Pay Codes where Employee has worked. 

Refer to Annexure 1, Rule 9 Employer Superannuation and Government Levy Debits Entries for details on this functionality.

No


9013 Design complete. Ok to proceed.

3. Annexure 1: Test Plan - Provide a few scenarios that cover all variations so that we can be sure that the changes we make comply with their requirement

Rule 1: Grouping to be done by "Pay code", "GL Account", Branch, "Cost Centre" and "Additional field 1" in the Position Form( aka Manning)

  1. Description of "Pay code" needs to be populated in Column D.
  2. Group by Pay code, Branch, Cost Centre, and Manning.
  3. Note: In this example I have not incorporated the FNTC levy and Employers superannuation in the debit entry. We will discuss that in detail in rule 9.

 Business Scenario

Employee 1132 and 1155 are paid Normal hours (ANHRS) of $215.20 each and Night allowance (NTALLOW) of $8 and $15 respectively.  

  • Group GL transactions for these pay codes (ANHRS and NTALLOW) is set to Yes
  • The GL account code set for both pay codes is 3001. 
  • The GL code set at the branch for both employees is TIH
  • The GL code set at Cost Centre for both employees is ADM
  • Both employees positions additional field 1 is populated with A02 as their manning.
  • The debit entry for this line should look as below.

14/08/2018

33-2018

3001

Normal Hours

     430.40

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3001

Night Allowance

       23.00

TIH

ADM

 

 

 

 

A02

 

Any GL account code that has a debit and credit of its own should not net off each other. Debit and Credit to show separately in the GL file.

Employee 1132 has

  • a leave transaction of 8 hours. 
  • paid at a rate of $5.38/hours. 
  • Annual leave Hotel 5 - 9 assigned to him and has periodic leave accruals of 2.62 hours per pay.
  • Employees bank account is BSP
  • The GL code set at the branch for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The employee manning is set as A02.

Pay code Setup:

  • ALH5 "GL account code" is set as 3004 and "Group GL transactions" is set to "Yes"
  • GL Account Leave Liability at menu 233 is set as 6109
  • BSP "GL account Code" is blank, "Creditor Code" is set as "TANOA" and "Group GL transactions" is set to "Yes"
  • Note: In this example I have not incorporated the FNTC levy and Employers superannuation in the debit entry. We will discuss that in detail in rule 9.

 

The GL output file for the above should look as below:

14/08/2018

33-2018

6109

Annual Leave Hotel 5-9 

  43.04

TIH

 ADM

 

 

 

 

 A02

14/08/2018

33-2018

Tanoa

Bank Of South Pacific 

   -  43.04 

  

 

 

 

 

 

 

14/08/2018

33-2018

3004

Annual Leave Hotel 5-9  

14.07

TIH

ADM

       

A02

14/08/2018

33-2018

6109

Annual Leave Hotel 5-9

-  14.07

TIH

ADM

       

A02

 

Rule 2: Deductions with Group GL transactions flagged as No.

  1. For Deduction PayCodes, display "employee id" in column C instead of "GL account" from  Pay codes.
  2. The employee id should have a prefix 'E'.
  3. Deduction Pay codes should also display the GL code defined at "Branch Maintenance"  in column F. 


Business Scenario:

Employee 1619 and 1947 are deducted Staff Loan of $100 and $200 respectively. The Pay code used for this deduction is FSL.

  • Group GL transactions for this pay code is No.
  • The GL code set at the branch for both employees is TIH
  • The credit entry for this line should look as below.

 

14/08/2018

33-2018

E1619

Staff Loan

-   100.00

TIH

 

 

 

 

 

 

14/08/2018

33-2018

E1947

Staff Loan

-   200.00

TIH

 

 

 

 

 

 

 

Rule 3: NonTaxable Allowances Refund for Deductions with GL Grouping as No

  1. For non-taxable allowances "pay code" that have  "additional field 1" mapped to a deduction  "pay code" is treated as a refund for that deduction.
  2. The Group GL transactions for such pay codes is also set to No.
  3. The GL file for this line should display the "employee id" in column C instead of "GL account" 
  4. The "employee id" should have a prefix 'E'.
  5.  This entry should display the GL code defined at "Branch Maintenance" in column F.  

Business Scenario

Employee 1155 and 1619 were paid shoe refund using pay code ESHOEREFUND with an amount as $5 and $10 respectively.  This indicates that 

  • this pay code has user-defined field 1 value set as FSHOEDEDUCT.
  • Group GL transactions for this pay code is No.
  • The GL code set at the branch for both employees is TIH
  • The Debit entry for this line should look as below.

14/08/2018

33-2018

E1155

SHOE REFUND

         5.00

TIH

 

 

 

 

 

 

14/08/2018

33-2018

E1619

SHOE REFUND

       10.00

TIH

 

 

 

 

 

 

 

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.

Rule 5: Rule to apply for pay code where pay classification is Banking or Deduction. The "GL grouping" for these pay codes is Yes

  1. The "GL account code" from "pay codes" menu should be displayed in column C. 
  2. Columns F to Column M will be left blank. 

Business Scenario for Rules 4 and 5.

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 set as "VF008" and "Group GL transactions" is set to "Yes"
  • FPAYE "GL account Code" is set as "VF036" and "Group GL transactions" is set to "Yes"
  • WBC "GL account 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

TIH

ADM

       

A02

14/08/2018

33-2018

TANOA

Westpac Banking Cooperation

-201.78

              


Rule 6: Leave flagged as "One Time Accrual = Yes" and "Rollover Method = Calendar" should be expensed when taken.

Business Scenario

Employee 1132 has

  • A leave transaction of 8 hours for leave Type BL.
  • Paid at a rate of $5.38/hours.
  • Employees bank account is BSP
  • The GL code set at branch for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The employee manning is set as A02.

Pay code Setup:

  • Leave code BL has Leave setup as "One Time Accrual" = 'Yes' and "Rollover Method" as "Calendar"
  • Pay code setup for pay code "BL" has "GL account code" set as 3008 and "Group GL transactions" is set to "Yes"
  • GL Account Leave Liability at menu 233 is set as 6109
  • BSP "GL account Code" set as "TANOA" and "Group GL transactions" is set to "Yes"

The GL output file for the above should look as below:

14/08/2018

33-2018

3008

Bereavement Leave  

43.04

TIH

ADM

       

A02

14/08/2018

33-2018

Tanoa

Bank Of South Pacific

-  43.04

              


Rule 7: Create 10% Employer Superannuation and 1% Government Levy on leave accrual amount for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)

Business Scenario

Employee 1132 :

  • Is paid at a rate of $5.38/hours. 
  • Has Annual leave Hotel 5 - 9 assigned to him and has periodic leave accruals of 2.62 hours per pay.
  • The GL code set at branch for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The employee manning is set as A02.. 
  • The GL code set at branch for for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The positions additional field 1 is populated with A02 as the manning.
  • ALH5 "GL account code" is set as 3004 and "Group GL transactions" is set to "Yes"
  • GL Account Leave Liability at menu 233 is set as 6109
  • The GL entry for this transaction should look as below.

14/08/2018

33-2018

3004

Annual Leave Hotel 5-9  

14.10

TIH

ADM

       

A02

14/08/2018

33-2018

3005

FNU Levy   

.14

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3006

FNPF Employer Contribution  

1.41

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

6109

Annual Leave Hotel 5-9

- 15.65 

TIH

ADM

       

A02

Employer Superannuation and Government Levy on Leave Taken

Employee 1132 :

  • Is paid at a rate of $5.38/hours. 
  • 2.62 hours of taken leave of leave type Annual leave Hotel 5 - 9
  • The GL code set at branch for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The employee manning is set as A02.. 
  • The GL code set at branch for for this employee is TIH
  • The GL code set at Cost Centre for this employee is ADM
  • The positions additional field 1 is populated with A02 as the manning.
  • ALH5 "GL account code" is set as 3004 and "Group GL transactions" is set to "Yes"
  • GL Account Leave Liability at menu 233 is set as 6109
  • GL account for Westpac Bank is Tanoa
  • The GL entry for this transaction should look as below.

14/08/2018

33-2018

6109

Annual Leave Hotel 5-9  

   15.65

TIH

ADM

       

A02

14/08/2018

33-2018

Tanoa

Westpac Banking Corporation

- 12.97 

              

14/08/2018

33-2018

VF006

Government Levy

- 0.14 

 

 

 

 

 

 

 

14/08/2018

33-2018

VF008

Employer Super Contribution

- 1.41 

 

 

 

 

 

 

 

14/08/2018

33-2018

VF008

Employee Superannuation Fund

- 1.13 

 

 

 

 

 

 

 

 

Rule 8: Commission on Pay Codes 

  1. All "Pay codes" with "Commission %" and "Commission GL code", should display the "Commission GL account" in Column C and calculated commission amount in Column E.
  2. The Description for this GL transaction to be "Commission"-"Commission%Value"-"Description of the Pay code".
  3. The Dimension for this GL Transaction should be left as blank

Business Scenario

Employee 1155 and 1132 are deducted $50 and $80 of BSP Life insurance every pay. BSP gives the employer 2.5% commission in collecting the premium on behalf of BSP Life. Pay code used for this deduction is FBSPLIFE.

Pay code Setup:

  • FBSPLIFE "GL account Code" set as "VB015, "Commission %" is set as 2.5 , "Commission GL Code" set as VR021 and "Group GL transactions" is set to "Yes". 

The GL file for Commission would look as below:

14/08/2018

33-2018

VR021

Commission-2.5%-BSP Life Assurance

-      3.25

 

 

 

 

 

 

 

Rule 9: Employer Superannuation and Government Levy Debits Entries

Employer Superannuation and Government Levy will now have separate accounts. It will NO LONGER Split Employer Compulsory Super and Government Levy Expense account to the GL account Pay Codes where Employee has worked.

Business Scenario

Employee 1155 is paid the following items in pay number 33

  • Normal Hours of $215.20 (ANHRS)
  • Night Allowance of $15   (NTALLOW)
  • A leave transaction of 8 hours. (ALH1)
  • Paid at a rate of $5.38/hours. 
  • Has Annual leave Hotel 0 - 4 assigned to him and has periodic leave accruals of 1.85 hours per pay. (ALH1)
  • Employees Net Wages is Deposited in Westpac Bank (WBC)
  • The GL code set at branch for this employee is TIH
  • The GL code set at Cost Centre for this employee 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"
  • ALH1 "GL account code" is set as 3004 and "Group GL transactions" is set to "Yes"
  • NTALLOW "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"
  • WBC "GL account Code" is set as "TANOA" and "Group GL transactions" is set to "Yes"
  • FSUPE "GL account Code" is set as "VF008" and "Group GL transactions" is set to "Yes"
  • HSUPE "GL account Code" is set as "3006" and "Group GL transactions" is set to "Yes"
  • HGOVL "GL account Code" is set as "3005" 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 complete GL file for the above scenario would look as below:

14/08/2018

33-2018

3001

Normal Hours

         215.20

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3001

Night Allowance

           15

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3005

FNU Levy

2.40

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3006

Employer Superannuation

24.02

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

6109

Annual Leave Hotel 0-4

           47.77

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

3004

Annual Leave Hotel 0-4

9.95

TIH

ADM

 

 

 

 

A02

14/08/2018

33-2018

6109

Annual Leave Hotel 0-4

-         11.05

TIH

ADM 

 

 

 

 

A02 

14/08/2018

33-2018

VF006

Government Levy

-            2.73

 

 

 

 

 

 

 

14/08/2018

33-2018

VF008

Employer Super Contribution

-         27.32

 

 

 

 

 

 

 

14/08/2018

33-2018

VF008

Employee Superannuation Fund

-         21.86

 

 

 

 

 

 

 

14/08/2018

33-2018

Tanoa

Westpac Banking Corporation

-       251.38

 

 

 

 

 

 

 


The rules above will be designed exactly as per the business scenario attached to each rule. Should there be any change or variation required to any of the rules, it would come at an additional cost which should be agreed between Reddy Group and Link Technologies.

Cost Justification:

We have invoiced the client $6806.25 VIP on 3 separate occasions for the GL files. Clients current version for their live environment is 8.13 and has not upgraded since that version since the GL file has not been up to their desired format when tested on UAT setup. We have upgraded client from:

  • 8.13 to 8.16
  • 8.13. to 8.18
  • 8.13 to 8.29. 
  • 8.13 to 9.33.004, then to 933.008 
  • and now from 8.13 for 9.49. 

The below additional changes was made by our team in relation to the framework and some issues had been logged for this client for the GL changes

  • 8665, 8802,9013.9094,9145
Now we have not actively resolved their issues since their last case in September 2017, hence this has built a certain level of frustration for the client. Given that they are one of our biggest clients and we would need to be in their good books for them to be our Payroll and HRIS applications referee, can we as a team sort this for once and for all. Let me know of your thoughts.

Vineet Ram

Audit Notes:Edited by sanjay on 05/03/19 10:45. Edited by vineet on 17/10/18 14:04. Edited by sanjay on 24/09/18 14:21. Edited by alvis on 10/09/18 13:49. Edited by vineet on 10/09/18 13:36. Edited by vineet on 10/09/18 13:22. Edited by vineet on 10/09/18 13:17. Edited by vineet on 10/09/18 12:56. Edited by vineet on 10/09/18 12:49. Edited by vineet on 06/09/18 12:49. Edited by vineet on 03/09/18 15:50. Edited by vineet on 03/09/18 14:28. Edited by vineet on 03/09/18 13:57. Edited by alvis on 03/09/18 13:27. Edited by vineet on 31/08/18 19:40. Edited by vineet on 31/08/18 19:22. Edited by vineet on 31/08/18 18:37. Edited by vineet on 30/08/18 22:00. Edited by vineet on 30/08/18 21:58. Edited by vineet on 30/08/18 21:09. Edited by sanjay on 29/08/18 15:32. Edited by vineet on 29/08/18 15:05. Edited by vineet on 29/08/18 15:00. Edited by vineet on 29/08/18 15:00. Edited by vineet on 29/08/18 14:58. Edited by vineet on 29/08/18 10:00. Edited by vineet on 29/08/18 09:44. Edited by vineet on 29/08/18 09:44. Edited by vineet on 28/08/18 10:44. Edited by sanjay on 20/08/18 15:05. 
17 Aug 201807:58AM Comment 1 by Vineet (Link Business Solutions) Created from case 9374
24 Aug 201809:27AM Comment 2 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 24-08-2018 09:27 AM

Hi Vineet,

We need to understand what the initial requirements were and what we quoted and we also need to understand how we built a customization that is 60% incorrect and was passed on to the customer.

Can you bring this to the next development meeting so we can discuss. The case does not state what the next step needs to be.

I suggest you update the case header with the following information before the next discussion:

  1. What was the initial requirement and what was the quote provided for?. Can you give us the case number where each rule was requested?
  2. For each item, we need a design, e.g. Rule 1 - How do we define "Group By" and the description of Pay code. Do we Hard Code this?

Can we meet on Tuesday next week (28th Aug) to discuss?

Regards
Sanjay



28 Aug 201810:46AM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-08-2018 10:46 AM Time Taken: 2.00

Hi Sanjay

The case header has been updated with the required details. I am available to meet at 2PM Fiji time today (28.08.2018). Let me know if the time is convenient for your team.

Regards
Vineet Ram 


29 Aug 201808:25AM Comment 4 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 29-08-2018 08:25 AM Time Taken: 2.00

Discussion notes for today's meeting:

Hi Vineet, here is what we need in order to develop this customization. These requirements would be exactly the same as what is required for any development work:

  1. File Definition. This will state the file type, fields, field lengths etc
  2. For each rule, provide a sample and explain how the GL report will convert into the file. You can create a single sample that covers all rules
  3. Test Plan - Provide a few scenarios that cover all variations so that we can be sure that the changes we make comply with their requirement

31 Aug 201807:49PM Comment 5 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 31-08-2018 07:49 PM Time Taken: 3.00

Hi Sanjay 

The requested tasks as per comment 4 has been added to the case header. Can we meet on Monday 03/09/2018 at 9am AEST to review and discuss the next step and time of delivery for this case.

Regards
Vineet Ram


03 Sep 201803:53PM Comment 6 by Vineet (Link Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 04-09-2018 12:00 AM Time Taken: 6.00

Development Meeting 
Vineet, Sanjay, Alvis

Design complete for all Rule except number 8. 

Next Step

  1. Review rule 8 (Vineet)
  2. Discuss Rule 8 with development team
  3. Once all rules are approved, discuss the outcome with the client and get sign off.
  4. Assign for Developmen

06 Sep 201801:20PM Comment 7 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-09-2018 01:20 PM Time Taken: 1.00

Hi Sanjay

As for Rule 8, any leave paid attracts Employer Superannuation and Government Levy. I have discussed this with Reddy Group and Fiji National Provident Fund. They have both advised the same. So we wouldn't have a problem when calculating the Superannuation and Government levy on Sold Leave. Case header has been updated.

Regards
Vineet Ram


24 Sep 201802:24PM Comment 8 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 24-09-2018 02:24 PM Time Taken: 1.00

Hi Vineet,

Items 1 and 2 have been completed from comment 6. You need to complete item 3 of comment 6. Please provide:

  1. Minutes of discussion with client
  2. who approved
  3. attach sign-off

regards
Sanjay/Alvis


17 Oct 201802:14PM Comment 9 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-10-2018 02:14 PM Time Taken: 2.00
Bula Vinaka Sanjay/Alvis

Attached is a copy of the sign off document from Reddy Group (Reddy Group GL Signoff V1.5.pdf). This has been signed off by the Group Financial Planning and Analysis Manager, Mr. Pranit Chand. Please kindly review and advise on timeline so that this case be relayed back to the client.

Regards
Vineet Ram


07 Nov 201808:45AM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-11-2018 08:45 AM
Hi Vineet, we will work on this as soon as we finish version 10. Most likely the first update after version 10 which we expect to start late in November.

07 Nov 201808:46AM Comment 11 by Sanjay (Link Technologies) Case 9519 added to project 10.X
26 Nov 201801:48PM Comment 12 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 26-11-2018 01:48 PM Time Taken: 1.00

Discussion between Vineet & Alvis

Rule 7 clarification

Create 10% Employer Superannuation and 1% Government Levy for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)"

  1. Leave accrual
    1. Debit: 
      1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Pay Code~>GL Account"
      2. 1% Government Levy on leave accrual amount. GL account is picked from the "Pay Code~>GL Account"
    2. Credit:
      1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
      2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
  2. Leave taken
    1. Debit: 
      1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
      2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
    2. Credit:
      1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Pay Code~>GL Account"
      2. 1% Government Levy on leave accrual amount. GL account is picked from the "Pay Code~>GL Account"

26 Nov 201804:16PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-11-2018 04:16 PM Time Taken: 16.00
Development work for this case has been completed as per the specifications on the case header.
The change will be available in version: 10.2

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

Added the following GL Journal File rules to Integration framework. These rules are read-only:

  1. CustomFileFormat - shows the file specification
  2. CustomRule1 - Grouping to be done by "Pay code", "GL Account", Branch, "Cost Centre" and "Additional field 1" in the Position Form( aka Manning)
  3. CustomRule2 - Deductions with Group GL transactions flagged as No.
  4. CustomRule3 - NonTaxable Allowances Refund for Deductions with GL Grouping as No
  5. CustomRule4 - 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" 
  6. CustomRule5 - Rule to apply for pay code where pay classification is Banking or Deduction. The "GL grouping" for these pay codes is Yes
  7. CustomRule6 - Leave flagged as "One Time Accrual = Yes" and "Rollover Method = Calendar" should be expensed when taken.
  8. CustomRule7 - Create 10% Employer Superannuation and 1% Government Levy on leave accrual amount for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)
  9. CustomRule8 - Commission on Pay Codes 
  10. CustomRule9 - Employer Superannuation and Government Levy Debits Entries

2. The issue was caused by:

  1. Change request

    3. Next Step

    1. UAT

    29 Nov 201808:30AM Comment 14 by Vineet (Link Business Solutions) Assigned To: Development Followup Date: 29-11-2018 08:30 AM Time Taken: 0.25

    Hi Alvis

    Further to our discussion on 26th November there was an issue with the credit section of the Leave Taken Transactions. Below is the rule to follow for leave taken Transactions to follow:

    Leave taken
    1. Debit: 
      1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
      2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
    2. Credit:
    1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>GL Account Super Liability "
    2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>GL Account Government Levy"
    Regards
    Vineet Ram

    10 Dec 201808:46AM Comment 15 by Alvis (Link Technologies) Case 9519 removed from project 10.2
    10 Dec 201808:46AM Comment 16 by Alvis (Link Technologies) Case 9519 added to project 10.1
    10 Dec 201801:26PM Comment 17 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-12-2018 01:26 PM Time Taken: 1.00

    These changes have been completed in version 10.1.3.3.

    Proceed with UAT.


    11 Dec 201802:05PM Comment 18 by Vineet (Link Business Solutions) Assigned To: Development Followup Date: 11-12-2018 02:05 PM
    ---Development Discussion Vineet Rashna, Alvis 11/12/208 for clarification on Leave Accruals and Leave Taken Journals ---

    Rule 7 clarification

    Create 10% Employer Superannuation and 1% Government Levy for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)"

    1. Leave accrual
      1. Debit: 
        1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Pay Code~>GL Account" from pay code 'HSUPE'
        2. 1% Government Levy on leave accrual amount. GL account is picked from the "Pay Code~>GL Account from pay code 'HGOVL'
      2. Credit:
        1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
        2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
    2. Leave taken
      1. Debit: 
        1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
        2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"
      2. Credit:
        1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>GL Account Super Liability "
        2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>GL Account Government Levy"

    Vineet


    11 Dec 201803:25PM Comment 19 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-12-2018 03:25 PM Time Taken: 1.00
    Development work for this case has been completed.
    The change will be available in version: 10.1.3.6

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

    Rule 7 has been corrected as per comment no 18. The updated rule description and changes made are in RED below.:

    Create 10% Employer Superannuation and 1% Government Levy for Leave flagged as "One Time Accrual = No" OR "Rollover Method IN (Anniversary, Other)"

    1. Leave accrual

    1. Debit:

            1.1.1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Pay Code [HSUPE]~>GL Account"

            1.1.2. 1% Government Levy on leave accrual amount. GL account is picked from the "Pay Code [HGOVL]~>GL Account"

        1.2. Credit:

            1.2.1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"

            1.2.2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"

    2. Leave taken

        2.1. Debit:

            2.1.1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"

            2.1.2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>Leave Liability Account"

        2.2. Credit:

            2.2.1. 10% Employer Superannuation on leave accrual amount. GL account is picked from the "Configuration~>GL Account Super Liability"

            2.2.2. 1% Government Levy on leave accrual amount. GL account is picked from the "Configuration~>GL Account Government Levy"

    3. Employee Rate Change

        3.1. Debit (Rate Increase) / Credit (Rate Decrease):

            3.1.1. 10% Employer Superannuation on leave liability difference amount (calculated before and after rate change). GL account is picked from the "Pay Code [HSUPE]~>GL Account"

            3.1.2. 1% Government Levy on leave liability difference amount (calculated before and after rate change). GL account is picked from the "Pay Code [HGOVL]~>GL Account"

        3.2. Credit (Rate Increase) / Debit (rate Decrease):

            3.2.1. 10% Employer Superannuation on leave liability difference amount (calculated before and after rate change). GL account is picked from the "Configuration~>Leave Liability Account"

            3.2.2. 1% Government Levy on leave liability difference amount (calculated before and after rate change). GL account is picked from the "Configuration~>Leave Liability Account"

    2. The issue was caused by:

    1. N/A

      3. Next Step

      1. UAT

      19 Dec 201803:12PM Comment 20 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 19-12-2018 03:12 PM Time Taken: 5.00

      All rules have been tested. Attached is the GL file and report for each rule.

      A comprehensive review of each rule will be done tomorrow before passing the case.


      20 Dec 201808:12AM Comment 21 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-12-2018 08:12 AM Time Taken: 1.00
      Since this case has been tested in accordance with the requirements, the next step will be to hand over to consulting to implement in the client's test environment and run UAT.

      09 Oct 201908:14AM Comment 22 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
      Attachments:
      General Documents - Case: 9519:10.1.3.7 Results.zip
      Reddy Group GL Signoff V1.5.pdf
      Reddy Group Sample GL Final.xlsx
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09519 in the subject line of all emails regarding this issue.

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