Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0040848 | Openbravo ERP | 09. Financial management | public | 2019-04-09 20:31 | 2019-05-23 17:29 | |||||||
| Reporter | shuehner | |||||||||||
| Assigned To | nonofrancisco | |||||||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | 3.0PR19Q2.1 | Fixed in Version | 3.0PR19Q2.1 | |||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | Sandrahuguet | |||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0040848: AcctServer.isConveritble is not using bind-parameters | |||||||||||
| Description | 4 cases in this methods are not using bind-parameters conversionQuery = OBDal.getInstance() .createQuery(ConversionRateDoc.class, "invoice = '" + Record_ID + "' and currency='" + currency + "' and toCurrency='" + acctSchema.m_C_Currency_ID + "'"); } else if (AD_Table_ID.equals(TABLEID_Payment)) { conversionQuery = OBDal.getInstance() .createQuery(ConversionRateDoc.class, "payment = '" + Record_ID + "' and currency='" + currency + "' and toCurrency='" + acctSchema.m_C_Currency_ID + "'"); } else if (AD_Table_ID.equals(TABLEID_Transaction)) { conversionQuery = OBDal.getInstance() .createQuery(ConversionRateDoc.class, "financialAccountTransaction = '" + Record_ID + "' and currency='" + currency + "' and toCurrency='" + acctSchema.m_C_Currency_ID + "'"); } else if (AD_Table_ID.equals(TABLEID_GLJournal)) { conversionQuery = OBDal.getInstance() .createQuery(ConversionRateDoc.class, "journalEntry = '" + Record_ID + "' and currency='" + currency + "' and toCurrency='" + acctSchema.m_C_Currency_ID + "'"); | |||||||||||
| Steps To Reproduce | - | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2019-05-12 16:01 | nonofrancisco | Type | defect => backport | |||||||||
| 2019-05-12 16:01 | nonofrancisco | Target Version | => 3.0PR19Q2 | |||||||||
| 2019-05-23 16:24 | Sandrahuguet | Target Version | 3.0PR19Q2 => 3.0PR19Q2.1 | |||||||||
| 2019-05-23 17:27 | hgbot | Checkin | ||||||||||
| 2019-05-23 17:27 | hgbot | Note Added: 0112100 | ||||||||||
| 2019-05-23 17:27 | hgbot | Status | scheduled => resolved | |||||||||
| 2019-05-23 17:27 | hgbot | Resolution | open => fixed | |||||||||
| 2019-05-23 17:27 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/f14dc55b25f0d4fe5d886ffefba6ce732796ab11 [^] | |||||||||
| 2019-05-23 17:29 | Sandrahuguet | Review Assigned To | => Sandrahuguet | |||||||||
| 2019-05-23 17:29 | Sandrahuguet | Note Added: 0112101 | ||||||||||
| 2019-05-23 17:29 | Sandrahuguet | Status | resolved => closed | |||||||||
| 2019-05-23 17:29 | Sandrahuguet | Fixed in Version | => 3.0PR19Q2.1 | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||