Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041712Openbravo ERP09. Financial managementpublic2019-08-28 13:332019-09-04 11:08
Sandrahuguet 
Triage Omni OMS 
normalmajoralways
closedfixed 
30Openbravo Appliance 14.04
 
3.0PR19Q3.13.0PR19Q3.1 
Sandrahuguet
Core
No
0041712: Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params
Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params

final String existsSubQuery = "( select 1 "
+ " from " + tablename + " dt "
+ " where f.record_id = dt." + tablename + "_id"
+ " and dt.documentno = '" + documentNo + "' )";
Test Plan
Go to Journal Entries Report and set:
    Organization: Region Norte
    General Ledger: F&B España
    From: 01-07-2018
    To: 24-07-2019
    From Account: (43000) Clientes (euros) a corto plazo
    To Account: (47700) Hacienda Pública IVA repercutido
    Document: AR Invoice
    DocumentNo: 1000259
No tags attached.
blocks defect 0041711 closed collazoandy4 Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params 
Issue History
2019-08-28 13:40SandrahuguetTypedefect => backport
2019-08-28 13:40SandrahuguetTarget Version => 3.0PR19Q3.1
2019-09-04 11:07hgbotCheckin
2019-09-04 11:07hgbotNote Added: 0114393
2019-09-04 11:07hgbotStatusscheduled => resolved
2019-09-04 11:07hgbotResolutionopen => fixed
2019-09-04 11:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q3.1/rev/97b1ce519519cbde82efebeb18659cb2cd60d370 [^]
2019-09-04 11:08SandrahuguetReview Assigned To => Sandrahuguet
2019-09-04 11:08SandrahuguetNote Added: 0114395
2019-09-04 11:08SandrahuguetStatusresolved => closed
2019-09-04 11:08SandrahuguetFixed in Version => 3.0PR19Q3.1

Notes
(0114393)
hgbot   
2019-09-04 11:07   
Repository: erp/backports/3.0PR19Q3.1
Changeset: 97b1ce519519cbde82efebeb18659cb2cd60d370
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Wed Sep 04 01:29:12 2019 -0400
URL: http://code.openbravo.com/erp/backports/3.0PR19Q3.1/rev/97b1ce519519cbde82efebeb18659cb2cd60d370 [^]

Fixes issue 41712: Subquery in getDocumentNo in ReportGeneralLedgerJournal is
not using bind-params

Added the missing bind-params
Now all documents id with the same documentNo is used to filter the accounting records

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
(0114395)
Sandrahuguet   
2019-09-04 11:08   
code review + testing ok