Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020320Openbravo ERPJ. Demo datapublic2012-04-20 11:122012-04-28 02:31
Reportervmromanos 
Assigned Todmiguelez 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian 5.0
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
Summary0020320: Regularization entries are set to factaccttype = 'N' but it should be 'R'
DescriptionIn F&B client, the regularization entries are set to factaccttype = 'N' but it should be 'R'.
Steps To Reproduce1. Go to Balance sheet and P&L structure report
2. Select the following filters
Acct. schema: F&B International
Acct. report: Profit and Loss
Org: F&B US inc
Account level: heading
Year:2012
Reference Year:2011

Rest of fields: empty

Note 2011 amounts are 0 because the closing entries are wrong
Proposed SolutionEither undo close year for 2011 and close it again, or set factaccttype='R' for the selected entries.
Export sampledata again
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020321 closed dmiguelez Wrong demo data info for closing entries 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-20 11:12vmromanosNew Issue
2012-04-20 11:12vmromanosAssigned To => vmromanos
2012-04-20 11:12vmromanosModules => Core
2012-04-20 11:12vmromanosOBNetwork customer => No
2012-04-20 11:12vmromanosAssigned Tovmromanos => mirurita
2012-04-20 13:41vmromanosRelationship addedrelated to 0020321
2012-04-26 09:38dmiguelezAssigned Tomirurita => dmiguelez
2012-04-26 09:38dmiguelezStatusnew => scheduled
2012-04-26 09:38dmiguelezfix_in_branch => pi
2012-04-26 20:28hgbotCheckin
2012-04-26 20:28hgbotNote Added: 0048106
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: 0048117
2012-04-27 09:12miruritaNote Added: 0048119
2012-04-27 09:12miruritaStatusresolved => closed
2012-04-28 02:31hudsonbotCheckin
2012-04-28 02:31hudsonbotNote Added: 0048166

Notes
(0048106)
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
---
(0048117)
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');
(0048119)
mirurita   
2012-04-27 09:12   
database validations are OK
(0048166)
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