Subject: | Create a new ANZ Transactive Direct Credit File |
Summary: | Hi Sanjay, Our client is using the ANZ Transactive Direct Credit file which needs to be designed as standard in our application.
The current Transactive file is for ALL bank accounts. We need to add a new file for ANZ Transactive Direct Credit.
Attached file format with the following fields specification for ANZ Transactive Direct Credit File.
1. In the Header Row (starts position 47), Payment Method should be BKT for direct ANZ payments. 2. Confidential indicator (starts position 86) , should be Y 3. Beneficiary Bank Code /SWIFT (starts position 624) , if you will use FJDBKT in Header Row use ANZBFJFXXXX as Beneficiary Bank Code /SWIFT Note: No changes to be done to the current ANZ Transactive All Accounts File Format. However we can rename its to different the Direct and All files.
Test Plan Test Number | Descripition | Status | 1 | Users with access should be able to generate the ANZ Transactive Direct Credit file. |
| 2 | The file should be generated without errors |
| 3 | The file should clearly outline the contents as per the file format and details in case header |
| 4 | A sample file should be successfully uploaded on the ANZ Portal (Connect ANZ) |
| 5 | The ANZ Transactive All Accounts File should remain the same |
|
Regards Vinesh
|
Audit Notes: | |
01 Dec 2017 | 01:19PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 01-12-2017 01:19 PM Time Taken: 1.00 |
| Development meeting: this is not an urgent requirement (sanjeet) |
|
12 Jan 2018 | 10:59AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-01-2018 10:59 AM Time Taken: 1.00 |
| Development meeting January 2018 Sanjay, Alvis, Sanjeet and Vineet. Rashna to analyse with all banks for the transition from pc1 to transactive. Check this wil all banks. Add the effective dates for each bank. Bring case to next development meeting with updates |
|
12 Jan 2018 | 11:08AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-01-2018 11:08 AM Time Taken: 0.50 |
| As part of the test please setup a database with transactions and provide the excepted text file for each format. - xml, csv or pc1 format.
- we need the timeline, when does this need to be put into production.
|
|
08 Feb 2018 | 10:07AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-02-2018 12:00 AM Time Taken: 1.00 |
| Hi Team, Below are the updates - xml, csv or pc1 format.
- The format is pc.1
- Attached is the sample file for Transactive Direct file.
- The database is in QA4 - LINKSOFT8935
- Pay run ID 436
- Changed required for the Transactive Direct file
- Header - Payment Method should be BKT
- Confidential indicator (starts position 86), should be Y
- Confidential indicator (starts position 86), should be Y
- File format is attached for details
- we need the timeline, when does this need to be put into production.
- we need this urgently as ANZ is waiting for us to implement this on site so Tappoo can go live with Transactive Banking.
Note: No changes to be done to the current ANZ Transactive All Accounts File Format.
|
|
13 Feb 2018 | 09:22AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-02-2018 09:22 AM |
| Sanjay and Alvis to review and come up with a design for next development meeting. |
|
13 Feb 2018 | 09:23AM Comment 6 by Alvis (Link Technologies) Case 8935 added to project 8.3 |
14 Feb 2018 | 04:55PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-02-2018 04:55 PM |
| Hi Guys, we have reviewed the case and given the effort quoted, we can only do this directly in Powerbuilder similar to other bank files. We can do this in either BETA 3 or 4. |
|
15 Feb 2018 | 03:30PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-02-2018 03:30 PM Time Taken: 4.00 |
| The following has been completed: - Added new menu for "332-6-2-13-ANZ Transactive Direct"
- Changed bank mapping screen to allow for 50 characters in mapping number. For "ANZ Transactive Direct" you can set the bank mapping for ANZ to ANZ as ANZBFJFXXXX
- Added new screen in payroll for menu 332-6-2-13 ANZ transactive direct
|
|
16 Feb 2018 | 03:54PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-02-2018 03:54 PM |
| Please proceed with UAT. |
|
19 Feb 2018 | 11:57AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 19-02-2018 11:57 AM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | The header record should read "BKT" for Direct Transactive file | Pass | 2 | The Confidential Indicator should default to "Y" | Pass | 3 | Users should be able to set the Mapping Number as "ANZBFJFXXXX" for ANZ | Failed. This is not saved. When we click on save, the status reads "Ready". We click on red x message appears "Do you want to save changes", if we click on "Yes", it is still not saved. | 4 | The output file should display the beneficinary code as "ANZBFJFXXXX".
| Failed due to item 3.
| 5 | Verify all content on the output file is as per the attached transactive file format | Untested due to item 3. | 6 | Transactive All file should be unchanged | Pass |
QA Environment Details - OS version:Windows 7
- Application version:9.2.3.0
- Database (Demo/New/Client): Demo LINKSOFT923 on QA4
- Client is QA1
Steps to reproduce failed scenarios:
|
|
19 Feb 2018 | 01:20PM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-02-2018 01:20 PM Time Taken: 1.00 |
| Resolved issue with saving record in beta4. |
|
21 Feb 2018 | 09:48AM Comment 12 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-02-2018 09:48 AM |
| Please UAT in BETA4. |
|
21 Feb 2018 | 11:19AM Comment 13 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 21-02-2018 11:19 AM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Users should be able to set the Mapping Number as "ANZBFJFXXXX" for ANZ | Pass | 2 | Users should be able to generate the "ANZ Transactive Direct File". | Failed. Refer to Figure 1. |
QA Environment Details - OS version:Windows 7
- Application version:9.2.4
- Database (Demo/New/Client): Demo - LINKSOFT on Q1
Steps to reproduce failed scenarios: - Create pay for employee E013.
- Generate the ANZ Transactive Direct Credit File
- When saving the file choose location "Desktop" and file name as "TransactiveDirect.pc1"
- Clicking ok, gives error
Figure 1: Error
|
|
21 Feb 2018 | 01:37PM Comment 14 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-02-2018 01:37 PM Time Taken: 1.00 |
| Resolved issue with printing banking report by increasing database field size for bank NBR field in the printing tables. Please UAT is beta5. |
|
23 Feb 2018 | 06:52PM Comment 15 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-02-2018 06:52 PM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary No | Test Description | Pass/Fail | 1 | The header record should read "BKT" for Direct Transactive file | Pass | 2 | The Confidential Indicator should default to "Y" | Pass | 3 | Users should be able to set the Mapping Number as "ANZBFJFXXXX" for ANZ | Pass | 4 | The output file should display the beneficinary code as "ANZBFJFXXXX". | Pass | 5 | Verify all content on the output file is as per the attached transactive file format | Pass. | 6 | Transactive All file should be unchanged | Pass | 7 | Verify that the banking report is correctly generated | Failed. The bank mapping is not successfully displayed on the report. Refer to Figure 1. |
QA Environment Details - OS version:Windows 7
- Application version:9.2.5
- Database (Demo/New/Client): Demo LINKSOFT on QA1
Steps to reproduce failed scenarios: Figure 1: Image
|
|
26 Feb 2018 | 08:18AM Comment 16 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-02-2018 08:18 AM Time Taken: 1.00 |
| Hi Rashna, We have increased the width of Bank column to allow for 10 characters. regards Alvis |
|
27 Feb 2018 | 10:28AM Comment 17 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-02-2018 10:28 AM Time Taken: 0.50 |
| System test completed. Ready for UAT. |
|
27 Feb 2018 | 01:42PM Comment 18 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-02-2018 01:42 PM |
| Hi Rashna, please proceed with UAT using 9.2.6 (Beta 6) |
|
27 Feb 2018 | 03:29PM Comment 19 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-02-2018 12:00 AM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary No | Test Description | Pass/Fail | 1 | The header record should read "BKT" for Direct Transactive file | Pass | 2 | The Confidential Indicator should default to "Y" | Pass | 3 | Users should be able to set the Mapping Number as "ANZBFJFXXXX" for ANZ | Pass | 4 | The output file should display the beneficinary code as "ANZBFJFXXXX". | Pass | 5 | Verify all content on the output file is as per the attached transactive file format | Pass. | 6 | Transactive All file should be unchanged | Pass | 7 | Verify that the banking report is correctly generated | Pass |
Table 1 - Summarised list of issues - Application version:9.2.6
- Database (Demo/New/Client): Demo : - LINKSOFT on Qa1
Steps to reproduce failed scenarios: Review attached Transactive Direct file. Name "TransactiveDirectBeta6.pc1". Case assigned for documentation. Figure 1: Pay Edit Report Figure 2: Pay Banking Report
|
|
28 Feb 2018 | 04:12PM Comment 20 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-02-2018 04:12 PM Time Taken: 1.00 |
| Hi Sanjay, The case has been tested as per comment 15. Documentation has been completed Documentation updated under Payroll -- Payroll Processing --Interface --ANZ Transactive Direct Credit |
|
01 Mar 2018 | 08:14AM Comment 21 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2018 08:14 AM |
| Thanks Rashna. |
|
09 Oct 2019 | 08: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 |