Subject: | Automate the "Loyalty Points" redeem process. |
Summary: | Currently, if a user needs to use loyalty points, a voucher must be created and issued to the customer. The customer then redeems the voucher in POS. Following concept was discussed with "Grace Road". - When a loyalty customer is created, a card would be issued to the customers.
- Scan the customer card in POS. This will validate the customer and their loyalty points.
- When a sale is saved for a customer, the payment screen opens.
- This should have the payment option as "Loyalty Points" similar to "Cash"
- If cashier selects the option.
- Verify if the customer is a "Loyalty Customer".
- This option should be not allowed for POSCASH.
- Verify the available points of the customer.
- Calculate the dollar value of the points.
- Update the payment amount in POS.
- Check the balance due. Assuming balance due is $10.00
- If the sale amount is $5.00and Loyalty Points dollar value is $5.00 -Complete Sale
- If the sale amount is $5.00and Loyalty Points dollar value is $2.00 - Allow users to select another payment method.
- If the sale amount is $5.00and Loyalty Points dollar value is $10.00 - Only update $5.00 from loyalty point
- User should be able to change the amount calculated from loyalty points.
- Loyalty dollar value is calculated as $10.
- Payment Due is $10
- Customer wishes to pay $5 cash and $5 from loyalty points.
- Revert the unused points after the sale has been completed.
|
Audit Notes: | Edited by rashna on 17/10/19 13:07. Edited by rashna on 15/10/19 08:28. Edited by rashna on 10/10/19 16:09. Edited by rashna on 09/10/19 16:58. Edited by rashna on 09/10/19 16:49. Edited by rashna on 08/10/19 08:06. Edited by sanjay on 05/10/19 08:01. |
01 Oct 2019 | 02:38PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-10-2019 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, Assigned for approval |
|
05 Oct 2019 | 08:01AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-10-2019 08:01 AM |
| Approved for 11.4 |
|
05 Oct 2019 | 08:01AM Comment 3 by Sanjay (Link Technologies) Case 11769 added to project 11.004.BETA |
07 Oct 2019 | 04:36PM Comment 4 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-10-2019 04:36 PM Time Taken: 16.00 |
| Hi Sanjay Can you make the following changes: - When a loyalty card is scanned, we need to apply loyalty discounts to existing items (already implemented) and any new items that are scanned.
- When the payment method "Loyalty" is selected, use procedure name LT_POS_GetCustomerLoyaltyValue to get the available loyalty amount. The following rules apply:
- If the sale amount is less than "Loyalty Value" then display "Sale Amount"
- User can reduce the "loyalty payment amount"
- Cannot add multiple loyalty lines
- When a sale completed, we create a loyalty redeem transaction and apply this to the transaction.
Regards Alvis |
|
08 Oct 2019 | 08:06AM Comment 5 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
08 Oct 2019 | 08:06AM Comment 6 by Alvis (Link Technologies) Case 11769 added to project 11.004.BETA |
08 Oct 2019 | 06:36PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 08-10-2019 06:36 PM Time Taken: 9.00 |
| Development work for this case has been completed. The change will be available in version:11.4.0810 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - When the payment method "Loyalty" is selected, use the procedure name LT_POS_GetCustomerLoyaltyValue to get the available loyalty amount. The following rules apply:
- If the sale amount is less than "Loyalty Value" then display "Sale Amount"
- User can reduce the "loyalty payment amount"
- Cannot add multiple loyalty lines
2. Affected Areas: - POS Payment Entry
3. The issue was caused by: - Improvement
4. Notes: 5. Next Step: UAT |
|
09 Oct 2019 | 04:49PM Comment 8 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
09 Oct 2019 | 04:49PM Comment 9 by Alvis (Link Technologies) Case 11769 added to project 11.004.BETA |
09 Oct 2019 | 04:58PM Comment 10 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
09 Oct 2019 | 04:58PM Comment 11 by Alvis (Link Technologies) Case 11769 added to project 11.004.BETA |
10 Oct 2019 | 04:04PM Comment 12 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-10-2019 03:56 PM Time Taken: 16.00 |
| Development work for this case has been completed. The change will be available in version:11.4.20191010 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - The loyalty discount is only applied when the Loyalty card is scanned. If the customer is selected, loyalty points cannot be used and Loyalty discounts are not applied
- Minimum profit margin is checked when applying loyalty discounts
- Loyalty redemption is only applied when the Loyalty card is scanned
- Loyalty adjustments changed to allow Points or Dollar amount adjustments
- Loyalty adjustments now show the "Payment Amount", "Conversion amount" and "Points value" in the Adjustments form with Totals at the bottom of the grid
- Adjustments form shows Loyalty "points earned" and "Points used" with totals
- Changed the "PointsToDollar" conversion default to 200. Previously we were using ".01". The calculations were not correct in prior versions
- Now showing Loyalty available in Payments form
- Changed demo data to show realistic loyalty setup
2. Affected Areas: - Loyalty Processing
- POS Processing
3. The issue was caused by: - Improvement and Correction to the Loyalty Points system
4. Notes: 5. Next Step: UAT |
|
10 Oct 2019 | 04:09PM Comment 13 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
10 Oct 2019 | 04:09PM Comment 14 by Sanjay (Link Technologies) Case 11769 added to project 11.004.BETA |
14 Oct 2019 | 03:09PM Comment 15 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-10-2019 01:38 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 No | Test Description | Pass/Fail | 1 | Create a new customer as "CU000001", This is a loyalty customer . Loyalty point set is as below - Discount - 5 %
- Points Factor is 1
- Loyalty points to a dollar - 100
- Customer card -999999
- Process a sale of 1433.33.
- Point Factor should be updated as 1.
- Points should be 143.45.
- Points Value should 1.43
| Pass | 2 | Loyalty point set is as below - Discount - 5 %
- Points Factor is 6
- Loyalty points to a dollar - 100
- Process a sale of 10
- Point Factor should be updated as 0.6
- Points should be 6.
- Points Value should 0.06
| Pass | 3 | The loyalty discount is only applied when the Loyalty card is scanned. If the customer is selected, loyalty points cannot be used and Loyalty discounts are not applied Set the loyalty discount of 5% for a Bronze Customer, - Load the customer using the loyal card L99999L - This should depict the 5% discount
- Search and load the customer - This should have the default discount
| Pass | 4 | Minimum profit margin is checked when applying loyalty discounts - Price of item is 60.
- Cost is 33.33
- Markup is 80.00
| Pass | 5 | Loyalty redemption is only applied when the Loyalty card is scanned
| Pass | 6 | Loyalty adjustments changed to allow Points or Dollar amount adjustments - Current points as 149.45
- Process an adjustment out of 100 points, this should recalculate points to 49.45
- Dollar value = 49.45/100 - .49
- Process an adjustment out of .2 , this should recalculate points to .29
| Pass | 7 | Loyalty adjustments now show the "Payment Amount", "Conversion amount" and "Points value" in the Adjustments form with Totals at the bottom of the grid
| Pass | 8 | Adjustments form shows Loyalty "points earned" and "Points used" with totals
| Pass | 9 | Changed the "PointsToDollar" conversion default to 200. Previously we were using ".01". The calculations were not correct in prior versions
| Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 11.4.1011
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: - Documentation
|
|
15 Oct 2019 | 08:28AM Comment 16 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
15 Oct 2019 | 08:28AM Comment 17 by Sanjay (Link Technologies) Case 11769 added to project 11.004.BETA |
17 Oct 2019 | 01:07PM Comment 18 by Rashna (Edge Business Solutions) Case 11769 removed from project 11.004.BETA |
17 Oct 2019 | 01:07PM Comment 19 by Alvis (Link Technologies) Case 11769 added to project 11.004.BETA |
05 Dec 2019 | 12:48PM Comment 20 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-12-2019 12:42 PM Time Taken: 1.00 |
| Hi Sanjay, Documentation has been updated at Point of Sale - Maintenance- Loyalty Thanks Rashna |
|