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 2018 | 08: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 2018 | 09:54AM Comment 2 by Sanjay (Link Technologies) Case 9412 added to project 09.4 |
12 Jul 2018 | 12: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 2018 | 02: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):| - Created an integration in ESS -> Integration -> Integration Setup -> PAYDirectBankFile.
- Added 3 rules to this integration to define: EmailAddress, EmailBody and FileExtension
- 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: - PowerBuilder limitation.
3. Next Step - UAT
|
|
12 Jul 2018 | 03: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 2018 | 04: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 2018 | 02: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 2018 | 03: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 - The user should be able to enable the PAY integration without errors. - Pass
- The user should be able to configure the integration without errors. - Pass
- Email should be sent when the following bank files are generated - Pass
- 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
- Email should be sent when the PAYE files are generated. Consolidated file is also tested - Pass
- 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 2018 | 03:31PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-07-2018 03:31 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08: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 |