| 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
Column A – Enter Payee Bank Code (Support Bank Codes are: “BSP”, “ANZ”, “WBC”, “BRED” and “BOB”) Column B – Enter Payee Account Number (Account numbers with the maximum length of 17 numeric digits only. Eg ‘80008756125478562’) 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) Column D – Enter Payee Statement Reference/Narration (Payment narration of maximum length of 16 alphanumeric characters only. Eg ‘Payroll ID 7234’ 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
The order of the details for each Payment record should be as in the sequence of the list mentioned above. Please take note of the total value of the salary amount. Please split the batch file into multiple Payment lists if the file contains more than 800 payees. 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 2021 | 11:12AM Comment 1 by Sanjay (Link Technologies) Case L12565 added to project 13.0X |
| 10 Sep 2021 | 02:16PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 10/09/2021 to 10/09/2021 |
| 13 Sep 2021 | 02: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): - Added BSP file as requested
- Refactored output file names t improve readability
3. Affected Areas: - File Export
4. The issue was caused by: - New Function and Refactoring
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT
|
|
| 15 Sep 2021 | 02: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 Details | Pass/Fail | Comments | | 1 | - Create a pay with below details
- Employee E013
- Bank = ANZ
- Direct Deduction for LICI into BSP
- Employee E019
- Bank = BSP and WBC
- Direct Deduction for LICI into BSP
- Generate the "BSP IB All file", validate above components are correctly output in the file
| Pass | | | 2 | - Generate the "BSP IB BSP Only file", Validate only BSP data is in the file as per the format.
| Pass | |
Environment Details - OS version:
- Application version: 13.03.0914RC1
- Setup on:
- Server:LinkQA4
- Database: UAT-IINKSOFT
- LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Documentation
|
|
| 16 Sep 2021 | 11: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 2021 | 01:44PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-09-2021 05:42 PM |
| Thanks Alvis |
|
| 16 Sep 2021 | 02: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;- Remove the special character from column D
- Column D – Enter Payee Statement Reference/Narration (Payment narration of maximum length of 16 alphanumeric characters only. Eg ‘Payroll ID 7234’
|
|
| 17 Sep 2021 | 03: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): - Removed special character from column D
3. Affected Areas: - BSP Bank file
4. The issue was caused by: - Correction to output file
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT |
|
| 20 Sep 2021 | 09: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 Details | Pass/Fail | Comments | | 1 | - Validate that special characters have been removed from the BSP IB file
| Pass | See attached file |
Environment Details - OS version:
- Application version: 13.03.0917GA
- Setup on:
- Server:LinkQA4
- Database: UAT-LINKSOFT
- LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|
| 21 Sep 2021 | 09:06AM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-09-2021 01:06 PM |
| Thanks Rashna |
|