Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041712Openbravo ERP09. Financial managementpublic2019-08-28 13:332019-09-04 11:08
ReporterSandrahuguet 
Assigned ToTriage Omni OMS 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target Version3.0PR19Q3.1Fixed in Version3.0PR19Q3.1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041712: Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params
DescriptionSubquery 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 + "' )";
Steps To ReproduceTest 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0041711 closed collazoandy4 Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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