Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020321
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo datamajoralways2012-04-20 11:472012-04-28 02:31
Reportereduardo_ArgalView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisione0ef24f40f60
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0020321: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0011411 closeddmiguelez FacAcctType column of Fact_Acct table does not have a correct reference 
related to defect 0020320 closeddmiguelez Regularization entries are set to factaccttype = 'N' but it should be 'R' 
related to defect 0020355 closeddmiguelez Wrong demo data in accounting tree 

-  Notes
(0048107)
hgbot (developer)
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 (viewer)
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 (viewer)
2012-04-27 09:12

 database validations are OK
(0048167)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2012-04-20 11:47 eduardo_Argal New Issue
2012-04-20 11:47 eduardo_Argal Assigned To => vmromanos
2012-04-20 11:47 eduardo_Argal Modules => Core
2012-04-20 11:47 eduardo_Argal OBNetwork customer => No
2012-04-20 11:48 eduardo_Argal Relationship added depends on 0011411
2012-04-20 13:41 vmromanos Relationship added related to 0020320
2012-04-26 09:37 dmiguelez Assigned To vmromanos => dmiguelez
2012-04-26 09:38 dmiguelez Status new => scheduled
2012-04-26 09:38 dmiguelez fix_in_branch => pi
2012-04-26 11:18 dmiguelez Relationship added related to 0020355
2012-04-26 20:28 hgbot Checkin
2012-04-26 20:28 hgbot Note Added: 0048107
2012-04-26 20:28 hgbot Status scheduled => resolved
2012-04-26 20:28 hgbot Resolution open => fixed
2012-04-26 20:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0ef24f40f600c07ece09da19334acb15a46c4dc [^]
2012-04-27 09:08 mirurita Note Added: 0048118
2012-04-27 09:12 mirurita Note Added: 0048120
2012-04-27 09:12 mirurita Status resolved => closed
2012-04-28 02:31 hudsonbot Checkin
2012-04-28 02:31 hudsonbot Note Added: 0048167

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker