Company: Link Technologies
Case No: L08935. Project: 09.40: LinkSOFT Version 9.4
Logged By: Vineshwar Prasad (Edge Business Solutions) on 23 Nov 2017 07:36AM
Priority: High
Product: Payroll & HR
Group: New Feature
Time Taken: 16.00 (Weight: 16.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, AwaitingApproval, Development, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 24 November 2017 12:00 AM [2318 days since logged date]
Status: Closed
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 
1Users with access should be able to generate the ANZ Transactive Direct Credit file.
2The file should be generated without errors
3The file should clearly outline the contents as per the file format and details in case header
4A sample file should be successfully uploaded on the ANZ Portal (Connect ANZ)
5The ANZ Transactive All Accounts File should remain the same 


Regards
Vinesh


Audit Notes:
01 Dec 201701: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 201810: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 201811: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.

  1. xml, csv or pc1 format.
  2. we need the timeline, when does this need to be put into production.

08 Feb 201810: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

  1. xml, csv or pc1 format.
    1. The format is pc.1
    2. Attached is the sample file for Transactive Direct file. 
      1. The database is in QA4 - LINKSOFT8935
      2. Pay run ID 436
    3. Changed required for the Transactive Direct file
      1. Header - Payment Method should be BKT
      2. Confidential indicator (starts position 86), should be Y
      3.  Confidential indicator (starts position 86), should be Y
      4. File format is attached for details
  2. we need the timeline, when does this need to be put into production.
  1. 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 201809: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 201809:23AM Comment 6 by Alvis (Link Technologies) Case 8935 added to project 8.3
14 Feb 201804: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 201803: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:

  1. Added new menu for "332-6-2-13-ANZ Transactive Direct"
  2. 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
  3. Added new screen in payroll for menu 332-6-2-13 ANZ transactive direct



16 Feb 201803: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 201811: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
NoTest 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 formatUntested due to item 3. 
 
6Transactive All file should be unchangedPass

QA Environment Details

  1. OS version:Windows 7
  2. Application version:9.2.3.0
  3. Database (Demo/New/Client): Demo LINKSOFT923 on QA4
  4. Client is QA1

Steps to reproduce failed scenarios:



    19 Feb 201801: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 201809: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 201811: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
    NoTest 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

    1. OS version:Windows 7
    2. Application version:9.2.4
    3. Database (Demo/New/Client): Demo - LINKSOFT on Q1

    Steps to reproduce failed scenarios:

    1. Create pay for employee E013.
    2. Generate the ANZ Transactive Direct Credit File
    3. When saving the file choose location "Desktop" and file name as "TransactiveDirect.pc1"
    4. Clicking ok, gives error

    Figure 1: Error

     


      21 Feb 201801: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 201806: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

      NoTest DescriptionPass/Fail
      1
      The header record should read "BKT" for Direct Transactive filePass
      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 formatPass. 
      6Transactive All file should be unchangedPass
      7Verify 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

      1. OS version:Windows 7
      2. Application version:9.2.5
      3. Database (Demo/New/Client): Demo LINKSOFT on QA1

      Steps to reproduce failed scenarios:

      Figure 1: Image



        26 Feb 201808: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 201810: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 201801: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 201803: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

        NoTest DescriptionPass/Fail
        1
        The header record should read "BKT" for Direct Transactive filePass
        2
        The Confidential Indicator should default to "Y"
        Pass
        3
        Users should be able to set the Mapping Number as "ANZBFJFXXXX" for ANZPass
        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 formatPass. 
        6Transactive All file should be unchangedPass
        7Verify that the banking report is correctly generated Pass

        Table 1 - Summarised list of issues
        1. Application version:9.2.6
        2. 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 201804: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 201808:14AM Comment 21 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2018 08:14 AM
          Thanks Rashna.

          09 Oct 201908: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
          Attachments:
          General Documents - Case: 8935:ANZ File Format.pdf
          SampletRansactivedirectfile.pc1
          TransactiveDirectBeta6.pc1
          If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08935 in the subject line of all emails regarding this issue.

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