Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044590Retail ModulesWeb POSpublic2020-07-10 09:552020-07-30 12:47
Reportermontesm 
Assigned Toranjith_qualiantech_com 
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
Summary0044590: Product tax category changes are not updated in webpos
Descriptionproduct tax category changes are not updated in webpos when using Multi Tax Category: Tax Category subtab inside Product window
Steps To Reproduce-Backoffice
-Product window
-select product S32LTV
-edit Tax Category subTAB
-insert new tax category

-Webpos
-Refresh data
-insert product S32LTV
-Result: shows the old tax category, not the new one
Proposed SolutionHow to fix this? Follow the same approach of Multi UPC tab: When I add/update a Multi UPC record in Multi UPC subtab of Product window, the Updated field in Product window is updated


But in Tax Category subtab of Product window: when I create/update a record, the Updated field in Product window is NOT updated
Additional Information
TagsNOR
Relationships
related to defect 0044911 closed ranjith_qualiantech_com Incremental refresh of Product cannot use index on updated 
related to defect 0045055 closed ranjith_qualiantech_com Incremental refresh of ProductCharacteristic cannot use index on updated 
related to defect 0045144 closed prakashmurugesan88 Fix incremental and full refresh with Multi Tax Category module 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-07-10 09:55montesmNew Issue
2020-07-10 09:55montesmAssigned To => Retail
2020-07-10 09:55montesmTriggers an Emergency Pack => No
2020-07-10 10:19rafarodaResolution time => 1595541600
2020-07-10 10:19rafarodaPrioritynormal => high
2020-07-10 10:19rafarodaDescription Updatedbug_revision_view_page.php?rev_id=21301#r21301
2020-07-10 10:19rafarodaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=21303#r21303
2020-07-10 12:36rafarodaTag Attached: NOR
2020-07-16 08:34ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2020-07-24 11:50rafarodaProposed Solution updated
2020-07-28 13:51ranjith_qualiantech_comStatusnew => scheduled
2020-07-29 13:25hgbotResolutionopen => fixed
2020-07-29 13:25hgbotStatusscheduled => closed
2020-07-29 13:25hgbotNote Added: 0121689
2020-07-29 13:25hgbotNote Added: 0121690
2020-07-30 12:47hgbotNote Added: 0121710
2020-08-28 15:41rafarodaRelationship addedrelated to 0044911
2020-09-25 12:13rafarodaRelationship addedrelated to 0045055
2020-09-25 12:23rafarodaRelationship addedrelated to 0045144

Notes
(0121689)
hgbot   
2020-07-29 13:25   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 2dd903e4af95895f618884e128d74ce7796ffaaa
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2020-07-28T17:24:55+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/2dd903e4af95895f618884e128d74ce7796ffaaa [^]

Fixed ISSUE-44590: Added trigger to reflect the ProductTaxCategory changes in POS
* If any changes made in Multi Tax Category, it should be reflected in POS if it is refreshed
* Trigger will update the product updated column with current time whn DDL even triggers

---
A src-db/database/model/triggers/OBRMTC_UPDATEPRODUCT_TRG.xml
---
(0121690)
hgbot   
2020-07-29 13:25   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/1 [^]
(0121710)
hgbot   
2020-07-30 12:47   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 02e12c3613f6a18c2260bbf988803c46b06c99c5
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2020-07-30T16:17:32+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/02e12c3613f6a18c2260bbf988803c46b06c99c5 [^]

Related to ISSUE-44590: Removed unused variable in OBRMTC_UPDATEPRODUCT_TRG trigger

---
M src-db/database/model/triggers/OBRMTC_UPDATEPRODUCT_TRG.xml
---