Company: Link Technologies
Case No: L09412. Project: 09.40: LinkSOFT Version 9.4
Logged By: Vineshwar Prasad (Edge Business Solutions) on 09 Jul 2018 08:32AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 11.00 (Weight: 11.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 29 June 2018 12:00 AM [2089 days since logged date]
Status: Closed
Subject: Invalid characters output on the ANZ transactive file
Summary:    

Issue: User unable to upload ANZ transactive file into the ANZ Portal. The client is using ANZ Transactive ALL accounts.

Error:

Findings:

  • We have found that when the file is XXXXXcted it includes an open quote at the beginning of the line. This has been identified for 2 employees. Refer to Figure 1.
    • Employee  E059, line 45
    • Employee E159, line 135
  • We have verified the "Employee Profile" and "Direct Credit" settings we could not identify any setup issues.

Test Environment

  • Client is on version 829.
  • The issue has been also replicated in 948 Beta 9
  • Database - CLIENT-SIXSENSE- LINKSOFT-948 on QA4
  • The file is attached in the case.

Figure 1: Incorrect File 


Audit Notes:
09 Jul 201808:38AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-07-2018 12:00 AM Time Taken: 1.00
Hi Rashna,

We have diagnosed this on-site, however, could not identify the cause of the extra character before the Identifier.



Database: LINKQA4
Database Name: CLIENT-SIXSENSE-LINKSOFT




12 Jul 201809:54AM Comment 2 by Sanjay (Link Technologies) Case 9412 added to project 09.4
12 Jul 201812:21PM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 12-07-2018 12:21 PM Time Taken: 2.00

This issue is caused by Powerbuilder framework placing the Quote in some lines.

To resolve the issue, we will utilize the dot net framework to send the bank file as an email attachment to the payroll email address.

This change will require all the banking interface to change.


12 Jul 201802:17PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-07-2018 02:17 PM Time Taken: 4.00
Development work for this case has been completed.
The change will be available in version: 9.4.8.9

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

  1. Created an integration in ESS -> Integration -> Integration Setup -> PAYDirectBankFile.
  2. Added 3 rules to this integration to define: EmailAddress, EmailBody and FileExtension
  3. Changed all bank integration in menu 332-6-2 to create the bank file and send an email with the file attached.

2. The issue was caused by:

  1. PowerBuilder limitation.

    3. Next Step

    1. UAT

    12 Jul 201803:12PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-07-2018 03:12 PM

    All bank file integrations for Payroll using this mechanism. Please UAT them.


    12 Jul 201804:41PM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-07-2018 04:41 PM
    We have also changed Superannuation Electronic File and Tax Electronic File to use integration framework to email the file.

    13 Jul 201802:53PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 17-07-2018 12:00 AM Time Taken: 2.00
    Case added to the documentation que

    13 Jul 201803:11PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 23-07-2018 12:00 AM Time Taken: 2.00

    Hi Sanjay, 

    This case has been successfully tested.

    Documentation has been completed at below areas.

    • Integration - Integration Setup
    • Payroll  -- Payroll Processing - Interface -- Direct Bank Credit
      • BSP Direct Credit
      • BSP All Accounts
      • WBC Direct Credit
      • WBC All Accounts
      • ANZ Direct Credit
      • ANZ All Accounts
      • HFC Direct Credit
      • ANZ Transactive All Account
      • ANZ Transactive Direct Credit
    • Payroll  -- Payroll Processing - Interface -- Superannuation Electronic File
    • Payroll  -- Payroll Processing - Interface -- PAYE Electronic File
    Test Plan
    1. The user should be able to enable the PAY integration without errors. - Pass
    2. The user should be able to configure the integration without errors. - Pass
    3. Email should be sent when the following bank files are generated - Pass
      1. BSP Direct Credit
      2. BSP All Accounts
      3. WBC Direct Credit
      4. WBC All Accounts
      5. ANZ Direct Credit
      6. ANZ All Accounts
      7. HFC Direct Credit
      8. ANZ Transactive All Account
      9. ANZ Transactive Direct Credit
    4. Email should be sent when the PAYE files are generated. Consolidated file is also tested - Pass
    5. Email should be sent when the superannuation files are generated. Consolidated file is also tested - Pass

    Test Environment

    • Version 948 Beta 11
    • LINKSOFTBETA10 on Qa1

    Thanks

    Rashna


    13 Jul 201803:31PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-07-2018 03:31 PM
    Thanks Rashna

    09 Oct 201908:14AM Comment 10 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: 9412:Weekending 17-6-18.PC1
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09412 in the subject line of all emails regarding this issue.

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