Company: Link Technologies
Case No: L12120. Project: 12.30: LinkSOFT Version 12.30
Logged By: Rashna (Edge Business Solutions) on 31 Dec 2020 03:04PM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 2.00 (Weight: 8.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 01 January 2021 11:59 PM [1208 days since logged date]
Status: Closed
Subject: Make "Cost" field required under "Supplier Quotes".


  1. Navigate to "Supplier Maintenance -- Supplier Quote" 
  2. Add a new quote
  3. Enter all the required fields only and save
  4. Save is unsucceful. 
    1. Database Error is shown on the form - "Cannot insert the value NULL into column 'cost', table 'LINKSOFT-CLIENT-LBP.dbo.LBS_VENDOR_SKU'; column does not allow nulls. UPDATE fails.

Audit Notes:Edited by rashna on 05/02/21 17:17. Edited by alvis on 06/01/21 14:23. 
06 Jan 202102:23PM Comment 1 by Alvis (Link Technologies) Case L12120 added to project 12.3
06 Jan 202102:25PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 07-01-2021 02:23 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.0106

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

  1. Initialised values to handle NULLS in unit cost.

3. Affected Areas:

  1. Supplier Quotes - add/edit

4. The issue was caused by:

  1. NULL values are not allowed.

5. Notes
6. Next Step


PART B - Development Reference:

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

2. Variations to the approved design:

11 Jan 202102:24PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-01-2021 02:20 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

Add a new "Supplier Quote" for supplier 5299, enter only the fields marked as required. 

The record should be added without errors


Environment Details

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

Next Step

  1. For Closure

    11 Jan 202104:45PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-01-2021 04:45 PM
    Thanks Rashna 

    05 Feb 202105:17PM Comment 5 by Rashna (Edge Business Solutions) ETC was changed from 01/01/2021 to 01/01/2021
    If you have any queries regarding this support incident, please email and include the Case No: L12120 in the subject line of all emails regarding this issue.

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