Company: Link Technologies
Case No: L11744. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 24 Sep 2019 09:04AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 6.00 (Weight: 6.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 11 September 2019 11:59 PM [1648 days since logged date]
Status: Closed
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 201910: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 201904: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):

  1. 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.
  2. We have changed the integration to crop the debtor names to 50 characters in the "Cash Sale" tab.

2. Affected Areas:

  1. 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 201909:04AM Comment 3 by Alvis (Link Technologies) Case 11744 removed from project 10.152
24 Sep 201909:04AM Comment 4 by Alvis (Link Technologies) Case 11744 added to project 10.152
26 Sep 201908: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 201908: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
NoTest DescriptionPass/Fail
1

Create a debtor in POS as "Mr Gordon Rajendram - Twilite Investments New Zealand and the Pacific"

  1. Process a credit sale for the customer
  2. Process a cash sale for the customer.
  3. Sales 1 and 2 should be integrated without errors
Pass
2Validate the debtor name has been corrected shrinked to 50 characters.Pass


Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 10.152
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-10-RASHNA
  6. JIWA - 7.2.1 , Database - JIWA_11

Next Step

  1. Closure

    08 Dec 202009:44AM Comment 7 by Alvis (Link Technologies) ETC was changed from 11/09/2019 to 11/09/2019
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11744 in the subject line of all emails regarding this issue.

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