Company: Link Technologies
Case No: L12565. Project: 13.03: LinkSOFT version 13.03
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 09 Sep 2021 07:34AM
Priority: High
Product: Payroll & HR
Group: New Feature
Time Taken: 13.50 (Weight: 18.00)
Version: 13.03.0917
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 10 September 2021 11:59 PM [952 days since logged date]
Status: Closed
Subject: BSP Internet Banking (IB) Bank File
Summary:    
BSP has introduced an Internet Banking (IB) Platform for Salary Processing. This File can be uploaded on the BSP Online Portal [BSP Online PLUS] by the client to process their Salaries.

Requirements;

Create a Salary Listing on a Microsoft Excel sheet.
Each Payment record should be entered on a separate column in the file i.e. Payee Bank Code, Payee Account Number, Amount, Payee Statement Reference, and Payee Name
  1. Column A – Enter Payee Bank Code (Support Bank Codes are: “BSP”, “ANZ”, “WBC”, “BRED” and “BOB”)
  2. Column B – Enter Payee Account Number (Account numbers with the maximum length of 17 numeric digits only. Eg ‘80008756125478562’)
  3. Column C – Enter Amount (Payment amount with a maximum length of 14 digits and 2 digits after the decimal point. Eg 3505.50. Values without decimal points will be taken as it is. Eg ‘1000’ will be accepted as $1,000 for transfer)
  4. Column D – Enter Payee Statement Reference/Narration (Payment narration of maximum length of 16 alphanumeric characters only. Eg ‘Payroll ID 7234’
  5. Column E – Enter Payee Name (Name with a maximum length of 40 alphanumeric characters. Eg ‘Mathew’
Sample

BSP
81992806
144
Wages
Vola Lewai
BSP
81493524
99.36
Wages
Sitiveni Cavuilagi
BRED
166001010
85.1
Wages
Isaia Nainoca

Notes
  1. The order of the details for each Payment record should be as in the sequence of the list mentioned above.
  2. Please take note of the total value of the salary amount.
  3. Please split the batch file into multiple Payment lists if the file contains more than 800 payees.
  4. Once entries are done, save excel in the following format type (CSV comma delimited)
Audit Notes:Edited by sanjay on 13/10/21 10:53. Edited by sanjay on 10/09/21 14:16. Edited by sanjay on 10/09/21 11:12. 
10 Sep 202111:12AM Comment 1 by Sanjay (Link Technologies) Case L12565 added to project 13.0X
10 Sep 202102:16PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 10/09/2021 to 10/09/2021
13 Sep 202102:14PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-09-2021 06:12 PM Time Taken: 8.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.03.0913

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

  1. Added BSP file as requested
  2. Refactored output file names t improve readability

3. Affected Areas:

  1. File Export

4. The issue was caused by:

  1. New Function and Refactoring

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


15 Sep 202102:40PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 15-09-2021 04:59 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Create a pay with below details
    1. Employee E013
      1. Bank = ANZ
      2. Direct Deduction for LICI into BSP
    2. Employee E019
      1. Bank = BSP and WBC
      2. Direct Deduction for LICI into BSP
  2. Generate the "BSP IB All file", validate above components are correctly output in the file 
 Pass 
 2
  1. Generate the "BSP IB BSP Only file", Validate only BSP data is in the file as per the format.
 Pass 

Environment Details

  1. OS version:
  2. Application version: 13.03.0914RC1
  3. Setup on:
    1. Server:LinkQA4
    2. Database: UAT-IINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Documentation


16 Sep 202111:40AM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-09-2021 03:35 PM Time Taken: 1.00
Documentation completed

16 Sep 202101:44PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-09-2021 05:42 PM
Thanks Alvis

16 Sep 202102:27PM Comment 7 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-09-2021 06:18 PM Time Taken: 0.50
BSP has responded to the sample test file;
  1. Remove the special character from column D
  2. Column D – Enter Payee Statement Reference/Narration (Payment narration of maximum length of 16 alphanumeric characters only. Eg ‘Payroll ID 7234’

17 Sep 202103:00PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 17-09-2021 06:59 PM Time Taken: 2.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.03.0917

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

  1. Removed special character from column D

3. Affected Areas:

  1. BSP Bank file

4. The issue was caused by:

  1. Correction to output file

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


20 Sep 202109:49AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-09-2021 01:15 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Validate that special characters have been removed from the BSP IB file
 Pass See attached file

Environment Details

  1. OS version:
  2. Application version: 13.03.0917GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database: UAT-LINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


21 Sep 202109:06AM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-09-2021 01:06 PM
Thanks Rashna

Attachments:
General Documents - Case: L12565:Loading a Salary Batch Payment on Online Plus.pdf
QAOutput.csv
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12565 in the subject line of all emails regarding this issue.

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