Company: Link Technologies
Case No: L12189. Project: 12.30: LinkSOFT Version 12.30
Logged By: Alvis (Link Technologies) on 01 Mar 2021 02:40PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 3.00 (Weight: 4.00)
Version: 12.32
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 05 March 2021 11:59 PM [1148 days since logged date]
Status: Closed
Subject: Customer Loyalty Transaction report showing incorrect points value when points are redeemed
Summary:    

Customer Loyalty Transaction report showing incorrect points value when points are redeemed. See screenshot below:


Audit Notes:Edited by alvis on 03/03/21 13:09. Edited by alvis on 03/03/21 08:27. Edited by alvis on 02/03/21 16:17. Edited by alvis on 01/03/21 14:40. 
01 Mar 202102:37PM Comment 1 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 01-03-2021 08:35 PM Time Taken: 1.00
PART A - Impact Analysis Instructions:
1. Update the case header and ensure the Priority, Category, Group, Weight, and other details are correct
2. Update the case header with a clear and concise description of the problem.
3. Itemize and number each section so it can be clearly referenced.
4. Update the case Subject to clearly describe the issue
5. If there is a significant change to the effort, assign the case to Sanjay for approval.
6. Cleanup the case header and ensure blank lines and formatting is neat. The case should contain relevant statements only.

PART B - Analysis
1. Verify the request. If System Issue, verify the issue exists. If New/Improvement, verify justification.
2. The following changes will be required
:
a. Change loyalty adjustment menu and report to use a common data extraction. 

2. Affected Areas:
a. Loyalty adjustment menu
b. Customer Loyalty transactions report

3. The issue was caused by: inconsistent calculations between the report and loyalty adjustment menu.

Is there a significant change in the effort to complete this case: No
Next Step: (proceed with development or approval required) Proceed with development

----------------------

PART C - Development Reference (Place descriptor for objects changed):

1. Other areas in the system that could have a similar issue (and provide next steps):
a. 

2. Notes:


01 Mar 202102:40PM Comment 2 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2021 08:37 PM Time Taken: 1.00
PART A - Development Completed Instructions:
Before Development is started, ensure the following is ready:
1. The case has a clear definition of the issue or change required
2. A test plan is in place
3. Change has been approved by Sanjay

Note:
a. System Test is performed by development in the "Finalised" Development environment (http://linktechnologies.com.au/dev-linksoft-{version}
b. UAT is performed using the installation provided

PART B - Development work for this case has been completed.

1. The change will be available in version:12.4

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

  1. Create a view for loyalty transactions that has the calculations for Payment Amount, Points and Points Value. 
  2. This view is used in the data extraction for the "Customer Loyalty Transactions report" and "Loyalty Adjustments" menu.

3. Affected Areas:

  1. Loyalty adjustment menu
  2. Customer Loyalty transactions report

4. The issue was caused by:

    inconsistent calculations between the report and the loyalty adjustment menu.

    5. Notes
    6. Next Step
    (Review and System Test (Developer) -> UAT (Quality) -> Documentation)Review and System Test

    ----------------------

    PART C - Development Reference (Place descriptor for objects changed):

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

    2. Other relevant notes:


    01 Mar 202102:40PM Comment 3 by Alvis (Link Technologies) ETC was changed from 05/03/2021 to 05/03/2021
    02 Mar 202104:17PM Comment 4 by Alvis (Link Technologies) Case L12189 added to project 12.3
    15 Mar 202102:52PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-03-2021 08:33 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
    1

    Enable Loyalty for customer 0004.

    1. Type - Bronze
    2. Points Factor - 0.6
    3. Points to Dollar Value - 200.
    Pass
    2

    Process a sale for the customer worth 25.

    Validate that the "Loyalty Adjustment" screen and  "Customer Loyalty Transaction Report" is updated as below

    1. Dollar Value = 25
    2. Points Factor = 0.6
    3. Points =15 (25*0.6)
    4. Points Value = 0.08 (15/200)
    5. Total = 0.08
    Pass
    3

    Redeem 5 points for the customer.

    Validate that the "Loyalty Adjustment" screen and  "Customer Loyalty Transaction Report" is updated as below

    1. Dollar Value = 0
    2. Points Factor = 0
    3. Points =-5 
    4. Points Value = -0.03 (5/200)
    5. Total= 0.05
    Pass

    Environment Details

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

    Next Step

    1. For Closure

      15 Mar 202104:05PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 15-03-2021 10:05 PM
      Thanks Rashna

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

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