Company: Link Technologies
Case No: L08485. Project: 08.20: LinkSOFT Version 8.2
Logged By: Rashna (Edge Business Solutions) on 24 Apr 2017 01:41PM
Priority: High
Product: Payroll & HR
Group: New Feature
Time Taken: 15.50 (Weight: 15.50)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjeet, Vineshwar Prasad
Resolve By: Tuesday, 25 April 2017 12:00 AM [2531 days since logged date]
Status: Closed
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.

  1. Payment Method should be ACH for payments in multiple banks. (Header item number 5)
  2. Payment Method should be BKT for direct ANZ payments. (Header item number 5)
  3. Customer Reference is what will be reflected in the customer statement. This can be stated as Payroll. (Payment Detail Record item number 3)
  4. Beneficiary Bank Code is the branch code. Branch code to be "ANZBFXXXXXX" for BKT format. (Payment Detail Record item number 12)
  5. 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 201703:00PM Comment 1 by Alvis (Link Technologies) Case 8485 added to project 8.12
05 May 201701: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):

  1. Added ANZ Transactive file format to the direct bank credit interface.

Documentation details:
  

23 May 201703: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 201708: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):

  1. Corrections have been made as per comment 3. Updates will be in beta2.

Documentation details:
  

24 May 201703: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 201708: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 201703: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:

  1. Removed negative sign before amount
  2. replaced comma with dot
  3. amount field is 19 characters long.

Sample output file is attached "anz_transactive_BETA3.txt".


26 May 201710: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 201707: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

Attachments:
General Documents - Case: 8485:anz_transactive_BETA3.txt
bankfile.pc1
Fixed Length File Format.pdf
Sample
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08485 in the subject line of all emails regarding this issue.

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