Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040349
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] StoreServerminorhave not tried2019-03-11 12:532019-05-06 16:40
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9c83c6e8f737
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040349: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0111302)
hgbot (developer)
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 (developer)
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 (manager)
2019-05-06 16:40

reviewed and tested

- Issue History
Date Modified Username Field Change
2019-03-11 12:53 AugustoMauch New Issue
2019-03-11 12:53 AugustoMauch Assigned To => AugustoMauch
2019-03-11 12:53 AugustoMauch Triggers an Emergency Pack => No
2019-04-25 10:29 hgbot Checkin
2019-04-25 10:29 hgbot Note Added: 0111302
2019-04-25 10:29 hgbot Status new => resolved
2019-04-25 10:29 hgbot Resolution open => fixed
2019-04-25 10:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/9c83c6e8f73716614b5e591de2ab015c9395ebc8 [^]
2019-04-25 10:29 AugustoMauch Review Assigned To => mtaal
2019-05-02 09:48 hgbot Checkin
2019-05-02 09:48 hgbot Note Added: 0111421
2019-05-06 16:40 mtaal Note Added: 0111507
2019-05-06 16:40 mtaal Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker