Company: Link Technologies
Case No: L11788. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 14 Oct 2019 11:13AM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 67.00 (Weight: 67.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 06 November 2019 08:17 PM [1648 days since logged date]
Status: Closed
Subject: Pilot upgrade for Gold Creek Cafe and improvements to inventory management and processing views
Summary:    

Pilot upgrade for Gold Creek Cafe

  1. Upgrade the database to version 11.004
  2. Upgrade customizations, if any
  3. Perform system tests
Audit Notes:Edited by alvis on 08/12/20 09:15. Edited by alvis on 09/01/20 15:28. Edited by alvis on 06/11/19 22:25. Edited by alvis on 04/11/19 09:37. Edited by sanjay on 01/11/19 06:42. Edited by alvis on 15/10/19 08:39. 
14 Oct 201911:13AM Comment 1 by Alvis (Link Technologies) Case 11788 added to project 11.004.BETA
15 Oct 201908:39AM Comment 2 by Alvis (Link Technologies) Case 11788 added to project 11-PILOT
18 Oct 201902:29PM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-10-2019 06:24 PM Time Taken: 16.00

We have tested the upgrade on version 11.4.

The following issues were identified and corrected:

  1. Bulk and Non-bulk receipts were printed on completion of sale which was unnecessary if these were already printed when the transaction was parked.
  2. On completion, bulk and non-bulk receipts are printed if new items were added to the sale. These items are not parked.
  3. When the printer name was blank, the system threw an "out of bounds" error when trying to print.

Gold Creek Cafe was upgraded to version 11.4 on 16/10/2019.

regards
Alvis


29 Oct 201908:02AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-10-2019 11:53 AM Time Taken: 5.00

The following issues were identified and corrected in the application: Refer to case 11802

  1. Unable to view kit components in  the cooking/coffee preparation forms (BI Build)
  2. Unable to separate Coffee and Cooking items for different preparation areas
  3. Processing forms must be able to complete with minimum clicks

Next steps:

  1. Two touch screens have been ordered with NUC's so we can test this out. ETA is 29/10/2019
  2. Once tested, GCC will be upgraded and changes verified

01 Nov 201906:42AM Comment 5 by Sanjay (Link Technologies) Case L11788 added to project 11.004
01 Nov 201907:01AM Comment 6 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 01-11-2019 12:42 PM Time Taken: 16.00

On-Site implementation Journal:

Part A - Summary of Tasks

  1. Installed update for 11.4.1030
  2. Setup Coffee and Kitchen Monitors
  3. Reconfigured Kit items to meet customers' requirements. Refer to Part B. Considerable difficulties faced.

Part B - Issues Faced

  1. Product Maintenance bugs prevent Kit items from being updated
  2. Creating products is still cumbersome and needs improvements
  3. Kit items are displayed in order of KitItemCode, however, we are unable to easily renumber product codes
  4. Kit item selection screen scrolling is difficult
  5. Bugs in product search - cannot search in-between product descriptions

Part C - Required Changes to make the system operational=

  1. Add the ability to renumber codes
  2. When creating a product, we should be able to enter part of the code and the system should be able to get the next available number in that sequence. For example, if PRODUCT MASK is 00000, if we enter "Z01", the system should check if "Z01" is available, if so create the item, otherwise create the next available variant of "Z01"
  3. When creating a product, add the ability to enter RRP - which is the "Product Price for 1 quantity
  4. If product code is changed, this should renumber the product code
  5. Add "Sort Order" in the product kit item list
  6. System Health Check should check if "Defaults" are not set up for Inventory Items
  7. Add configuration to allow users to determine of "Processing Display" is consolidated or separated by "line number"
  8. Add the ability to change the product description 
  9. Product Item Price Grid - Bring Pricing to the left so it is clearly visible. Move less frequently used items to the right
  10. Set Default on "Allow Negative" to TRUE 
  11. Allow DELETE of PRODUCT. If it is unused, remove the item completely
  12. Remove the top-level search from product master
  13. Completely remove category/Sub Category when deleted provided it is not used. RaiseError if it is used
  14. Completely remove Location when deleted provided it is not used. RaiseError if it is used
  15. Completely remove UOM when deleted provided it is not used. RaiseError if it is used
  16. Completely remove Cycle Code when deleted provided it is not used. RaiseError if it is used
  17. Completely remove PostingAccount when deleted provided it is not used. RaiseError if it is used
  18. Completely remove PriceClasswhen when deleted provided it is not used. RaiseError if it is used
  19. Completely remove TaxCode when deleted provided it is not used. RaiseError if it is used




01 Nov 201903:37PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-11-2019 07:00 PM Time Taken: 16.00

Development work for this case has been completed.

The change will be available in version:11.4.1101

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

  1. Added ability to change product code. Users can edit the product code in product master and change it to a new code.
  2. When "Automatic Product Code" is enabled, the system will assign product codes that start with code. For example, enter code as "AK01". If "AK01" already exists, the system will generate a new code as "AK01001".
  3. Added Sell Price field to product master. This updates the products quantity break 1 price.
  4. Added display order field in Kit items. Kits are displayed using the display order, part description, part no. This change is available to "Load Custom Kit in POS", Receipts 80mm/A4, Bulk/Non-Bulk Receipt and BI Processing View.
  5. Added system health check "POS010" to verify defaults are set up for inventory.
  6. Added Station base configuration to for processing view to be separated by line numbers.
  7. "Allow Negative" is defaulted to ticked for "Purchase" items when location is automatically added.
  8. Added delete capability to the following:
    1. Inventory Product Master
    2. Category
    3. Sub Category
    4. Location
    5. UOM
    6. Cycle Code
    7. Posting Account
    8. Price Class 
    9. Tax Codes

2. Affected Areas:

  1. Inventory menus in Link Web

3. The issue was caused by:

  1. Improvements

4. Notes
5. Next Step
: UAT then assign the case to Sanjay to update client.


06 Nov 201902:18PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-11-2019 08:17 PM
We expect to implement these changes at GCC today.

07 Nov 201908:21AM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-11-2019 02:21 PM Time Taken: 4.00 Notes: Created from the WEB url sent to: sanjay@linktechnologies.com.au

Upgraded GCC at 5 pm yesterday. Note the following:

  1. No issues with Upgrade. Upgrade completed in 10 minutes
  2. No issues with DB upgrade - DB upgrade completed in 5 min

Important note:

  1. Cash drawer is configured in COM4. Change the "OpenCashDrawer.BAT" file to point to COM4 instead the default which is LPT1

Next steps:

  1. User training on new features
  2. Implement FOS (Front of Shop) monitor and KITCHEN Monitor. Expected to be done over the next week.



07 Nov 201909:41AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 07-11-2019 02:45 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
1Added ability to change product code. Users can edit the product code in product master and change it to a new code.
Pass
2When "Automatic Product Code" is enabled, the system will assign product codes that start with code. For example, enter code as "AK01". If "AK01" already exists, the system will generate a new code as "AK01001".
Pass
3Added Sell Price field to product master. This updates the products quantity break 1 price.
Pass
4Added system health check "POS010" to verify defaults are set up for inventory.

5

Added Station base configuration to for processing view to be separated by line numbers.

  • Set config to No - All items in the transaction should be grouped.
  • Set config to Yes - Each item should be displayed the line number

6"Allow Negative" is defaulted to ticked for "Purchase" items when location is automatically added.

Fails. 
Enable Auto insert location.Create a item with status as "Purchase" .Location is added but allow negative is not enabled.

7
Added delete capability to the following:
  • Inventory Product Master
  • Category
  • Sub Category
  • Location
  • UOM
  • Cycle Code
  • Posting Account
  • Price Class
  • Tax Codes

Component should only be deleted if not used in the system

 Pass

Environment Details

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

Next Step

  1. Closure

    07 Nov 201904:25PM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-11-2019 09:43 PM Time Taken: 1.00

    Development work for this case has been completed.

    The change will be available in version:11.4.1107

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

    1. Renamed configuration "Auto insert location" to "Automatically create all locations when an item is saved in Product Master (Y/N)"
    2. Removed trigger "LBS_Inventory_trg" from Inventory table. This process has been moved to inventory save procedure.
    3. The process will automatically create all locations when the location has default "Bin", "Tax Code" and "Posting Account" setup.

    2. Affected Areas:

    1. Create new inventory item from Backoffice with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created
    2. Edit an existing inventory item from Backoffice with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created  
    3. Create new inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created 
    4. Edit an existing inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on.  - All locations should be created 
    5. Create new inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned OFF. - Only a default location should be created
    6. Edit an existing inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned OFF. - Only a default location should be created 

    3. The issue was caused by:

    1. Improvement

    4. Notes
    5. Next Step
    : UAT


    12 Nov 201909:21AM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-11-2019 03:05 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
    1Create new inventory item from Backoffice with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created
    Pass
    2

    Edit an existing inventory item from Backoffice with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created  

    Pass
    3

    Create new inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on. - All locations should be created 

    Pass
    4

    Edit an existing inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned on.  - All locations should be created 

    Pass
    5

    Create new inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned OFF. - Only a default location should be created

    Pass
    6

    Edit an existing inventory item from POS Web ~> Product Master with the flag "Automatically create all locations when an item is saved in Product Master (Y/N)" turned OFF. - Only a default location should be created 

    Pass

    Environment Details

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

    Next Step

    1. Documentation

      09 Dec 201908:55AM Comment 13 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-12-2019 12:48 PM Time Taken: 3.00

      Hi Sanjay, 

      Documentation has been updated at

      1. Linkweb Application Portal - Inventory - Product Master
      2. Linkweb Application Portal - Inventory - Product Master Details
      3. Linkweb Application Portal - Inventory - Product Master - Price Structure
      4. Linkweb Application Portal - Inventory :
        1. Stock Adjustment
        2. Category
        3. Cycle Code
        4. Location
        5. Posting Account
        6. Price Class
        7. Product Matrix
        8. Supplier Maintenance
        9. Tax Maintenance
        10. Unit of Measure

      Thanks
      Rashna


      05 Jun 202007:15PM Comment 14 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 09-06-2020 12:38 AM Time Taken: 4.00

      Upgrade GCC from 11.3 to 12.0 performed on 05/06/2020 6:00pm 

      Upgrade Log:

      1. Connected via Teamviewer to POS Main machine, Kitchen Station and Coffee Station
      2. Backup of LinkSOFT install directory and Database prior to backup
      3. Downloaded LinkSOFT Full Build 12.0 on POS Main station, Installed and Upgraded database from 11.3 to 12
      4. Downloaded LinkSOFT Client Installation on FOH Station, Installed V12
      5. Downloaded LinkSOFT Client Installation on Kitchen Station, Installed V12
      6. Copied OpenCashDrawer.BAT on (POS Main Station) to Installed Folder from Backup. Cash drawer uses COM4 which is routed from the receipt printer
      7. Copied "OpenBIMonior,bat" on FOH and Kitchen Stations as GCC has a specific category for each monitor
      8. Applied V12 licence
      9. Verified POS Main sales by processing sales of COFFEE ($4.50)  and performing a return so the shift  remains at $0
      10.  Reconfigured Process Setup and set Start time to 6 AM and End Time to 8 PM
      11. Removed PRICE check from Health Check Configuration as GCC does not set prices on all Kit Components
      12. Removed MSDB and Master from Backup databases
      13. Verified and updated Defender AV 
      14. Upgrade completed at 7:16 PM 

      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11788 in the subject line of all emails regarding this issue.

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