Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018671 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2011-10-03 10:38 | 2011-10-19 14:05 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 08d4bd8c6852 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP4 | |||
| OS | Linux 32 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Core | |||||||
| Support ticket | 12796 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018671: you can not add transaction in financial account with multicurrency (only in ORACLE) | |||||||
| Description | In 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0041592) hgbot (developer) 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 (viewer) 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 (viewer) 2011-10-13 10:03 |
verified |
|
(0041884) hgbot (developer) 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 (administrator) 2011-10-19 14:05 |
re-closing, as last checkin message not real, just triggered by a code-line merge. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-10-03 10:38 | malsasua | New Issue | |
| 2011-10-03 10:38 | malsasua | Assigned To | => jonalegriaesarte |
| 2011-10-03 10:38 | malsasua | Web browser | => Google Chrome |
| 2011-10-03 10:38 | malsasua | Modules | => Core |
| 2011-10-03 10:38 | malsasua | OBNetwork customer | => Yes |
| 2011-10-03 10:38 | malsasua | Support ticket | => 12796 |
| 2011-10-03 10:38 | malsasua | Resolution time | => 1320361200 |
| 2011-10-04 18:01 | eduardo_Argal | Status | new => scheduled |
| 2011-10-04 18:01 | eduardo_Argal | Assigned To | jonalegriaesarte => eduardo_Argal |
| 2011-10-04 18:01 | eduardo_Argal | fix_in_branch | => pi |
| 2011-10-07 12:09 | shuehner | Web browser | Google Chrome => Google Chrome |
| 2011-10-07 12:09 | shuehner | Priority | urgent => immediate |
| 2011-10-07 12:09 | shuehner | Target Version | => 3.0MP4 |
| 2011-10-07 12:09 | shuehner | fix_in_branch | pi => |
| 2011-10-11 17:10 | hgbot | Checkin | |
| 2011-10-11 17:10 | hgbot | Note Added: 0041592 | |
| 2011-10-11 17:10 | hgbot | Status | scheduled => resolved |
| 2011-10-11 17:10 | hgbot | Resolution | open => fixed |
| 2011-10-11 17:10 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/25b229f91bc63dbe090f51a920e68323ffb63e0c [^] |
| 2011-10-12 02:02 | hudsonbot | Checkin | |
| 2011-10-12 02:02 | hudsonbot | Note Added: 0041768 | |
| 2011-10-13 10:03 | malsasua | Note Added: 0041784 | |
| 2011-10-13 10:03 | malsasua | Status | resolved => closed |
| 2011-10-13 10:03 | malsasua | Fixed in Version | => 3.0MP4 |
| 2011-10-18 17:25 | hgbot | Checkin | |
| 2011-10-18 17:25 | hgbot | Note Added: 0041884 | |
| 2011-10-18 17:25 | hgbot | Status | closed => resolved |
| 2011-10-18 17:25 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/25b229f91bc63dbe090f51a920e68323ffb63e0c [^] => http://code.openbravo.com/erp/devel/pi/rev/08d4bd8c6852134c8323029673d7639b39206bce [^] |
| 2011-10-19 14:05 | shuehner | Note Added: 0041932 | |
| 2011-10-19 14:05 | shuehner | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |