0046229: It is not possible to select the same product in different discounts of type "Price Adjustment"

Description

It is not possible to select the same product in different discounts of type "Price Adjustment" with different dates.

Steps To Reproduce

Backend:

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.

Tags

No tags attached.

Attached Files

5.png [^] (163,551 bytes) 2021-04-08 12:53

Relationships [ Relation Graph ] [ Dependency Graph ]

has duplicate

defect

0048362

closed

Triage Omni OMS

Openbravo ERP

Products not found when searching from Add products in Discounts and promotions

Notes
(0127283) hgbot (developer) 2021-04-15 07:24	Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/347 [^]

(0127356) hgbot (developer) 2021-04-19 08:05	Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/347 [^]

(0127357) hgbot (developer) 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 ---

Issue History
Date Modified	Username	Field	Change
2021-04-08 12:53	Leyre	New Issue
2021-04-08 12:53	Leyre	Assigned To	=> Retail
2021-04-08 12:53	Leyre	File Added: 5.png
2021-04-08 12:53	Leyre	OBNetwork customer	=> OBPS
2021-04-08 12:53	Leyre	Support ticket	=> 23100
2021-04-08 12:53	Leyre	Resolution time	=> 1619647200
2021-04-08 12:53	Leyre	Triggers an Emergency Pack	=> No
2021-04-09 13:01	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2021-04-15 07:24	hgbot	Merge Request Status	=> open
2021-04-15 07:24	hgbot	Note Added: 0127283
2021-04-19 08:05	hgbot	Merge Request Status	open => approved
2021-04-19 08:05	hgbot	Note Added: 0127356
2021-04-19 08:05	hgbot	Resolution	open => fixed
2021-04-19 08:05	hgbot	Status	new => closed
2021-04-19 08:05	hgbot	Fixed in Version	=> PR21Q3
2021-04-19 08:05	hgbot	Note Added: 0127357
2022-01-14 15:30	vmromanos	Relationship added	has duplicate 0048362