Company: Link Technologies
Case No: L12018. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 07 Aug 2020 02:46PM
Priority: Medium
Product: Payroll & HR
Group: New Feature
Time Taken: 19.00 (Weight: 19.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay, Sitla, Vineshwar Prasad
Resolve By: Thursday, 10 September 2020 11:59 PM [1567 days since logged date]
Status: Closed
Subject: Create the output file for HFC All Banks
Summary:    

National Fire Authority is contracted with EBS and is using LinkSOFT version 11.4 for Payroll and HR.

The client is using the HFC bank for payroll processing and wants to use the "HFC All Bank" file. We do not have this feature in LinkSOFT.

HFC has provided the specification for the bank file

  1. Attached is the file specification labeled "HFC Bank File 003_06Jun17".
  2. Page 8 of the document has the sample output.
  3. Pages 9 and 10 contain developer notes.
Audit Notes:Edited by rashna on 14/09/20 08:17. Edited by rashna on 14/09/20 08:16. Edited by rashna on 14/09/20 08:16. Edited by rashna on 26/08/20 16:00. Edited by rashna on 26/08/20 16:00. Edited by rashna on 07/08/20 14:46. Edited by rashna on 07/08/20 14:25. Edited by rashna on 07/08/20 13:08. 
07 Aug 202002:25PM Comment 1 by Rashna (Edge Business Solutions) Case L12018 added to project 12.0
13 Aug 202006:00PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-10-2020 06:00 PM Notes: ETC extended from: 08/08/2020 to 14/10/2020
Allocated for development

21 Aug 202009:21AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 25-08-2020 09:05 AM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:12.0.0821

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Added HFC All accounts file format
  2. Changed the banking entries listed in file to be restricted by the "Banks" listed in "Company Administration -> Bank -> Number Mapping".
    This restriction can be used to achieve the following objective:
    A company has bank accounts in ANZ, BSP & HFC. The organisation wants to send a direct file to BSP and HFC. All other remaining employees are paid from the ANZ account.

2. Affected Areas:

  1. Pay Bank Submission

3. The issue was caused by:

  1. New feature

4. Notes: Important notes for Documentation

  1. File format for HFC All accounts is ".pc2". Configure this in "Integration -> PAYDirectBankFile -> FileExtensionHFCAll"
  2. Configure the BSB information for each bank in the menu "Company Administration -> Bank -> Number Mapping". The list of BSB numbers is available in the HFC bank file documentation attached in this case.

5. Next Step:

  1. UAT - send a sample file format to HFC for verification and approval
  2. Documentation

----------------------

Development Reference:



26 Aug 202004:00PM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 14/10/2020 to 14/10/2020
31 Aug 202003:05PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 01-09-2020 03:01 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Created a pay for employees with below "Bank Direct Credit" option

  1. E013 - AN
  2. E019 - Westpac and BSP
  3. A008- ANZ and HFC

Generated the bank file for HFC all in format .pc2. 

Validated that the content of the output file is as per the attached specification

Pass


Attached is the output


Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.0.0.831
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-12-RASHNA

Next Step: 

  1. Bank file will be sent to the bank for confirmation

    10 Sep 202012:53PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 11-09-2020 12:52 PM Time Taken: 1.00 Notes: Edited by rashna on 10/09/20 12:55. ETC extended from: 14/10/2020 to 11/09/2020

    Hi Alvis, 

    The attached bank file was sent to HFC for confirmation. HFC has failed the test. Attached is their test "HFC BANK UAT NFA PAYROLL FILE FORMAT.

    Thanks
    Rashna


    10 Sep 202003:58PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-09-2020 03:45 PM Time Taken: 2.00

    Refer to my comments below. Can you discuss the same with HFC for test case number 4?

    Number

    TEST CASE

    EXPECTED RESULT

    ACTUAL RESULT

    TEST CASE OUTCOME

     

    COMMENTS

     

    1

    File Extension to be Filename.pc2

    File Extension was Filename.pc2

    File Extension was “.pc2” as the actual file name provided was LinkPAYDirectBankFile_20200131_HFC_446 (1).pc2

     

    PASSED

     

    2

    Able to read header line

    Able to read header line

    Header line error occurred due to 111111 at the position where 000007 was supposed to have been found at that position

     

    RETURN TO DEVELOPER

     [Alvis] - The number 000007 should be entered in the menu "Company Administration -> Bank -> expand entry: HFC and enter the "Reg No"

    3

    Able to read transaction lines

    Able to read transaction lines

    We had to skip the header line to check on the transaction line.

    Total of TranCode “53” equal TranCode “13”.

    PASSED

     

    4

    Able to read Bank Summary lines

    Able to read Bank Summary lines

    Bank summary lines don’t match up with sum of the transaction lines for “53”.

    This is what it should have looked like in the file:

     

    7999-999            000144444100014444410000000000                        000005                                                         

    7010-890            000100310800010031080000000000                        000002                                                         

    7039-001            000042633300004263330000000000                        000001                                                         

    7069-001            000000500000000050000000000000                        000001                                                         

    7129-010            000001000000000100000000000000                        000001

    RETURN TO DEVELOPER

     [Alvis] - The output file has some "13" transactions. As per the file specifications, the following rules apply:








    11 Sep 202009:42AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-09-2020 09:41 AM Time Taken: 1.00 Notes: ETC extended from: 11/09/2020 to 15/09/2020

    Hi Team, 

    I have sent an email to Georgina(HFC) to get clarification as per comment 7.

    Next Step - We are awaiting a reply from HFC.

    Thanks
    Rashna


    11 Sep 202010:35AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-09-2020 10:33 AM Time Taken: 1.00

    --- Reply from Georgina ---

    Thank you for your email and here is the clarification.

     

    That portion of the document will be updated internally, however,  because “53” is CREDIT and “13” is DEBIT that they are supposed to cancel each other out so that the amount is zeroized as provided in the Actual result.

     

    The “B” should have been negative instead of a sum. The Bank is paying (credit) the employee or vendor by taking the money (debit) from the client or company account to cover it.

    Hope this clarifies.


    --- Email from Rashna ---


    Thank you for the clarification.

    As stated in the email, can you please forward us the updated file specification. We have to submit the document to the developers in Australia as a development reference before any changes can be made. 

    Next Step - Awaiting a reply from HFC.


    14 Sep 202008:16AM Comment 10 by Rashna (Edge Business Solutions) ETC was changed from 15/09/2020 to 15/09/2020
    14 Sep 202008:17AM Comment 11 by Rashna (Edge Business Solutions) ETC was changed from 15/09/2020 to 10/09/2020
    15 Sep 202007:59AM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-09-2020 07:57 AM Time Taken: 1.00

    Hi Team,

    Below followup email has been sent to HF.

    Hi Georgina, 

    Can we please get feedback on the request for the updated file specifications?

    Next Steps

    1. We will wait for a reply for the email.
    2. Sitla to contact HFC personals via phone to check for updates.
    Thanks
    Rashna

    17 Sep 202007:31AM Comment 13 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-09-2020 07:29 AM Time Taken: 1.00

    --- Email from Georgina (HFC) on 16/09/2020 ---

    I will be provided the finalized document this afternoon for your team as it follows the Australia CEMTEX standard with a few changes to suit Fiji.


    Next

    1. We have not received the file yet.
    2. We will follow up on the status of the file today.

    17 Sep 202010:49AM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 18-09-2020 10:48 AM Time Taken: 1.00

    Hi Alvis, 

    As per comment 11, the updated file specification and a sample file have been attached to the case for development.

    Thanks
    Rashna


    18 Sep 202003:45PM Comment 15 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-09-2020 03:15 PM Time Taken: 2.00

    Development work for this case has been completed.

    The change will be available in version:12.0.0918

    1. The following changes were made(Include Database object names, Program classes and any other relevant information):

    1. Re-designed HFC File format as per specifications provided

    2. Affected Areas:

    1. Bank File - HFC All Account

    3. The issue was caused by:

    1. New Feature

    4. Notes: 
    5. Next Step    : UAT

    ----------------------

    Development Reference:


    21 Sep 202012:14PM Comment 16 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-09-2020 12:13 PM Time Taken: 1.00
    QA Results
    Tests carried out according to requirements specified on the case header

    Test Results Summary

    Table 1 - Summarised list of issues
    NoTest DescriptionPass/Fail
    1

    Created a pay for employees with below "Bank Direct Credit" option

    1. E013 - ANZ
    2. E019 - Westpac and BSP
    3. E008- ANZ and HFC

    Generated the bank file for HFC all in format .pc2. 

    Validated that the content of the output file is as per the attached specification

    Pass


    Attached is the output "LinkPAYDirectBankFile_20200131_HFC_447" 


    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 12.0.0.918
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-12-HFC

    Next Step: 

    1. Bank file will be sent to the bank for confirmation

    22 Sep 202012:23PM Comment 17 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-09-2020 12:21 PM Time Taken: 1.00

    --- Email from HFC ---

    Congratulations. The file has been successful and attached is the UAT result.

     

    Please ensure that you have validated your test account details with your client as well to ensure that all the account numbers match up prior to Go Live.


    Attached "HFC BANK UAT FIJIPAYROLL 21092020" is the update results.


    Next Step - Documentation


    Thanks
    Rashna


    23 Sep 202002:30PM Comment 18 by Alvis (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-09-2020 02:30 PM Time Taken: 2.00
    Documentation completed

    Attachments:
    General Documents - Case: L12018:HFC Bank File 003_06Jun17.pdf
    HFC BANK UAT NFA PAYROLL FILE FORMAT.docx
    LinkPAYDirectBankFile_20200131_HFC_446 (1).pc2
    Updated File Specification - Updated File Specification:HFC BANK UAT FIJIPAYROLL 21092020.pdf
    HFC FILE SPECIFICATION(Updated).pdf
    LinkPAYDirectBankFile_20200131_HFC_447.pc2
    SampleHFCBankFile(Updated).PC2
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12018 in the subject line of all emails regarding this issue.

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