Subject: | ANZ Transactive File Format |
Summary: | Hi Sanjay,
ANZ has a new file format for payroll file. This is used by our client Navini. This is to be made standard in the application. Attached is the bank file format and sample from the bank for design. Details to Note. This is as per discussion with Melvin Lee in ANZ. - Payment Method should be ACH for payments in multiple banks. (Header item number 5)
- Payment Method should be BKT for direct ANZ payments. (Header item number 5)
- Customer Reference is what will be reflected in the customer statement. This can be stated as Payroll. (Payment Detail Record item number 3)
- Beneficiary Bank Code is the branch code. Branch code to be "ANZBFXXXXXX" for BKT format. (Payment Detail Record item number 12)
- Detail of Payment should have Organisation Name (Payment Detail Record item number 29). This field can support 12 digits on the portal.
Note : We are not removing the current diskpay format for ANZ as most clients are still using it.
Regards. Rashna
|
Audit Notes: | |
28 Apr 2017 | 03:00PM Comment 1 by Alvis (Link Technologies) Case 8485 added to project 8.12 |
05 May 2017 | 01:53PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-05-2017 01:53 PM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version: 8.12 Documentation update required(Yes/No. Add change details below): Yes QA required(Yes/No.Include areas that require testing): Yes
The following changes were made(Include Database object names, Program classes and any other relevant information): - Added ANZ Transactive file format to the direct bank credit interface.
Documentation details: |
|
23 May 2017 | 03:51PM Comment 3 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-05-2017 03:51 PM Time Taken: 2.00 |
| Hi Team,
This case has Failed.
1. Was this test completed using Demo / New / Other database? Demo V8120.000.BETA1 2. Did the test pass or fail? Fail 3. Tab order, spelling, alignment, font size consistency, screen size etc checked? 4. Data verified, saved, edit, delete/void? 5. Documentation update required?
Additional Details (Risks, issues, special conditions required for this test to pass etc):
The following has been identified with Fail status. You can follow the sample attached from the bank with our tested sample as well.
Table 01 : Header Record S/N | Field Name | Format | Out Put File | Comments | 5 | Payment Method | X(4) | 3 | Should be 4 characters in length | 6 | File Reference | X(35) | 34 | Should be 35 characters in length |
Table 02 : Payment Detail Record S/N | Field Name | Format | Out Put File | Comments | 2 | Payment Amount | N(15,3) | 18 | Should be 19 characters in length including "comma" as a separator for dollars and cents | 20 | Charges | C(3) | 3 | By default it should be "SHA" |
Regards Vinesh & Rashna
|
|
24 May 2017 | 08:48AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2017 08:48 AM Time Taken: 2.00 |
| Development work for this case has been completed. The change will be available in version: 8.12 Beta2 Documentation update required(Yes/No. Add change details below): QA required(Yes/No.Include areas that require testing): Yes
The following changes were made(Include Database object names, Program classes and any other relevant information): - Corrections have been made as per comment 3. Updates will be in beta2.
Documentation details: |
|
24 May 2017 | 03:21PM Comment 5 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 24-05-2017 03:21 PM Time Taken: 2.00 |
| Hi Alvis,
As per phone conversation with Melvin Lee from ANZ Bank, the only change that is required is below;
Table 02 : Payment Detail Record
S/N | Field Name | Format | Out Put File | Sample | 2 | Payment Amount | N(15,3) | 19
| -4783,000 |
The file should out put 19 characters separated by "dot" with 15 characters for dollar column and 3 characters for cents column E.g. -4783.000
Regards Vinesh
|
|
25 May 2017 | 08:17AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjeet (Link Business Solutions) Followup Date: 25-05-2017 08:17 AM Time Taken: 2.00 |
| Hi Sanjeet, In comment 3 you made us change the amount from decimal to comma. In comment 5 you are asking us to change from comma to decimal. Can you, Sanjeet and Rashna meet and confirm before we make any change. We will remove this case from 8.12 until we know what you want. regards Alvis/Sanjay |
|
25 May 2017 | 03:30PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 25-05-2017 03:30 PM Time Taken: 2.00 |
| Made the following changes to file format: - Removed negative sign before amount
- replaced comma with dot
- amount field is 19 characters long.
Sample output file is attached "anz_transactive_BETA3.txt". |
|
26 May 2017 | 10:59AM Comment 8 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 26-05-2017 12:00 AM Time Taken: 1.00 |
| Hi Team,
We have verified the ANZ Transactive file from our application V8120.000.BETA3 with the guideline provided by ANZ Bank.
We have sent a sample to Melvin Lee of ANZ Bank to confirm that the sample is correct before we can update the case further.
Regards Vinesh |
|
29 May 2017 | 07:48AM Comment 9 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Development Followup Date: 29-05-2017 12:00 AM Time Taken: 0.50 |
| Hi Team,
This case has been tested successfully and confirmation received from ANZ Bank.
1. Was this test completed using Demo / New / Other database? Demo V8120.000.BETA3 2. Did the test pass or fail? Pass 3. Tab order, spelling, alignment, font size consistency, screen size etc checked? 4. Data verified, saved, edit, delete/void? 5. Documentation update required?
Additional Details (Risks, issues, special conditions required for this test to pass etc):
Confirmation from Melvin Lee, ANZ Bank.
Hi Vineshwar
The file is correctly formatted and I was able to upload successfully.
Regards
Melvin Houng Lee | Client Implementation Manager-Level 1 ANZ House | Suva | Fiji P: +679 3213311 F: +679 3303649 | VN: 8702 3311 | M: +679 9908316 | E: Melvin.Hounglee@anz.com |
|