Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0052897Openbravo ERP00. Application dictionarypublic2023-06-16 02:012023-07-04 07:07
axelmercado 
ranjith_qualiantech_com 
immediatecriticalalways
closedfixed 
5
 
PR23Q2.2 
Core
Production - QA Approved
2023-02-15
PR23Q2
https://gitlab.com/openbravo/product/openbravo/-/commit/ae50b716be895db7f75fad22f3a2cf9bc5981093 [^]
No
0052897: Problem with 'Product' tab in 'Discounts and promotions' window in a customer without retail
A condition corresponding to the Retail Discounts module has been added in the latest versions, it was added in the following issue: https://issues.openbravo.com/view.php?id=50706. [^]
The problem is that it was applied without taking into account the customers that do not have Retail and that can make use of the window.

The filter is 'e.obdiscIsGift=false' and is a where clause found in the 'Product' tab of the 'Discounts and promotions' window.

If an attempt is made to open the window and the tab, an error is generated.
Just try opening the 'Discounts and promotions' window and then the 'Product' tab.

Again to clarify: Only for non-retail customers.
There is no nice way to fix this problem. The proposal would be:
- Remove the display logic from the field in Core
- Add it back for Retail instances, through the Configuration Script in the Retail template.

This will mean that the tabs will not fully work in basic Core, but as those discount filters anyway are not implemented for the backoffice, it should not be a big problem, and in Retail instances it will work correctly.
No tags attached.
blocks defect 0052762 closed ranjith_qualiantech_com Problem with 'Product' tab in 'Discounts and promotions' window in a customer without retail 
Issue History
2023-06-30 09:42marvintmTypedefect => backport
2023-06-30 09:42marvintmTarget Version => PR23Q2.2
2023-07-03 11:42ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2023-07-03 14:56hgbotNote Added: 0152061
2023-07-03 14:56hgbotNote Added: 0152062
2023-07-04 07:07hgbotResolutionopen => fixed
2023-07-04 07:07hgbotStatusscheduled => closed
2023-07-04 07:07hgbotFixed in Version => RR23Q2.2
2023-07-04 07:07hgbotNote Added: 0152080
2023-07-04 07:07hgbotNote Added: 0152081
2023-07-04 07:07hgbotNote Added: 0152082
2023-07-04 07:07hgbotNote Added: 0152083

Notes
(0152061)
hgbot   
2023-07-03 14:56   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/merge_requests/4 [^]
(0152062)
hgbot   
2023-07-03 14:56   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/927 [^]
(0152080)
hgbot   
2023-07-04 07:07   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/merge_requests/4 [^]
(0152081)
hgbot   
2023-07-04 07:07   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack [^]
Changeset: 1f3be23c52cb7af12fc5343cfaaac1c116bcfe3a
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 03-07-2023 18:20:35
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/commit/1f3be23c52cb7af12fc5343cfaaac1c116bcfe3a [^]

Fixed ISSUE-52897: Added HQLWhereClause for Discount Products tab
* Added HQLWhereClause for Discount's Product tab & Gift Products tab
* Discount's Gift Products tab should be displayed if retail pack is present

---
M src-db/database/configScript.xml
---
(0152082)
hgbot   
2023-07-04 07:07   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 927244d13254164b96bd2714b6294e4a8385e6d9
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 03-07-2023 18:22:15
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/927244d13254164b96bd2714b6294e4a8385e6d9 [^]

Related to ISSUE-52897: Removed HQLWhereCluase from Discounts product tab
* Discount's Gift Products tab should be displayed if retail.pack module is present

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0152083)
hgbot   
2023-07-04 07:07   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/927 [^]