Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018671Openbravo ERP09. Financial managementpublic2011-10-03 10:382011-10-19 14:05
Reportermalsasua 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version 
Target Version3.0MP4Fixed in Version3.0MP4 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket12796
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018671: you can not add transaction in financial account with multicurrency (only in ORACLE)
DescriptionIn oracle database enviroment, with multicurrency, if you try add a transaction in financial account, error is returned
Steps To Reproduce. create and process a new sales invoice in USD
 . org: F&B España
 . payment method: wire transfer
 . bp: alimentos y supermercados S.A.

. in financial account in USD and org F&B España
 . payment mehtod wire transfer
  . payment in
   . execution type: manual
   . receive in other currency: selected
   . Upon deposit use: cleared...
   . automatic payment, automatic withdrawn, upon reconciliate use: void

 . add transaction:
  . document "received in"
  . add payment in/out
   . currency USD
   . received from "Alimentos y Supermercados S.A"
   . select the initial invoice and process
    . process received payments and deposit: selected
Error
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-03 10:38malsasuaNew Issue
2011-10-03 10:38malsasuaAssigned To => jonalegriaesarte
2011-10-03 10:38malsasuaWeb browser => Google Chrome
2011-10-03 10:38malsasuaModules => Core
2011-10-03 10:38malsasuaOBNetwork customer => Yes
2011-10-03 10:38malsasuaSupport ticket => 12796
2011-10-03 10:38malsasuaResolution time => 1320361200
2011-10-04 18:01eduardo_ArgalStatusnew => scheduled
2011-10-04 18:01eduardo_ArgalAssigned Tojonalegriaesarte => eduardo_Argal
2011-10-04 18:01eduardo_Argalfix_in_branch => pi
2011-10-07 12:09shuehnerWeb browserGoogle Chrome => Google Chrome
2011-10-07 12:09shuehnerPriorityurgent => immediate
2011-10-07 12:09shuehnerTarget Version => 3.0MP4
2011-10-07 12:09shuehnerfix_in_branchpi =>
2011-10-11 17:10hgbotCheckin
2011-10-11 17:10hgbotNote Added: 0041592
2011-10-11 17:10hgbotStatusscheduled => resolved
2011-10-11 17:10hgbotResolutionopen => fixed
2011-10-11 17:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/25b229f91bc63dbe090f51a920e68323ffb63e0c [^]
2011-10-12 02:02hudsonbotCheckin
2011-10-12 02:02hudsonbotNote Added: 0041768
2011-10-13 10:03malsasuaNote Added: 0041784
2011-10-13 10:03malsasuaStatusresolved => closed
2011-10-13 10:03malsasuaFixed in Version => 3.0MP4
2011-10-18 17:25hgbotCheckin
2011-10-18 17:25hgbotNote Added: 0041884
2011-10-18 17:25hgbotStatusclosed => resolved
2011-10-18 17:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/25b229f91bc63dbe090f51a920e68323ffb63e0c [^] => http://code.openbravo.com/erp/devel/pi/rev/08d4bd8c6852134c8323029673d7639b39206bce [^]
2011-10-19 14:05shuehnerNote Added: 0041932
2011-10-19 14:05shuehnerStatusresolved => closed

Notes
(0041592)
hgbot   
2011-10-11 17:10   
Repository: erp/devel/pi
Changeset: 25b229f91bc63dbe090f51a920e68323ffb63e0c
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Oct 04 18:02:36 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/25b229f91bc63dbe090f51a920e68323ffb63e0c [^]

Fixes bug 18671: you can not add transaction

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/dao/TransactionsDao.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ExecutePayment.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_TransactionProcess.java
R src-db/database/model/triggers/FIN_FINACC_TRANSACTION_TRG.xml
R src-db/database/model/triggers/FIN_PAYMENT_TRG.xml
---
(0041768)
hudsonbot   
2011-10-12 02:02   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9bd2b5c2d982 [^]

Maturity status: Test
(0041784)
malsasua   
2011-10-13 10:03   
verified
(0041884)
hgbot   
2011-10-18 17:25   
Repository: erp/devel/pi
Changeset: 08d4bd8c6852134c8323029673d7639b39206bce
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Oct 04 18:02:36 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/08d4bd8c6852134c8323029673d7639b39206bce [^]

Fixes bug 18671: you can not add transaction

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/dao/TransactionsDao.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ExecutePayment.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_TransactionProcess.java
R src-db/database/model/triggers/FIN_FINACC_TRANSACTION_TRG.xml
R src-db/database/model/triggers/FIN_PAYMENT_TRG.xml
---
(0041932)
shuehner   
2011-10-19 14:05   
re-closing, as last checkin message not real, just triggered by a code-line merge.