Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041712
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2019-08-28 13:332019-09-04 11:08
ReporterSandrahuguetView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q3.1
StatusclosedFix in branchFixed in SCM revision97b1ce519519
ProjectionnoneETAnoneTarget Version3.0PR19Q3.1
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041712: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0041711 closedcollazoandy4 Subquery in getDocumentNo in ReportGeneralLedgerJournal is not using bind-params 

-  Notes
(0114393)
hgbot (developer)
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 (developer)
2019-09-04 11:08

code review + testing ok

- Issue History
Date Modified Username Field Change
2019-08-28 13:40 Sandrahuguet Type defect => backport
2019-08-28 13:40 Sandrahuguet Target Version => 3.0PR19Q3.1
2019-09-04 11:07 hgbot Checkin
2019-09-04 11:07 hgbot Note Added: 0114393
2019-09-04 11:07 hgbot Status scheduled => resolved
2019-09-04 11:07 hgbot Resolution open => fixed
2019-09-04 11:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q3.1/rev/97b1ce519519cbde82efebeb18659cb2cd60d370 [^]
2019-09-04 11:08 Sandrahuguet Review Assigned To => Sandrahuguet
2019-09-04 11:08 Sandrahuguet Note Added: 0114395
2019-09-04 11:08 Sandrahuguet Status resolved => closed
2019-09-04 11:08 Sandrahuguet Fixed in Version => 3.0PR19Q3.1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker