Company: Link Technologies
Case No: L12368 Project: 13.03: LinkSOFT version 13.03
Logged By: Rashna (Edge Business Solutions) on 19 Aug 2021 01:25PM
Priority: Medium
Product: Payroll & HR
Group: Change Request
Time Taken: 5.00 (Weight: 5.00)
Version: 13.00.0827
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Sitla Sharma
Resolve By: 30 Aug 2021 [34 days since logged date]
Status: Closed
Subject: Include "Employee ID" in the "ANZ Disk File and ANZ Transactive Files"
Summary:    
Section A - Describe what the request/issue is about 
  1. Coca-Cola is using the ANZ bank file.
  2. They are currently on version 12.42 and using the "ANZ Disk File".
  3. They will start to use ANZ All Transactive File in the future post "File Active" activation. The timeline for this is not known. 
  4. Their auditors have made the statement to include the "Employee ID" in the bank file for reporting. 
    1. For example, employee E001's pay is split into 3 banks.
    2. The account number and name for one of the banks is for the employee's spouse, hence the employee ID is to required to know for which employee is the transaction for.
  5. Hence, CCA has requested to include the "Employee ID" in both the "ANZ DIsk File" and "ANZ Transactive All file".
Current Design
  1. ANZ Transactive All file has been designed with this specification.
  2. The Disk Pay format has been attached to the case.
Design Request
  1. Add the employee ID in the "Beneficiary Code" field in record number 4 in the "ANZ Transactive All File".
    1. The beneficiary code for the employee pay records to be the "Employee ID"
    2. The beneficiary code for the deduction records to be the "Deduction Pay Code"
  2. Add the employee ID in the "SPARE" field after the "Employee Name" in the "Disk Pay File Format"

Section B - Cost Information:

1. Request Information
 ID
Description (*Required Fields)Value
 1Customer Name*Coca Cola 
 2Estimated Cost (hrs/$)
 3Cost Covered By *
 4Workarounds?None
 5 Date Required by *31/08/2021

2. Costing

 IDTask DescriptionEstimated Hours
 1Analysis and Design 
 2Development 
 3System test and QA
 4Documentation

Section C - Provide a Test plan - List out at least two scenarios that will be used to verify
  1. Create a pay for employee E001 with the below bank setups
    1. ANZ - 0, Account Name - Sanjay Singh
    2. BSP - $250, Account Name - Sanjay Singh
    3. Bred - $100, Account Name - John Singh
    4. Create the bank files for and validate that the "Employee ID" is E001 for all 3 records.
  2. Add a LICI direct deduction for the employee, the employee ID should not  output as the LICI is grouped for all employees

Audit Notes:Edited by sanjay on 27/08/21 13:08. Edited by sanjay on 25/08/21 07:48. Edited by rashna on 20/08/21 07:58. Edited by rashna on 19/08/21 13:25. Edited by rashna on 19/08/21 13:24. Edited by rashna on 19/08/21 12:49. Edited by rashna on 19/08/21 12:45. Edited by rashna on 19/08/21 12:30. 
19 Aug 202101:14PM Comment 1 by Sanjay (Link Technologies) Case L12368 added to project 99.99
19 Aug 202101:16PM Comment 2 by Sanjay (Link Technologies) Case L12368 removed from project 99.99
19 Aug 202101:24PM Comment 3 by Rashna (Edge Business Solutions) Case L12368 added to project 99.99
20 Aug 202108:12AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Follow up Date: 24/08/2021 Time Taken: 1.00

Hi Sanjay, 

As per the development meeting on 19/08/2021 case has been assigned for review and project allocation.

Thanks
Rashna


24 Aug 202101:18PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sitla Sharma (Edge Business Solutions) Follow up Date: 25/08/2021 Time Taken: 1.00
Hi Sitla, Cost for change as follows:

CASE L12368 - Include "Employee ID" in the "ANZ Disk File and ANZ Transactive Files"
1Analysis and Design2150300.00
2Development4150600.00
3System Test and Documentation2150300.00
   1200.00
Reseller Margin:
Rate:
20%240.00
Payment Terms: Payment based on Link Licence System
Total (FJD):
1440.00


24 Aug 202105:07PM Comment 6 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Follow up Date: 30/08/2021 Notes: ETC extended from: 20/08/2021 to 30/08/2021
Hi Sanjay, Please go ahead with the Development.

25 Aug 202107:48AM Comment 7 by Sanjay (Link Technologies) Case L12368 added to project 13.00
25 Aug 202107:50AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Follow up Date: 26/08/2021

Licence cost updated.

Proceed with Development.


25 Aug 202108:33AM Comment 9 by Alvis (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Follow up Date: 26/08/2021 Time Taken: 1.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.00.0825

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

  1. Added "EmployeeID" and "Deduction Paycode" to the ANZ file formats:
    1. "ANZ All Accounts" and "ANZ Direct Credit" file formats -> Employee ID / Deduction Paycode is added to the "Spare" field
    2. "ANZ Transactive All" and "ANZ Transactive Direct Credit" file formats -> Employee ID / Deduction Paycode is added to the "Beneficiary Code" field 

3. Affected Areas:

  1. {ayroll Processing -> Bank Pay Submission:
    1. ANZ All Accounts
    2. ANZ Direct Credit
    3. ANZ Transactive All Account
    4. ANZ Transactive Direct Credit

4. The issue was caused by:

  1. N/A - This is a change request

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


27 Aug 202101:14PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Follow up Date: 31/08/2021 Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Create a pay below employee and details
    1. E016 - Banking - ANZ and LICI
    2. E082 - Banking - ANZ, WBC
 Pass 
 2
  1.  Validate that the "Employee ID and Deduction Code" are listed in the below files
    1. ANZ All Accounts
    2. ANZ Direct Credit
    3. ANZ Transactive All Account
    4. ANZ Transactive Direct Credit
 Pass 

Environment Details

  1. OS version:
  2. Application version: 13.00.826GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database: UAT-LinKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


30 Aug 202109:27AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Follow up Date: 31/08/2021 Time Taken: 1.00
Thanks Rashna

Attachments:
General Documents - Case: L12368:ANZ Disk Pay format.DOC
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12368 in the subject line of all emails regarding this issue.

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