Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029899Openbravo ERP09. Financial managementpublic2015-05-15 10:452015-05-15 15:13
malsasua 
eduardo_Argal 
immediatemajoralways
closedfixed 
20Community Appliance
 
3.0PR15Q2.13.0PR15Q2.1 
aferraz
Core
No
0029899: False positives in GLJournalAccountingCheck validation
When exist records in the fact_acct with the same record_id, and line_id, but distinct ad_table_id (it occurs in old records when the key of tables were numerics, not uuids), this build validation is failing
create records in the fact_acct with the same record_id and line_id, but distinct amounts
in the query, one filter by ad_table_id should be added.
Approved
blocks defect 0029897 closed eduardo_Argal False positives in GLJournalAccountingCheck validation 
Issue History
2015-05-15 11:59aferrazTypedefect => backport
2015-05-15 11:59aferrazTarget Version => 3.0PR15Q2.1
2015-05-15 13:19dmitry_mezentsevTag Attached: Approved
2015-05-15 15:12hgbotCheckin
2015-05-15 15:12hgbotNote Added: 0077498
2015-05-15 15:12hgbotStatusscheduled => resolved
2015-05-15 15:12hgbotResolutionopen => fixed
2015-05-15 15:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/a2dd91b010a95d33dc81128afd325a27ab6438b9 [^]
2015-05-15 15:13aferrazReview Assigned To => aferraz
2015-05-15 15:13aferrazNote Added: 0077501
2015-05-15 15:13aferrazStatusresolved => closed
2015-05-15 15:13aferrazFixed in Version => 3.0PR15Q2.1

Notes
(0077498)
hgbot   
2015-05-15 15:12   
Repository: erp/backports/3.0PR15Q2.1
Changeset: a2dd91b010a95d33dc81128afd325a27ab6438b9
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri May 15 12:01:31 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/a2dd91b010a95d33dc81128afd325a27ab6438b9 [^]

Fixes issue 29899: False positives in GLJournalAccountingCheck validation
Missing ad_table_id constraint ends up in wrong validation when there are old records using numeric values for ids.

---
M src-util/buildvalidation/src/org/openbravo/buildvalidation/GLJournalAccountingCheck_data.xsql
---
(0077501)
aferraz   
2015-05-15 15:13   
Code review + Testing OK