Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041245Openbravo ERP09. Financial managementpublic2019-07-02 16:282019-08-25 06:50
normalminorhave not tried
0041245: DocFINReconciliation.createFact is not using bind-params
Several HQL in this method are not using bind-params.

When fixing please apply new HQL-style to all HQL in this file.
No tags attached.
related to defect 0041436 closed collazoandy4 Apply HQL style guide to DocFINReconciliation 
blocks design defect 0038136 acknowledged platform Tracking issue: Find & Fix queries not using bind-params but embedding values into query string 
Issue History
2019-07-02 16:28shuehnerNew Issue
2019-07-02 16:28shuehnerAssigned To => Triage Finance
2019-07-02 16:28shuehnerModules => Core
2019-07-02 16:28shuehnerTriggers an Emergency Pack => No
2019-07-02 16:28shuehnerRelationship addedblocks 0038136
2019-07-04 12:16shuehnerTarget Version => 3.0PR19Q4
2019-07-23 16:17collazoandy4Statusnew => scheduled
2019-07-23 16:17collazoandy4Assigned ToTriage Finance => collazoandy4
2019-07-24 19:41collazoandy4Note Added: 0113631
2019-08-22 14:13SandrahuguetRelationship addedrelated to 0041436
2019-08-22 14:29hgbotCheckin
2019-08-22 14:29hgbotNote Added: 0114127
2019-08-22 14:29hgbotStatusscheduled => resolved
2019-08-22 14:29hgbotResolutionopen => fixed
2019-08-22 14:29hgbotFixed in SCM revision => [^]
2019-08-22 14:29SandrahuguetReview Assigned To => Sandrahuguet
2019-08-22 14:29SandrahuguetNote Added: 0114128
2019-08-22 14:29SandrahuguetStatusresolved => closed
2019-08-22 14:29SandrahuguetFixed in Version => 3.0PR19Q4
2019-08-25 06:50hudsonbotCheckin
2019-08-25 06:50hudsonbotNote Added: 0114260

2019-07-24 19:41   
Test Plan
  Go to Financial Account and select Caja record
    In Account Configuration tab fill out the Cleared Payment Account field for both General Ledger records
  Create a new Sales Invoice for Alimentos y Supermercados, S.A BP, Total amount: 100, Payment Method: Al contado
    Complete and Pay the invoice
  Create a new Purchase for Bebidas Alegres, S.L. BP, Total amount: 100, Payment Method: Al contado
    Complete and Pay the invoice
  Go to Financial Account and select Caja record
    Create a new reconciliation for the previous transactions created by the invoice
    Post the reconciliation and check the process ends without error
2019-08-22 14:29   
Repository: erp/devel/pi
Changeset: 63a0a24cf4ba1907b12b00765422c4b5c4a4b4fc
Author: Armaignac <collazoandy4 <at>>
Date: Wed Jul 24 11:34:27 2019 -0400
URL: [^]

Fixed issue 41245: DocFINReconciliation.createFact is not using bind-params

Added missing bind-params

M src/org/openbravo/erpCommon/ad_forms/
2019-08-22 14:29   
code review + testing ok
2019-08-25 06:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test