Company: Link Technologies
Case No: L12842. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 14 Feb 2023 03:35PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 10.00 (Weight: 1.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineshwar Prasad
Resolve By: Friday, 17 February 2023 05:34 PM [433 days since logged date]
Status: Closed
Subject: Viewing details on "Employee Pay Setup" give message as "String or Binary data would be Truncated"
Summary:    
Client advised that she was unable to expand employees in Employee Pay Setup as she was receiving the error message "String or Binary data would be Truncated" as per the below snapshot.

Trying to expand Employee 3831

2. Error Message (screenshot of the error)

Audit Notes:Edited by sanjay on 28/02/23 13:59. 
14 Feb 202303:36PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-02-2023 09:35 PM Time Taken: 1.00
Bula Team,

We did a site visit and diagnosed the issue.

It was identified that the Employee's Bank Account details were uploaded with Bank Description in the Bank Code field. After correcting this the issue was resolved.

Proceeding to close the case. Please do not hesitate to contact us if you require any further clarifications.

Regards
Vineshwar Prasad

17 Feb 202311:34AM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-02-2023 05:27 PM Time Taken: 1.00 Notes: ETC extended from: 24/02/2023 to 20/02/2023
Bula Team,

Below are the steps to replicate the issue;
  1. Create Employee Profile [Employee Profile -> Employee Maintenance]
  2. Create Bank [Company Administration -> Bank]
    1. Bank Code: Samoa Commercial Bank
    2. Description: Samoa Commercial Bank
  3. Upload Direct Credit Details using the template "EmployeePayDirectBank.csv"
    1. Company ID

      Employee Code

      Paycode

      Bank Branch

      Account No

      Account Name

      Amount

      1001

      E067

      Samoa Commercial Bank

       

      123456

      Chris

      0


  4. Select Employee and Expand Record on Employee Profile -> Employee Pay Setup
Environment Details
  1. URL: https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
  2. Company: 1001
  3. Employee: E067
Regards
Vineshwar

17 Feb 202312:09PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-02-2023 05:34 PM Time Taken: 6.00 Notes: Edited by sanjay on 17/02/23 12:23. ETC extended from: 20/02/2023 to 17/02/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50

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

  1. Allow component ID to exceed 15 characters. Max 50 characters

3. Affected Areas:

  1. Standard Pay Calculation
  2. Pay Register Report
  3. Package Calculation
  4. Custom GL Accounts Build

4. The issue was caused by:

  1. Data type restriction

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


01 Mar 202309:24AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-03-2023 03:23 PM Time Taken: 2.00
Checked all Reference fields and increased size to 50 characters

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12842 in the subject line of all emails regarding this issue.

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