Company: Link Technologies
Case No: L08312. Project: 08.20: LinkSOFT Version 8.2
Logged By: Rashna (Edge Business Solutions) on 23 Jan 2017 11:11AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 3.00 (Weight: 3.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna
Resolve By: Tuesday, 24 January 2017 12:00 AM [2650 days since logged date]
Status: Closed
Subject: Unable to generate Leave Transaction Report with long Employee Names
Summary:    

Hi Sanjay,

Please refer to customer case 5551.

NFA had a setup as below. On menu 321 the following was set

  • First Name : MINISTRY OF WORKS
  • Middle Name : TRANSPORT&PUBLIC UTILI
  • Last Name : -FRANCIS KEAN

When the users generated the Leave Transaction Report for all employees, the following message occurred.

"String or Binary data would be truncated"

To solve the case. We shortened the employee name as 

  • First Name : MOW
  • Middle Name : TRANS&PUBLIC
  • Last Name : FRANCIS KEAN

Can we have menu 321 and the leave transaction report to support the same number of characters.


Audit Notes:
23 Jan 201711:17AM Comment 1 by Alvis (Link Technologies) Case 8312 added to project 8.09
23 Jan 201711:20AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-01-2017 11:20 AM Time Taken: 2.00
Development work for this case has been completed.


The change will be available in version: 8.09
Documentation update required(Yes/No. Add change details below): No
QA required(Yes/No.Include areas that require testing): Yes

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

  1. Changed report procedure to allow for employee name upto 8000 characters.

Documentation details:
  

23 Jan 201711:27AM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-01-2017 11:27 AM Time Taken: 1.00
1. Was this test completed using Demo / New / Other database? Demo
2. Did the test pass or fail? Pass
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? Pass
4. Data verified, saved, edit, delete/void? Pass
5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc): Tested an employee with 53 characters in name, report generated successfully.

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

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