Company: Link Technologies
Case No: L11708. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 03 Sep 2019 04:21PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 8.50 (Weight: 11.50)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Tuesday, 03 September 2019 12:00 AM [1693 days since logged date]
Status: Closed
Subject: Merge ESS and POS customer maintenance

Merge ESS and POS customer maintenance 

Audit Notes:
03 Sep 201904:21PM Comment 1 by Alvis (Link Technologies) Case 11708 added to project 11.00
03 Sep 201904:39PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-09-2019 04:39 PM Time Taken: 7.50

Development work for this case has been completed.

The change will be available in version:11.003

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

  1. Renamed table "LBS_POS_Customer" to "LBS_POS_Customer_all"
  2. Added the following columns to "LBS_POS_Customer_all"
    1. CompanyID
    2. ID
    3. Country
    4. PostalAddress
    5. DisplayOrder
    6. Deleted
  3. Merged data from table "LT_ESS_Customer" to "LBS_POS_Customer_all"
  4. Created views for "LBS_POS_Customer" and "LT_ESS_Customer"
  5. Changed customer update procedures to point to "LBS_POS_Customer_all" table
  6. Changed ESS customer ID references to VARCHAR(50) instead of GUID

2. Affected Areas:

  1. Time & Attendance ~> Time view - Day. Verify Add and edit of time entries
  2. Time Maintenance ~> Customer
  3. Point of Sale (WEB) ~> Customer Maintenance
  4. Point of Sale (Application) ~> Customer Maintenance

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step

12 Sep 201909:38AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-09-2019 09:38 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

Verify that the following columns are added to the "LBS_POS_Customer_All" table. 

  1. CompanyID
  2. ID
  3. Country
  4. PostalAddress
  5. DisplayOrder
  6. Deleted
2Create a customer in Time Maintenance -> Customer. This should be created without errorsPass
3Create a customer in POS Web-> Customer. This should be created without errors
4Create a customer in POS Application-> Customer. This should be created without errors

Create a time entry for below customers "CK - (ESS Customer)" and "002 - (POS Customer)

Users should be able to credit, edit, submit and approve time entries.


Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.002.909
  3. Setup: Demo
  4. Server :
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step

  1. Closure

    If you have any queries regarding this support incident, please email and include the Case No: L11708 in the subject line of all emails regarding this issue.

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