Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020321Openbravo ERPJ. Demo datapublic2012-04-20 11:472012-04-28 02:31
Reportereduardo_Argal 
Assigned Todmiguelez 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020321: Wrong demo data info for closing entries
DescriptionDue to wrong data type definition in dictionary DAl wrongly exports info for FACTACCTTYPE column in FACT_ACCT table.
It is now being exported/imported always as value 'N'.
As the column has been defined as yes/no column, DAL esports it as 'N' because values in database are not equal to 'Y'.

This makes balances and PL not to exclude closing entries. Not excluding such entries makes figures for the end of the period to a 0 value.
Steps To ReproduceRun P&L for demo data filtering by 2012, reference year 2011

You will realize figures shows 0 value for the accounts in 2011 as income statement is included in the report output.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0011411 closed dmiguelez FacAcctType column of Fact_Acct table does not have a correct reference 
related to defect 0020320 closed dmiguelez Regularization entries are set to factaccttype = 'N' but it should be 'R' 
related to defect 0020355 closed dmiguelez Wrong demo data in accounting tree 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-20 11:47eduardo_ArgalNew Issue
2012-04-20 11:47eduardo_ArgalAssigned To => vmromanos
2012-04-20 11:47eduardo_ArgalModules => Core
2012-04-20 11:47eduardo_ArgalOBNetwork customer => No
2012-04-20 11:48eduardo_ArgalRelationship addeddepends on 0011411
2012-04-20 13:41vmromanosRelationship addedrelated to 0020320
2012-04-26 09:37dmiguelezAssigned Tovmromanos => dmiguelez
2012-04-26 09:38dmiguelezStatusnew => scheduled
2012-04-26 09:38dmiguelezfix_in_branch => pi
2012-04-26 11:18dmiguelezRelationship addedrelated to 0020355
2012-04-26 20:28hgbotCheckin
2012-04-26 20:28hgbotNote Added: 0048107
2012-04-26 20:28hgbotStatusscheduled => resolved
2012-04-26 20:28hgbotResolutionopen => fixed
2012-04-26 20:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0ef24f40f600c07ece09da19334acb15a46c4dc [^]
2012-04-27 09:08miruritaNote Added: 0048118
2012-04-27 09:12miruritaNote Added: 0048120
2012-04-27 09:12miruritaStatusresolved => closed
2012-04-28 02:31hudsonbotCheckin
2012-04-28 02:31hudsonbotNote Added: 0048167

Notes
(0048107)
hgbot   
2012-04-26 20:28   
Repository: erp/devel/pi
Changeset: e0ef24f40f600c07ece09da19334acb15a46c4dc
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Apr 26 20:05:27 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e0ef24f40f600c07ece09da19334acb15a46c4dc [^]

F&B sampledata: Fixes bug 20320, Fixes bug 20321, Fixes bug 20355, Fixes bug 20356.
Fixes int-full-pgsql 0003434

---
M referencedata/sampledata/F_B_International_Group.xml
---
(0048118)
mirurita   
2012-04-27 09:08   
Testing Plan
Check in database database

select * from ad_org_closing;
-- reg_fact_acct_group_id = 'R'
-- close_fact_acct_group_id = 'C'
-- divideup_fact_acct_group_id = 'C'
-- open_fact_acct_group_id = 'O'

-- R
select factaccttype from fact_acct where fact_acct_group_id in
('35C90971020D419DA04D6B136AEEEEE2', '4F6C839214964EF58AC2477FD690E511','6D0F3A0DD0424349983AE55C23C83B59');

-- C
select factaccttype from fact_acct where fact_acct_group_id in
('3CE7EDBB41F84C1798EA05924212082F', 'DB5BD4B74BE44804A966FD7931B5F791', '452384D63AC640E68CC4432E3C823297');

-- C
select factaccttype from fact_acct where fact_acct_group_id in
('A122F68975C54121AE581AF37B346C00', 'E05B9B1592C84DFE98731DA40BFF3BE3', 'CB3FC299C9BA404986ED6BD64110B33F');

-- O
select factaccttype from fact_acct where fact_acct_group_id in
('130811E0CC5C420A950F0620889AE095', 'E8408A9AE0514CAA92F71B6457E24E8B', '754FF1A8619743ACAE0D1AA8C7B384A6');
(0048120)
mirurita   
2012-04-27 09:12   
database validations are OK
(0048167)
hudsonbot   
2012-04-28 02:31   
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/cd923b317af4 [^]

Maturity status: Test