Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029900Openbravo ERP09. Financial managementpublic2015-05-15 10:452015-05-15 15:14
Reportermalsasua 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target Version3.0PR15Q1.4Fixed in Version3.0PR15Q1.4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029900: 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.0PR15Q1.4
2015-05-15 13:21dmitry_mezentsevTag Attached: Approved
2015-05-15 15:13hgbotCheckin
2015-05-15 15:13hgbotNote Added: 0077499
2015-05-15 15:13hgbotStatusscheduled => resolved
2015-05-15 15:13hgbotResolutionopen => fixed
2015-05-15 15:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/6cbc78180ba8156d31839e54756d08e709013fb8 [^]
2015-05-15 15:14aferrazReview Assigned To => aferraz
2015-05-15 15:14aferrazNote Added: 0077502
2015-05-15 15:14aferrazStatusresolved => closed
2015-05-15 15:14aferrazFixed in Version => 3.0PR15Q1.4

Notes
(0077499)
hgbot   
2015-05-15 15:13   
Repository: erp/backports/3.0PR15Q1.4
Changeset: 6cbc78180ba8156d31839e54756d08e709013fb8
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.0PR15Q1.4/rev/6cbc78180ba8156d31839e54756d08e709013fb8 [^]

Fixes issue 29900: 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
---
(0077502)
aferraz   
2015-05-15 15:14   
Code review + Testing OK