Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046229Retail ModulesDiscounts and Promotionspublic2021-04-08 12:532021-04-19 08:05
ReporterLeyre 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0046229: It is not possible to select the same product in different discounts of type "Price Adjustment"
DescriptionIt is not possible to select the same product in different discounts of type "Price Adjustment" with different dates.
Steps To ReproduceBackend:

1. Create a new discount:
   1.1 Discount/Promotion Type = Price Adjustment
   1.2 Starting Date = 07-04-2021
   1.3 Ending Date = 14-04-2021
   1.4 Discount % = 10
2. Click "Add Product" and select the "Ale Beer 0.5 L" product.

3. Create another discount:
   3.1 Discount/Promotion Type = Price Adjustment
   3.2 Starting Date = 15-04-2021
   1.3 Ending Date = 22-04-2021
   1.4 Discount % = 10

4. Clcik "Add Product" and verify that the "Ale Beer 0.5 L" product is not available.

See attached image showing the reason why the same product can not be selected in different discounts, with different date.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0048362 closed Triage Omni OMS Openbravo ERP Products not found when searching from Add products in Discounts and promotions 
Attached Filespng 5.png (163,551) 2021-04-08 12:53
https://issues.openbravo.com/file_download.php?file_id=15508&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2021-04-08 12:53LeyreNew Issue
2021-04-08 12:53LeyreAssigned To => Retail
2021-04-08 12:53LeyreFile Added: 5.png
2021-04-08 12:53LeyreResolution time => 1619647200
2021-04-08 12:53LeyreTriggers an Emergency Pack => No
2021-04-09 13:01ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2021-04-15 07:24hgbotNote Added: 0127283
2021-04-19 08:05hgbotNote Added: 0127356
2021-04-19 08:05hgbotResolutionopen => fixed
2021-04-19 08:05hgbotStatusnew => closed
2021-04-19 08:05hgbotFixed in Version => PR21Q3
2021-04-19 08:05hgbotNote Added: 0127357
2022-01-14 15:30vmromanosRelationship addedhas duplicate 0048362

Notes
(0127283)
hgbot   
2021-04-15 07:24   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/347 [^]
(0127356)
hgbot   
2021-04-19 08:05   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/347 [^]
(0127357)
hgbot   
2021-04-19 08:05   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 720995d26f9eb7b18a751ea1852b01927cd481b8
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-04-19T06:05:02+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/720995d26f9eb7b18a751ea1852b01927cd481b8 [^]

Fixed ISSUE-46229: Removed HQLWhereClause for ProductSelector in Discounts Window
* In Discounts Window, Removed HQLWhereClause for Product, Category, Organization Selectors since values should be listed for all discounts

---
M src-db/database/sourcedata/AD_TAB.xml
---