Company: Link Technologies
Case No: L12343. Project: 12.50: LinkSOFT Version 12.50
Logged By: Rashna (Edge Business Solutions) on 26 Jul 2021 10:11AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 12.00 (Weight: 12.00)
Version: 12.50.0726
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Wednesday, 04 August 2021 09:39 PM [996 days since logged date]
Status: Closed
Subject: Deductions with "Includes Banking" is not included in the "ANZ Transactive" and "ANZ Transactive Direct" file - Ref case: L08485
Summary:    
  1. The issue has been replicated in the demo database using version 12.50.
  2. The client is on version 12.44.0713
  3. We need a fix for the client as the bank file is due at midday today. 

Steps to Replicate 

  1. Create a pay for employee E013 with the below banking components
    1. Net Pay - $4364.40
      1. ANZ - $4264.40
      2. Bred Bank - S100
    2. LICI Deduction - $50.00
  2. Generate the "Pay Component/Banking/Deduction" report and "Pay Edit Report". The total banking is $4414.40 (4364.40+100+50)
  3. Generate the "ANZ Transactive All" bank file. The record for LICI is not in the bank file.

Setup Details

  1. Server - 10.0.0.14
  2. Database - DEMO-LinkSOFT
  3. URL - http://linktechnologies.com.au/DEMO-LinkSOFT
  4. Login - admin/admin 
  5. Payrun ID - 465.
Audit Notes:Edited by sanjay on 26/07/21 10:11. Edited by sanjay on 26/07/21 08:37. 
26 Jul 202108:57AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sitla Sharma (Edge Business Solutions) Followup Date: 26-07-2021 02:37 PM Time Taken: 2.00

Hi Sitla, The amount is not appearing on the file as we have not included deductions. To include deductions, see notes below:

Notes:

As an example, if there are 5 employees being paid LICI deductions, can you confirm the following:

  1. Should the ANZ Transactive file have 1 line for LICI, if so, how does LICI know which account to allocate
  2. If you need 5 lines, where should we store the LICI account to allocate
  3. Customer Reference is hardcoded to "Payroll", should this be the customer account?

26 Jul 202109:04AM Comment 2 by Sanjay (Link Technologies) Case L12343 added to project 12.50
26 Jul 202110:06AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-07-2021 04:05 PM Time Taken: 1.00
Skype message from Sitla
Hi Sanjay, I have spoken with Melvin of ANZ and as we assumed, It really does not matter to the Bank, on how the Line payment is sent, as one bulk item or Individual. He has asked me to clarify with our clients as how they want it, as 20 cents per transactions are charged. I have Spoken with Mindpearl and they like the idea of bulk but will get further acceptance from Management team. I will now check with Coca Coal on their thoughts as well. No need to rush on this as Mindpearl has sent their file using ANZ All. So we have time till Thursday to fix this issue. I will update the case accordingly with CCA's views as well.

26 Jul 202110:10AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-07-2021 04:06 PM Time Taken: 7.00
PART A - Development work for this case has been completed.  
Since the file output does not include NON EMPLOYEE entries in the "ANZ Transactive" and "ANZ Transactive Direct" formats, we have made the following changes

1. The change will be available in version: 12.50.0726 (Paych Updated)

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

  1. Deductions are consolidated, therefore it does not relate to a specific employee
  2. Changed output file to included NON Employee entries
  3. Changed the Reference field from hardcoded "Payroll" to "Payroll - {Organication Name} "

3. Affected Areas:

  1. "ANZ Transactive" and "ANZ Transactive Direct" file formats

4. The issue was caused by:

  1. Incomplete Design

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


03 Aug 202105:50PM Comment 5 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-08-2021 09:39 PM Time Taken: 2.00 Notes: ETC extended from: 27/07/2021 to 04/08/2021
The following tests were performed:

Setup
  1. Pay Rate, Direct Credit and Deductions;
    1. Employee ID: E019
      1. Gross: 22,000.00
      2. Direct Credit: ANZ
      3. Deduction: FLICI - 20.00
      4. Deduction: FBSPL - 10.00
    2. Employee ID: E008
      1. Gross: 79,500.00
      2. Direct Credit: ANZ
      3. Direct Credit: WBC - 100.00
      4. Deduction: FLICI - 40.00
      5. Deduction: FBSPL - 10.00
  2. Pay Codes
    1. FLICI
      1. Type: Deduction
      2. Includes Banking
      3. Bank Code: BSP
    2. FBSPL
      1. Type: Deduction
      2. Includes Banking
      3. Bank Code: ANZ
Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1

Create Pay for Employee E019

  1. Net Pay - ANZ - 1,711.66
  2. Deduction - LICI - 20.00
  3. Deduction - FBSPL - 10.00
Pass
 
 2Create Pay for Employee E019
  1. Net Pay - ANZ - 5,793.76
  2. Net Pay - WBC - 100.00
  3. Deduction - LICI - 40.00
  4. Deduction - FBSPL - 10.00
 Pass
 
 3Generate Bank Pay Submission - Transactive All Accounts
  1. Bank Pay Submission Report - 7,685.42 [1,711.66 + 20.00 + 10.00 + 5,793.76 + 100.00 + 40.00 + 10.00]
  2. Verify Non-Employee Entries are consolidated
    1. LICI - 60.00 [20.00 + 40.00]
    2. FBSPL - 20.00 [10.00 + 10.00]
 Pass
 
 4Generate Bank Pay Submission - Transactive Direct Credit
  1. Bank Pay Submission Report - 7,525.42 [1,711.66 + 10.00 + 5,793.76 + 10.00]
  2. Verify Non-Employee Entries are consolidated
    1. FBSPL - 20.00 [10.00 + 10.00]
 Pass
 
5
Generate Bank Pay Submission - Transactive Direct Credit
  1. Verify Non-ANZ Bank Accounts are NOT included
Pass

Environment Details

  1. OS version:
  2. Application version:12.50.0726.GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database:DEMO-LinkSOFT
    3. LinkSOFT URL: http://linktechnologies.com.au/DEMO-LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Documentation


05 Aug 202110:13AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-08-2021 04:12 PM
Thanks Vineshwar

06 Aug 202101:25PM Comment 7 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-08-2021 07:21 PM

Hi Team,

ANZ has confirmed that the file upload was successful. Refer below email response.

Confirmation from Berillta Bonny.


Bula Sitla,

 

Kindly note that I have tested the file and it was uploaded successfully in our test environment.

 


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

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