Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045144Retail ModulesWeb POSpublic2020-09-25 12:212020-11-02 07:22
Reporterrafaroda 
Assigned Toprakashmurugesan88 
PriorityhighSeveritymajorReproducibilityalways
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
Summary0045144: Fix incremental and full refresh with Multi Tax Category module
DescriptionFix incremental and full refresh with Multi Tax Category module

Steps To ReproduceWith Multi Tax Category module, the incremental and full refresh queries are slow
Proposed SolutionAs discussed with Antonio:
* A new field will be created to indicate in Organization Level the tax organization
* A new preference to make use of that organization

This will allow the incremental refresh and full refresh queries to look for the proper tax organization directly instead of the organization tree to make it faster
Additional Information
TagsNOR
Relationships
related to defect 0045055 closed ranjith_qualiantech_com Retail Modules Incremental refresh of ProductCharacteristic cannot use index on updated 
related to defect 0044911 closed ranjith_qualiantech_com Retail Modules Incremental refresh of Product cannot use index on updated 
related to defect 0044590 closed ranjith_qualiantech_com Retail Modules Product tax category changes are not updated in webpos 
related to feature request 0045056 new Retail Retail Modules Faster insertion of big amounts of data in full refresh in indexedDB 
related to defect 0045187 closed ranjith_qualiantech_com Retail Modules Full Refresh fail: continues the load when it should stop 
related to defect 0045248 closed prakashmurugesan88 Retail Modules Copy store does not copy field Organization Tax Category from Organization window 
related to defect 0045467 closed prakashmurugesan88 Retail Modules Performance issues on the model CharacteristicValue 
related to defect 0045919 closed rqueralta Retail Modules Extra join of product table in master.product 
related to design defect 0045922 acknowledged Triage Platform Base Openbravo ERP Extra self-join with main table when using computed columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-09-25 12:21rafarodaNew Issue
2020-09-25 12:21rafarodaAssigned To => marvintm
2020-09-25 12:21rafarodaResolution time => 1602280800
2020-09-25 12:21rafarodaTriggers an Emergency Pack => No
2020-09-25 12:21rafarodaTag Attached: NOR
2020-09-25 12:22rafarodaRelationship addedrelated to 0045055
2020-09-25 12:22rafarodaRelationship addedrelated to 0044911
2020-09-25 12:23rafarodaRelationship addedrelated to 0044590
2020-09-25 12:23rafarodaRelationship addedrelated to 0045056
2020-09-28 07:32marvintmAssigned Tomarvintm => Retail
2020-10-05 07:10ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2020-10-05 08:45ranjith_qualiantech_comAssigned Toranjith_qualiantech_com => Retail
2020-10-05 11:36rafarodaRelationship addedrelated to 0045187
2020-10-07 09:13marvintmResolution time1602280800 => 1602885600
2020-10-14 08:56marvintmResolution time1602885600 => 1603490400
2020-10-19 14:55rafarodaRelationship addedrelated to 0045248
2020-10-22 07:47marvintmResolution time1603490400 => 1604962800
2020-10-28 14:53hgbotNote Added: 0123978
2020-10-29 15:39marvintmAssigned ToRetail => prakashmurugesan88
2020-10-29 15:39marvintmStatusnew => scheduled
2020-10-29 15:40hgbotNote Added: 0124012
2020-10-29 15:40hgbotNote Added: 0124013
2020-10-29 15:40hgbotResolutionopen => fixed
2020-10-29 15:40hgbotStatusscheduled => closed
2020-10-29 15:40hgbotNote Added: 0124014
2020-10-29 15:40hgbotNote Added: 0124015
2020-10-30 07:17hgbotNote Added: 0124029
2020-11-02 06:20hgbotNote Added: 0124074
2020-11-02 07:22hgbotNote Added: 0124079
2020-11-02 07:22hgbotNote Added: 0124080
2021-02-22 09:33rafarodaRelationship addedrelated to 0045467
2021-02-22 10:47rafarodaRelationship addedrelated to 0045919
2021-02-22 10:47rafarodaRelationship addedrelated to 0045922

Notes
(0123978)
hgbot   
2020-10-28 14:53   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/3 [^]
(0124012)
hgbot   
2020-10-29 15:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: ba9d028171eed6edd81aa2f47fa9c213eedf93ec
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:18:26+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/ba9d028171eed6edd81aa2f47fa9c213eedf93ec [^]

Related to BUG-45144: Added Organization tax category to improve full and incremental refresh

---
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryLoadedProductProperties.java
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryProductProperties.java
---
(0124013)
hgbot   
2020-10-29 15:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 648605ebc621e37aa1265c830958250ba276e846
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:18:51+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/648605ebc621e37aa1265c830958250ba276e846 [^]

Related to BUG-45144: Added Organization tax category to improve full and incremental refresh

---
A src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_PREFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0124014)
hgbot   
2020-10-29 15:40   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 25cf289c1a0d2c0ab34dbec530fa4637bb249298
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:19:38+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/25cf289c1a0d2c0ab34dbec530fa4637bb249298 [^]

Fixed BUG-45144: Fixes model issues

---
A src-db/database/model/modifiedTables/AD_ORG.xml
A src-db/database/sourcedata/AD_COLUMN.xml
A src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryLoadedProductProperties.java
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryProductProperties.java
---
(0124015)
hgbot   
2020-10-29 15:40   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/3 [^]
(0124029)
hgbot   
2020-10-30 07:17   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: a82041b5deabfd17d68562237ff01196310fa472
Author: Antonio Moreno <anmorenoperez@gmail.com>
Date: 2020-10-30T07:17:35+01:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/a82041b5deabfd17d68562237ff01196310fa472 [^]

Related to BUG-45144: Added missing FK

---
M src-db/database/model/modifiedTables/AD_ORG.xml
---
(0124074)
hgbot   
2020-11-02 06:20   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/4 [^]
(0124079)
hgbot   
2020-11-02 07:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 5a36711664d82f56a92295bfb1aae8e08be1a1d9
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-30T18:42:51+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/5a36711664d82f56a92295bfb1aae8e08be1a1d9 [^]

Fixed BUG-45144: Fixed selector reference to list only natural org tree in Organization Tax Category field

---
A src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0124080)
hgbot   
2020-11-02 07:22   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/4 [^]