Company: Link Technologies
Case No: L12738. Project: 14.00: LinkSOFT Version 14.00
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 31 May 2022 02:47PM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 23.75 (Weight: 23.75)
Version: 14.00
Assigned To: Development
Circulation: Aarti Pooja Gayaneshwar, Development, Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Friday, 29 July 2022 02:38 PM [687 days since logged date]
Status: Closed
Subject: BRED ALL Bank file output required for customers using BRED Bank
Summary:    

Hi Sanjay

BRED bank customers are required to send a file to the bank containing pay information in the format shown in figure 1 below.

Figure 1 - BRED Bank - File format

EMP

ACCOUNT NAME

ACCOUNT NUMBER

 AMOUNT

1

 

 

 

2

 

 

 

3

 

 

 

 

Specifications are attached in the notes and attachments section.

Below is a summary of the bak file specifications

  1. EMP - this field records the employment number of employees if any 
  2. ACCOUNT NAME - full account name of the employee. 
  3. ACCOUNT NUMBER - correct account number of the employee. 
  4. AMOUNT - the total amount to be credited to employees’ bank accounts. 
  5. EOF - to enter and indicate End Of File
  6. Each Bank needs to be displayed on a separate sheet with the bank name of the workbook
  7. The file format should be .xlsx

Test Plan:
Environment: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS/Default.aspx. Use company: 1001 - Link Technologies DEMO


Test case 1:

  1. Create a "Pay Bank Submission" for "Bank File Format" BRED - ALL using PAY ID 496
  2. Expected results attached - file name: Bred Output File
  3. A CSV file format should be attached to the Pay Bank File submission attachments section.
Audit Notes:Edited by sanjay on 29/07/22 17:38. Edited by sanjay on 22/06/22 10:05. Edited by aarti on 21/06/22 12:47. Edited by aarti on 08/06/22 09:02. Edited by sanjay on 06/06/22 13:43. Edited by sanjay on 06/06/22 13:30. Edited by sanjay on 06/06/22 13:25. Edited by aarti on 01/06/22 10:45. Edited by aarti on 01/06/22 10:43. 
06 Jun 202201:28PM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 06-06-2022 05:25 PM Time Taken: 2.00

Discussion - Aarti and Sanjay

  1. We rewrote the case header
    1. as the requirements were not clearly stated
    2. Test plans were not provided
  2. There is already a Bank Submission for BRED Diskpay -  ALL.
  3. Aarti to verify this in version 13.40 and see if this meets the requirements and update the case header with expected test results

06 Jun 202201:43PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 01/06/2022 to 30/06/2022
08 Jun 202209:04AM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 08-06-2022 01:02 PM Time Taken: 0.75

Hi Sanjay

I tested the BRED ALL file in 13.40 and the Log Message was "There is no data in the bank file"

I have also updated the case header and attached the expected results the bank is after.

Regards
Aarti


21 Jun 202212:54PM Comment 4 by Sanjay (Link Technologies) Case L12738 added to project 14.00
22 Jun 202210:05AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 30/06/2022 to 30/06/2022
29 Jun 202211:30AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 29-07-2022 02:38 PM Time Taken: 16.00 Notes: ETC extended from: 30/06/2022 to 29/07/2022
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.00

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

  1. Added "BRED Bank - ALL" Excel File output as requested.
  2. Bank Codes are Separated by Sheet
  3. The end of Bank data is marked with "EOF" as requested

3. Affected Areas:

  1. Bank File Submission 

4. The issue was caused by:

  1. Add Banking Requirements for BRED Bank

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


21 Jul 202201:41PM Comment 7 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Development Followup Date: 22-07-2022 05:36 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Emp. No
Should pick up Employee Code
Pass

2Account Name
Should pick up from Direct Credit
Pass

3Account Number
Should pick up from Direct Credit
Pass

4Amount
Should pick up from Pay
Pass

5EOF
Display after completion of the record
Pass

Environment Details

  1. OS version: Win10
  2. Application version: 14.00.0720.Beta 2
  3. Setup on:
    1. Server: LinkQA4
    2. Database: DEMO-LinkSOFT-LBS
    3. LinkSOFT URL: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS
  4. Login Details: Standard username and password for user "admin"

Next Step


21 Jul 202202:14PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 22-07-2022 06:03 PM Time Taken: 4.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Verify BRED - ALL file creation

Pass

2Verify BRED Only file format

Pass

3Verify ANZ ALL and ANZ Only File format

Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.00
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


Attachments:
General Documents - Case: L12738:Bred Output File.xlsx
Salary Processing Brochure_ (003).pdf
Salary.xlsx
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12738 in the subject line of all emails regarding this issue.

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