Pilot upgrade for Gold Creek Cafe

1. Upgrade the database to version 11.004
2. Upgrade customizations, if any
3. Perform system tests

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

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

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

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.

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.

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

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

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