Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0052896Openbravo ERP00. Application dictionarypublic2023-06-16 02:012023-07-04 07:07
axelmercado 
ranjith_qualiantech_com 
immediatecriticalalways
closedfixed 
5
 
PR23Q3 
Core
Production - QA Approved
2023-02-15
PR23Q2
https://gitlab.com/openbravo/product/openbravo/-/commit/ae50b716be895db7f75fad22f3a2cf9bc5981093 [^]
No
0052896: 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 => PR23Q3
2023-07-03 11:42ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2023-07-03 14:54hgbotNote Added: 0152059
2023-07-03 14:54hgbotNote Added: 0152060
2023-07-04 07:07hgbotResolutionopen => fixed
2023-07-04 07:07hgbotStatusscheduled => closed
2023-07-04 07:07hgbotFixed in Version => RR23Q3
2023-07-04 07:07hgbotNote Added: 0152076
2023-07-04 07:07hgbotNote Added: 0152077
2023-07-04 07:07hgbotNote Added: 0152078
2023-07-04 07:07hgbotNote Added: 0152079

Notes
(0152059)
hgbot   
2023-07-03 14:54   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/merge_requests/3 [^]
(0152060)
hgbot   
2023-07-03 14:54   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/926 [^]
(0152076)
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: 8b04fceeb04a498f57955d10081c9ca5c7113894
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 03-07-2023 17:38:53
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/commit/8b04fceeb04a498f57955d10081c9ca5c7113894 [^]

Fixed ISSUE-52896: 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
---
(0152077)
hgbot   
2023-07-04 07:07   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.pack/-/merge_requests/3 [^]
(0152078)
hgbot   
2023-07-04 07:07   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 8da26360e654a707d3b572ebdcafd34ecfb18a8c
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 03-07-2023 17:39:06
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/8da26360e654a707d3b572ebdcafd34ecfb18a8c [^]

Related to ISSUE-52896: 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
---
(0152079)
hgbot   
2023-07-04 07:07   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/926 [^]