Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029899Openbravo ERP09. Financial managementpublic2015-05-15 10:452015-05-15 15:13
Reportermalsasua 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target Version3.0PR15Q2.1Fixed in Version3.0PR15Q2.1 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029899: False positives in GLJournalAccountingCheck validation
DescriptionWhen 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
Steps To Reproducecreate records in the fact_acct with the same record_id and line_id, but distinct amounts
Proposed Solutionin the query, one filter by ad_table_id should be added.
Additional Information
TagsApproved
Relationships
blocks defect 0029897 closed eduardo_Argal False positives in GLJournalAccountingCheck validation 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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