| 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 2023 | 03: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 2023 | 11: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;- Create Employee Profile [Employee Profile -> Employee Maintenance]
- Create Bank [Company Administration -> Bank]
- Bank Code: Samoa Commercial Bank
- Description: Samoa Commercial Bank
- Upload Direct Credit Details using the template "EmployeePayDirectBank.csv"
Company ID | Employee Code | Paycode | Bank Branch | Account No | Account Name | Amount |
1001 | E067 | Samoa Commercial Bank | | 123456 | Chris | 0 |
- Select Employee and Expand Record on Employee Profile -> Employee Pay Setup
Environment Details - URL: https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
- Company: 1001
- Employee: E067
Regards
Vineshwar |
|
| 17 Feb 2023 | 12: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): - Allow component ID to exceed 15 characters. Max 50 characters
3. Affected Areas: - Standard Pay Calculation
- Pay Register Report
- Package Calculation
- Custom GL Accounts Build
4. The issue was caused by: - Data type restriction
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 01 Mar 2023 | 09: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 |
|