| Subject: | System is unable to apply around off figure as discount using "Utility --> Discount" |
| Summary: | Bula Vinaka Team, We have a scenario, where when we try to give a discount of $10, the system formulates it to $9.99. This has been tested in V10.144, in the demo database. Refer steps to Replicate: - Login into Backoffice
- Create four purchase items in the price:
- Product Code: 001 - Item 1
- Product Code: 002 - Item 2
- Product Code: 003 - Item 3
- Product Code: 004 - Item 4
- Setup price as :
- Product Code: 001 - $145
- Product Code: 002 - $10
- Product Code: 003 - $110
- Product Code: 004 - $65
- Pass an Inventory Adjustment for these items:
- Adjust In by 100 at a cost of $1.98
- For the location: Retail
- Login into POS
- Load the 4 items
- Quantity is 1 for all four
- Total Value is $330
- Click on Utilities
- Click on Discounts
- Click on Total
- Discount Amount = $320 (user wants to give a discount of $10.00 on total value)
- When the discount is applied, the Total Discount value comes to $9.99 and the Total Value is $320.01
However, the user requires that the Total Discount value to be $10.00 and the Total Value is $320.00. Please look into this. Regards
Aarti Gayaneshwar
|
| Audit Notes: | Edited by sanjay on 11/09/19 15:23. Edited by alvis on 28/06/19 14:30. Edited by rashna on 21/06/19 06:28. Edited by aarti on 17/06/19 08:10. Edited by aarti on 17/06/19 08:09. Edited by aarti on 17/06/19 07:45. |
| 21 Jun 2019 | 06:27AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 21-06-2019 06:27 AM Time Taken: 2.00 |
| Hi Alvis, Please address this case. Thanks
Rashna |
|
| 21 Jun 2019 | 06:28AM Comment 2 by Rashna (Edge Business Solutions) Case 10478 added to project 11.0 |
| 21 Jun 2019 | 09:32AM Comment 3 by Alvis (Link Technologies) Case 10478 removed from project 11.0 |
| 21 Jun 2019 | 09:36AM Comment 4 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 21-06-2019 09:36 AM Time Taken: 2.50 |
| Hi Aarti, When the system gives a bulk discount, it needs to equally distribute the discount across all the items. To do this, the system gets a ratio of discount to be given. Ratio = <Bulk Discount> divide by <Total Sale>
= 10 / 330 This ratio is then applied to each line to get the line discount. | Item | Price | Ratio | Discount | | Item 1 | 145.00 | 10/330 | 4.39 | | Item 2 | 10.00 | 10/330
| 0.30 | | Item 3 | 110.00 | 10/330
| 3.33 | | Item 4 | 65.00 | 10/330
| 1.97 |
|
| Total Discount | 9.99 |
The total discount given would be $9.99. regards
Alvis
|
|
| 28 Jun 2019 | 06:57AM Comment 5 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 02-07-2019 12:00 AM Time Taken: 2.50 |
| Hi Sanjay, Referring to this scenario, "The company has advised the customer that we are going to discount you $10 on the total sale value " - A credit sale was made to Customer X where $10 bulk discount was applied
- But the system disturbed that discount amount and the final discount value was set as $9.99 - whereby it should have been $10
- The Customer's ending balance now is $320.01
However, the customer pays a cheque of $320.00. How will that $0.01 be offset in the system?? The system will not allow a credit note to be passed for $0.01: 
This is a scenario was adapted from a client site. The discount is normally applied on the Total Sale Value and the user finds using Bulk Discount a good method rather than using line discount. Requesting if you can look into this and enhance the system to spread the discount value accordingly if Bulk Discount is used. In this case, $10 - should have spread out in the transactions so that the Total Discount value is $10. Kind Regards
Aarti Gayaneshwar
|
|
| 28 Jun 2019 | 02:30PM Comment 6 by Alvis (Link Technologies) Case 10478 added to project 11.0 |
| 28 Jun 2019 | 02:33PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-06-2019 02:33 PM Time Taken: 2.50 |
| Development work for this case has been completed. The change will be available in version: 11.0.0628 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Corrected the payment/credit note amount validation to allow for 0.01.
2. The issue was caused by: - The validation was checking for amounts greater than 0.01 instead of greater than or equal to 0.
3. Next Step: - UAT
4. Notes: |
|
| 01 Jul 2019 | 09:03AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-07-2019 09:03 AM Time Taken: 2.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 | Process a credit note with amount as 0 , this should not be allowed | Pass | | 2 | Process a credit note with amount as -5 , this should not be allowed
| Pass | | 3 | Process a credit note with amount as 0.01 , this should be allowed
| Pass | | 4 | Process a credit note with amount a positive amount, this should be allowed
| Pass | | 5 | Validate that the credit note has been updated in the customer screen | Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 11.0.0628 BETA
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: Closure
|
|
| 09 Oct 2019 | 08:17AM Comment 9 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - Cleared queue due to large number of calls |