Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029900 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2015-05-15 10:45 | 2015-05-15 15:14 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR15Q1.4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 6cbc78180ba8 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q1.4 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | aferraz | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029900: False positives in GLJournalAccountingCheck validation | |||||||
| Description | 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 | |||||||
| Steps To Reproduce | create records in the fact_acct with the same record_id and line_id, but distinct amounts | |||||||
| Proposed Solution | in the query, one filter by ad_table_id should be added. | |||||||
| Tags | Approved | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0077499) hgbot (developer) 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 (manager) 2015-05-15 15:14 |
Code review + Testing OK |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-05-15 11:59 | aferraz | Type | defect => backport |
| 2015-05-15 11:59 | aferraz | Target Version | => 3.0PR15Q1.4 |
| 2015-05-15 13:21 | dmitry_mezentsev | Tag Attached: Approved | |
| 2015-05-15 15:13 | hgbot | Checkin | |
| 2015-05-15 15:13 | hgbot | Note Added: 0077499 | |
| 2015-05-15 15:13 | hgbot | Status | scheduled => resolved |
| 2015-05-15 15:13 | hgbot | Resolution | open => fixed |
| 2015-05-15 15:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/6cbc78180ba8156d31839e54756d08e709013fb8 [^] |
| 2015-05-15 15:14 | aferraz | Review Assigned To | => aferraz |
| 2015-05-15 15:14 | aferraz | Note Added: 0077502 | |
| 2015-05-15 15:14 | aferraz | Status | resolved => closed |
| 2015-05-15 15:14 | aferraz | Fixed in Version | => 3.0PR15Q1.4 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |