Company: Link Technologies
Case No: L09522. Project: 10.10: LinkSOFT Version 10.1
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 20 Aug 2018 02:54PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 18.50 (Weight: 18.50)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Tuesday, 21 August 2018 12:00 AM [2522 days since logged date]
Status: Closed
Subject: Enhance control on “Allow Price Change” Functionality
Summary:    
Functionality Change Issue

In version 8.18 we changed the “Allow Price Change” functionality and separated it from the discount functionality because incorrect tax was being calculated after price was altered. While this would have solved the system side of things, it has created the following issues for my clients in Fiji.

  1. Cashiers had access to Price Override functionality specifically to be able to increase price.
  2. Previously when the cashier reduced the price of an item, the percentage of price reduction was controlled  by the discount percentage set at user level. If cashier had "0" set as the "discount amount" then supervisor access was required if prices had to be reduced. This came in handy when prices were marked off significantly when they reached near expiry.
  3. Now from version 8.18 and above, we have separated the Price override from discount. We had to remove access for price override from cashiers role as this would have given cashier access to sell at 0 price. 
The below clients had been affected significantly by this change:
  1. Roopesh Gift Shop gave cashiers access to "Price Override" to sell more than RRP price to certain customers.
  2. Shop fittings has set prices at Price Level 1 to 3 as well as the RRP. If customers asks for discount, cashiers could select price 1 which is a few cents cheaper than the RRP. If customer requested for more discount than price level 2 was chosen. Cashiers did not need to know the price off hand in this scenario as this was set in system. Due to Separation of the functionality, price over ride access had to be removed as Cashiers were found selling below cost. The selection of Prices from Price Level is controlled directly by the Price Override functionality.
The change that I am suggesting here is:
  1. We control the price reduction using the "discount amount" set at user maintenance. We don't have to display the difference between the new unit price and RRP in the discount field. The value set as "discount amount" for each user would be solely to control the percentage of price reduction by user
Below test Cases needs to be passed. Please add if any would have been missed

Business Scenario : 
  1. For user "Cashier", setup discount amount as 10 and "Value/Percent" as "Percent" at menu 222
  2. For item A002, setup RRP as $10, Price level 1 as $9.50, Price Level 2 as $9.00 and Price Level 3 as $8.50
  3. Cashier has access to price override. 
  4. Log in with user "Cashier" and perform the below transactions


Test Case NoBusiness ScenarioExpected ResultsSystem Result
1.Load item A002 on POS processing grid, click on Unit Price and select Price Level 1Cashier should be able to successfully load price of $9.50 as the new Unit Price on the POS Grid
2. Click on Unit Price and now select Price Level 2.Cashier should be able to successfully load price of $9.00 as the new Unit Price on the POS Grid

3. Click on Unit Price and now select Price Level 3.
When cashier click on Price level 3, username and password should be required as this user has only access to override up to 10% only
4. Click on Unit Price and change the price to $20
Cashier should be able to load this new price of $20 on the POS grid
5.Click on Unit Price and change the price back to $10Cashier should be able to load this price of $10 on POS grid as this is the actual price

6.Click on Unit Price while it is still set as $10, now select Price Level 2. Click on ok. Once price of $9.50 is loaded, give discount of 10% on this amountWhen cashier clicks on discount, system should prompt user message that price override will be removed and load original price of $10 before discount is applied.
7.While item A002 is loaded on POS grid with price as $9.50, load item  A003 on POS Grid and give bulk discount.Since cashier does not have access to Bulk discount, username and password should be required. Once administrator gives a new percentage price or New Total, System to reset the price of Item A002 to $10 and apply discount on that.



Audit Notes:Edited by sanjay on 05/03/19 09:43. Edited by sanjay on 10/10/18 14:32. Edited by vineet on 17/09/18 17:17. Edited by vineet on 20/08/18 14:54. Edited by aarti on 20/08/18 12:57. Edited by aarti on 20/08/18 12:57. 
31 Aug 201802:17PM Comment 1 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 31-08-2018 02:17 PM Time Taken: 0.50

Hi Sanjay

Further to our development meeting dated: 21.08.2018 between Alvis, Sanjay and Rashna, please review this case. I need to give access to users for price override up only. At this moment, giving access to price override gives users to even sell at 0. We have to note that clients had this functionality before even though control was at discount percentage value. For client, we have removed an important feature from the system by resolving our price change calculating incorrect tax issue. 

Please review and if possible add it as a patch release.

Regards
Vineet Ram


04 Sep 201804:15PM Comment 2 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 04-09-2018 04:15 PM

Hi Vineet, this case needs to be written clearly. There is a lot of "Noise" in the paragraph. Close this case and create a new one with clear and relevant information only.

Thanks


19 Sep 201802:49PM Comment 3 by Vineet (Link Business Solutions) Assigned To: Development Followup Date: 19-09-2018 02:49 PM Time Taken: 2.00

-- Development Meeting 19.09.2018 Sanjay Alvis, Vineet --

Agreed on the following design:

  1. "Allow price change" will be used to enable/disable the "Unit Price Field" in the price change form. The option to enable this field will be added based on username and password.
  2. Discount Amount value will be used to determine the discount amount only. If discount amount is 0, this indicate discount is not allowed. The option to enable this field will be added based on username and password.
  3. When Price Label value is 0, disable the button in the price change form.

Approved for development in version 10.1



19 Sep 201802:49PM Comment 4 by Alvis (Link Technologies) Case 9522 added to project 10.1
03 Oct 201810:55AM Comment 5 by Alvis (Link Technologies) Case 9522 removed from project 10.1
03 Oct 201810:56AM Comment 6 by Alvis (Link Technologies) Case 9522 added to project 10.0
03 Oct 201801:20PM Comment 7 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-10-2018 01:20 PM Time Taken: 1.00

1. Removed "Discount" from "User Maintenance". The following procedures were changed to remove "Discount" column:

  • LT_SAA_User_Select
  • LT_SAA_USER_Insert
  • LT_SYA_USER_SELECT
  • LT_UTILITY_MergeApplication
2. Changed Backoffice "User Maintenance" form and removed "Discount" column.

Assigned to Sanjay to complete changes as per comment 3.


03 Oct 201805:53PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-10-2018 05:53 PM Time Taken: 5.00
Development work for this case has been completed.
The change will be available in version: 10.06

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

  1. Price Change field is READ ONLY when the user does not have access
  2. Added User security icon to allow "price change user security" prompt
  3. Changed procedure to disable "Price Label" Button when Price Label amount is zero
  4. Discount is allowed based on Discount amount value rather than "Discount Allowed" field

2. The issue was caused by:

  1. Change Request

    3. Next Step

    1. UAT

    05 Oct 201808:20AM Comment 9 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-10-2018 08:20 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
    1

    Price Change field is READ ONLY when the user does not have access

    Pass
    2

    Added User security icon to allow "price change user security" prompt

    Pass
    3

    Changed procedure to disable "Price Label" Button when Price Label amount is zero

    Pass
    4

    Discount is allowed based on Discount amount value rather than "Discount Allowed" field

    Fail. Message: User is not authorized to give discounts

    Environment Details

    1. OS version: Windows 7
    2. Application version: 10 Beta 4
    3. Setup: Demo
    4. Server : 10.0.0.10
    5. Database: UAT-LINKSOFT-DemoData

    Next Step: Assigned to development to resolve.


      05 Oct 201803:11PM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-10-2018 03:11 PM Time Taken: 1.00
      Development work for this case has been completed.
      The change will be available in version: 10 beta7

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

      1. Discount is based on user's discount limit and products configuration.
      2. The security access "640-14 Allow Discount to Sale Total" was added since we did not check item properties (refer to case 1254 comment 11). Since minimum profit margin is now checked, we can remove "640-14".

      2. The issue was caused by:

      1. Change request

        3. Next Step

        1. UAT

        05 Oct 201803:36PM Comment 11 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-10-2018 03:36 PM Time Taken: 1.00
        System test completed. Proceed with UAT

        08 Oct 201803:44PM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 08-10-2018 03:44 PM Time Taken: 2.00
        Hi Sanjay
        QA Results
        Tests carried out according to requirements specified on the case header

        Test Results Summary

        Notes: Testing has been completed with the design developed as per comment 3.

        Table 1 - Summarised list of issues
        NoTest DescriptionPass/Fail
        1"Allow price change" access should enable or disable "Unit Price Field"
        Pass
        2Discount Amount value will be used to determine the discount amount only. If the discount amount is 0, this indicates the discount is not allowed
        Pass
        3When Price Label value is 0, disable the button in the price change form
        Pass
        4

        Set the access for the " Allow Price Change" for cashier as Yes. Loaded item A002.

        • Change the price from 10 to 15. The sale should be successfully completed.
        • Change the prices from the price level (8.5) and the sale should be successfully completed. Tested with all price levels.
        Pass
        5

        Set the access for the " Allow Price Change" for cashier as No. Loaded item A002.

        • Change the price from 10 to 15.
          • Change the price field should be disabled.
          • Username and Password would be used to authenticate price change
        • Change the price from the price level and the sale should be successfully completed.
          • The issue, when the cashier, selects any price level and clicks on save, the message in POS is incorrect.
          • Current Message: - Price Change Authorised By.
            • Set the Price for A002 as 10.
            • Set the price in Price Level 1 as 9.5
            • Load Item
            • Click on the price column
            • Click on Price Level 1 option on the price change form
            • Save.
        Failed
        6

        Set the discount for cashier as

        1. Discount Value = 0,  When the cashier processes a discount authentication should be required
        2. Discount Value = 10% When the cashier processes a discount with 20% authentication should be required
        3. Discount Value = 10% When the cashier processes a discount with 2%. The discount should be allowed. 
          Discount to be further tested in generic tested


        Environment Details

        1. OS version: Windows Server 2012
        2. Application version: 10 Beta 7
        3. Setup: Demo
        4. Server : 10.0.0.10
        5. Database: LINKSOFT-DEMO-10-RASHNA

        Steps to reproduce failed scenarios:

        Next Step: for review by the development team


          09 Oct 201811:24AM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-10-2018 11:24 AM Time Taken: 3.00
          Development work for this case has been completed.
          The change will be available in version: 10.08

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

          1. Changed message to show "Price change by:". If authorisation is not required and price is changed, the note will show current user

          2. The issue was caused by:

          1. Adding price levels did not handle price change

            3. Next Step

            1. SYSTEM Test ~> UAT

            10 Oct 201803:14PM Comment 14 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-10-2018 03:14 PM Time Taken: 1.00
            System test completed. Proceed with UAT.

            11 Oct 201809:03AM Comment 15 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 11-10-2018 09:03 AM
            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

            Disable price over access for the cashier.
            Set the price levels for product PNT01. Unit Price = 10.
            Login into POS as the cashier and load item PNT01 change the unit price from 10 to the RRP price.
            Validate the message in POS.
             

            Pass. 


            Environment Details

            1. OS version: Windows 7
            2. Application version: 10 Beta 8
            3. Setup: Demo
            4. Server : 10.0.0.10
            5. Database: LINKSOFT-DEMO-10-RASHNA

            Steps to reproduce failed scenarios: N/A

            Next Step: for documentation 


              11 Oct 201810:11AM Comment 16 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 11-10-2018 10:11 AM Time Taken: 1.00

              Hi Sanjay, 

              Documentation has been updated under below sections

              • Systems Manager -- Master Security -- Role Menu Access -- POS Role Menu Access.
              • BO Inventory -- Maintenance Setup -- Product Price

              Thanks


              11 Oct 201810:20AM Comment 17 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-10-2018 10:20 AM
              Thanks Rashna

              09 Oct 201908:14AM Comment 18 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
              If you have any queries regarding this support incident, please email Support@LinkTechnologies.com.au and include the Case No: L09522 in the subject line of all emails regarding this issue.

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