Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040349Retail ModulesStoreServerpublic2019-03-11 12:532019-05-06 16:40
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040349: Dataset where clause of fin_financial_account is wrong, it should consider natural org tree
DescriptionCurrently the dataset table of the fin_financial_account table does not have any where clause, and as a consequence all records are exported to all stores.

But it is using the organization based router, so only the records that belong to the natural tree of the store are synchronized once the store is live.

We should either change the whereclause or the router, depending on the functional requirement of what records of fin_financial_account should be present in the store servers
Steps To Reproduce- Checke the dataset table definition and the synchronized table definition of the fin_financial_account table
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-11 12:53AugustoMauchNew Issue
2019-03-11 12:53AugustoMauchAssigned To => AugustoMauch
2019-03-11 12:53AugustoMauchTriggers an Emergency Pack => No
2019-04-25 10:29hgbotCheckin
2019-04-25 10:29hgbotNote Added: 0111302
2019-04-25 10:29hgbotStatusnew => resolved
2019-04-25 10:29hgbotResolutionopen => fixed
2019-04-25 10:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/9c83c6e8f73716614b5e591de2ab015c9395ebc8 [^]
2019-04-25 10:29AugustoMauchReview Assigned To => mtaal
2019-05-02 09:48hgbotCheckin
2019-05-02 09:48hgbotNote Added: 0111421
2019-05-06 16:40mtaalNote Added: 0111507
2019-05-06 16:40mtaalStatusresolved => closed

Notes
(0111302)
hgbot   
2019-04-25 10:29   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 9c83c6e8f73716614b5e591de2ab015c9395ebc8
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Apr 25 10:29:11 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/9c83c6e8f73716614b5e591de2ab015c9395ebc8 [^]

Fixes issue 40349: Fixes dataset table where clause of fin_financial_account

The fin_financial_account must be exported based on its organization. Its router was already doing,
this changeset fixes the dataset table where clause.

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0111421)
hgbot   
2019-05-02 09:48   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: bfd3237ac9df5b0e57b27e95b8a087b5789dbdee
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu May 02 09:47:57 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/bfd3237ac9df5b0e57b27e95b8a087b5789dbdee [^]

Related with bug 40349: fin_finacc_paymentmethod must have org-based clause too

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0111507)
mtaal   
2019-05-06 16:40   
reviewed and tested