| Subject: | Error on "AR Sales Order View" in Linkweb - String or binary data would be truncated |
| Summary: | Bula Vinaka Alvis, In OTGL, on the "AR Sales Order View" in LinkWeb, there is the following error "String or binary data would be truncated"
This error has occurred for a few debtors. Would you be able to advise on what is wrong? or do you need more information from my end? Regards
Aarti |
| Audit Notes: | Edited by alvis on 08/12/20 09:44. Edited by alvis on 24/09/19 09:04. Edited by alvis on 23/09/19 16:29. |
| 10 Sep 2019 | 10:09AM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 10-09-2019 10:09 AM Time Taken: 1.00 |
| Hi Aarti, I am not able to find what is causing this error in the demo environment. Can you upload the JIWA and LinkSOFT databases to FTP for me to investigate. regards
Alvis |
|
| 23 Sep 2019 | 04:33PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-09-2019 04:33 PM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version:10.152 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - The sales order is not created for debtor names more than 50 characters. When a sales order is created, the "Cash Sale" tab is populated with debtor details. The "Cash Sale" tab has debtor names limited to 50 characters.
- We have changed the integration to crop the debtor names to 50 characters in the "Cash Sale" tab.
2. Affected Areas: - Sales order integration for debtors having names more than 50 characters
3. The issue was caused by:
4. Notes:
5. Next Step: UAT |
|
| 24 Sep 2019 | 09:04AM Comment 3 by Alvis (Link Technologies) Case 11744 removed from project 10.152 |
| 24 Sep 2019 | 09:04AM Comment 4 by Alvis (Link Technologies) Case 11744 added to project 10.152 |
| 26 Sep 2019 | 08:02AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-09-2019 08:02 AM |
| Proceed with UAT |
|
| 26 Sep 2019 | 08:45AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-09-2019 08:45 AM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | Create a debtor in POS as "Mr Gordon Rajendram - Twilite Investments New Zealand and the Pacific" - Process a credit sale for the customer
- Process a cash sale for the customer.
- Sales 1 and 2 should be integrated without errors
| Pass | | 2 | Validate the debtor name has been corrected shrinked to 50 characters. | Pass
|
Environment Details - OS version: Windows Server 2012
- Application version: 10.152
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-10-RASHNA
- JIWA - 7.2.1 , Database - JIWA_11
Next Step: - Closure
|
|
| 08 Dec 2020 | 09:44AM Comment 7 by Alvis (Link Technologies) ETC was changed from 11/09/2019 to 11/09/2019 |