Openbravo Issue Tracking System - Java Client POS
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014540Java Client POS(No Category)public2010-09-14 13:092014-04-02 09:03
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.30.1 
Target Version2.40Fixed in Version 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
OBNetwork customer
Support ticket
Regression introduced in release
Summary0014540: Synchronization transformations do not work in Derby
DescriptionThe synchronization transformation Inventory.ktr does not work in Derby because Derby does not implement the function ROUND used in the Inventory.ktr transformation
Steps To ReproduceJust try to synchronize the inventory between Openbravo ERP and Openbravo POS using Derby as database engine in Openbravo POS.
Proposed SolutionReplace the ROUND function by a math expression that can be executed by all supported Openbravo POS database engines
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-14 13:09adrianromeroNew Issue
2010-09-14 13:09adrianromeroAssigned To => adrianromero
2010-09-14 13:11hgbotCheckin
2010-09-14 13:11hgbotNote Added: 0031033
2010-09-14 13:11hgbotStatusnew => resolved
2010-09-14 13:11hgbotResolutionopen => fixed
2010-09-14 13:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]
2010-09-14 13:12adrianromeroNote Added: 0031034
2010-09-23 13:11hgbotCheckin
2010-09-23 13:11hgbotNote Added: 0031321
2010-09-23 13:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]
2011-06-03 10:59dalsasuaAssigned Toadrianromero => dalsasua
2011-06-03 12:22dalsasuaAssigned Todalsasua => adrianromero
2012-11-07 09:40priyamCategory02 - ERP-POS Integration => (No Category)
2014-04-02 09:03plujanNote Added: 0065969
2014-04-02 09:03plujanStatusresolved => closed

Notes
(0031033)
hgbot   
2010-09-14 13:11   
Repository: erp/mods/org.openbravo.pos.sync.trans
Changeset: 6f12c0e284207916c3ffa1ca9eee2cb5464f3f61
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Sep 14 13:10:59 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]

Fixes issue 0014540: Synchronization transformations do not work in Derby
It has been replaced the ROUND function by the expression FLOOR(? * 100 + 0.5)/ 100

---
M transformations/Inventory.ktr
---
(0031034)
adrianromero   
2010-09-14 13:12   
* Testing of the issue

Test the synchronization using Derby. All other supported database engines must be tested too.

* Other areas affected.

Only the synchronization is affected.
(0031321)
hgbot   
2010-09-23 13:11   
Repository: erp/pmods/org.openbravo.pos.sync.trans
Changeset: 6f12c0e284207916c3ffa1ca9eee2cb5464f3f61
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Sep 14 13:10:59 2010 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]

Fixes issue 0014540: Synchronization transformations do not work in Derby
It has been replaced the ROUND function by the expression FLOOR(? * 100 + 0.5)/ 100

---
M transformations/Inventory.ktr
---
(0065969)
plujan   
2014-04-02 09:03   
Closed as it was in Resolved for too long