Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029897Openbravo ERP09. Financial managementpublic2015-05-15 10:452015-07-10 10:40
Reportermalsasua 
Assigned Toeduardo_Argal 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version3.0PR15Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2015-03-26
Regression introduced in release3.0PR15Q1.2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/d21dd3116c92194f50a74e73d3023669da3938ef [^]
Triggers an Emergency PackNo
Summary0029897: 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
TagsNo tags attached.
Relationships
depends on backport 00298993.0PR15Q2.1 closed eduardo_Argal False positives in GLJournalAccountingCheck validation 
depends on backport 00299003.0PR15Q1.4 closed eduardo_Argal False positives in GLJournalAccountingCheck validation 
caused by defect 0029222 closed aferraz G/L Journal Accounting amounts are not setted correctly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-15 10:45malsasuaNew Issue
2015-05-15 10:45malsasuaAssigned To => Triage Finance
2015-05-15 10:45malsasuaModules => Core
2015-05-15 10:45malsasuaTriggers an Emergency Pack => No
2015-05-15 11:59aferrazAssigned ToTriage Finance => eduardo_Argal
2015-05-15 11:59aferrazStatusnew => scheduled
2015-05-15 12:04aferrazRegression level => Production - Confirmed Stable
2015-05-15 12:04aferrazRegression date => 2015-03-26
2015-05-15 12:04aferrazRegression introduced in release => 3.0PR15Q1.2
2015-05-15 12:04aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/d21dd3116c92194f50a74e73d3023669da3938ef [^]
2015-05-15 12:23aferrazRelationship addedcaused by 0029222
2015-05-15 15:10hgbotCheckin
2015-05-15 15:10hgbotNote Added: 0077497
2015-05-15 15:10hgbotStatusscheduled => resolved
2015-05-15 15:10hgbotResolutionopen => fixed
2015-05-15 15:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b57f80503cdcec10dc33b1cdea32cd707f2783f6 [^]
2015-05-15 15:13aferrazReview Assigned To => aferraz
2015-05-15 15:13aferrazNote Added: 0077500
2015-05-15 15:13aferrazStatusresolved => closed
2015-05-15 15:13aferrazFixed in Version => 3.0PR15Q3
2015-05-16 05:21hudsonbotCheckin
2015-05-16 05:21hudsonbotNote Added: 0077512
2015-07-10 10:40dmitry_mezentsevSeveritymajor => minor

Notes
(0077497)
hgbot   
2015-05-15 15:10   
Repository: erp/devel/pi
Changeset: b57f80503cdcec10dc33b1cdea32cd707f2783f6
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri May 15 12:01:31 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b57f80503cdcec10dc33b1cdea32cd707f2783f6 [^]

Fixes issue 29897: 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
---
(0077500)
aferraz   
2015-05-15 15:13   
Code review + Testing OK
(0077512)
hudsonbot   
2015-05-16 05:21   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/33b0ebaa36ae [^]
Maturity status: Test