Company: Link Technologies
Case No: L12118. Project: 12.30: LinkSOFT Version 12.30
Logged By: Rashna (Edge Business Solutions) on 23 Dec 2020 02:45PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 3.00 (Weight: 5.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Thursday, 31 December 2020 11:59 PM [1214 days since logged date]
Status: Closed
Subject: Unable to update "Customer Details" in LinkPOS
Summary:    

Steps

  1. Save the customer profile for customer 0002.
    1. Error - Error converting data type nvarchar to uniqueidentifier
Audit Notes:Edited by rashna on 05/02/21 17:32. 
23 Dec 202004:03PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-12-2020 10:00 PM Time Taken: 1.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.30.1223

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

  1. Refactored customer update to handle GUID to string conversion

3. Affected Areas:

  1. POS - Customer - Save
  2. LinkWEB - Point of Sale -> Customer - Add/Edit
  3. LinkWEB - Time Management -> Time Setup -> Customer - Add/Edit

4. The issue was caused by:

  1. Primary User & organisation fields are GUID, the system was sending a blank instead of NULL.

5. Notes: 
6. Next Step: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N):

2. Variations to the approved design:


24 Dec 202009:28AM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-12-2020 03:23 PM 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

POS - Customer - Save

Pass
2LinkWEB - Point of Sale -> Customer - Add/Edit
Pass
3

LinkWEB - Time Management -> Time Setup -> Customer - Add/Edit

Pass

Environment Details

  1. Application version: 12.30.1223
  2. Setup: Demo
  3. Server : 10.0.0.10
  4. Database: DEV-LINKSOFT

Next Step: 

  1. UAT

    24 Dec 202001:42PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-12-2020 07:32 PM 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
    1. Create a customer as "Dennis" in LinkPOS. 
    2. Edit and Save record
    3. Validate the customer account is reflected in LinkWEB - POS - Customer
    		Pass
    2
    1. Create a customer as "Wise" under "LinkWEB - POS - Customer"
    2. Edit and Save record
    3. Validate the customer account is reflected in LinkPOS

    		Pass
    3
    1. Create a customer with code as "123001" under Time Setup - Customer.
    2. Test edit and delete record
    		Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 12.30.1224BETA
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-123

    Next Step: 

    1. For Closure

      04 Jan 202103:24PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-01-2021 09:24 PM
      Thanks Rashna 

      05 Feb 202105:32PM Comment 5 by Rashna (Edge Business Solutions) ETC was changed from 31/12/2020 to 31/12/2020
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12118 in the subject line of all emails regarding this issue.

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