Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016184Openbravo ERP09. Financial managementpublic2011-03-09 15:072011-05-24 10:55
Reporterdalsasua 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.10
Product Version2.50MP27 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016184: Balance Sheet and P&L Report can't include titles
DescriptionIn case the Balance Sheet and Profit and Loose structure needs to display a node without amount, as a title, it's not possible.
Steps To Reproduce
Proposed SolutionInclude a flag "Title" in the account tree-> element value tab. In case a node has this flag active, will always be shown in the report, and with no amount.
Additional Information
TagsclosingMay2011
Relationships
depends on backport 0016349 closed dalsasua Balance Sheet and P&L Report can't include titles 
Attached Filesdiff fix16184.diff (13,000) 2011-03-17 11:04
https://issues.openbravo.com/file_download.php?file_id=3706&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-03-09 15:07dalsasuaNew Issue
2011-03-09 15:07dalsasuaAssigned To => dalsasua
2011-03-09 15:07dalsasuaModules => Core
2011-03-09 15:07dalsasuaOBNetwork customer => Yes
2011-03-09 15:08dalsasuaIssue Monitored: networkb
2011-03-17 11:01dalsasuaStatusnew => scheduled
2011-03-17 11:01dalsasuafix_in_branch => pi
2011-03-17 11:04dalsasuaFile Added: fix16184.diff
2011-03-17 11:04dalsasuaNote Added: 0034981
2011-03-18 12:45dalsasuaNote Added: 0035037
2011-03-21 11:03hgbotCheckin
2011-03-21 11:03hgbotNote Added: 0035078
2011-03-21 11:03hgbotStatusscheduled => resolved
2011-03-21 11:03hgbotResolutionopen => fixed
2011-03-21 11:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/43f9be3e6e8718f1dd0c55ac1a8835718f735ff3 [^]
2011-03-24 07:36hgbotCheckin
2011-03-24 07:36hgbotNote Added: 0035187
2011-03-24 07:36hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/43f9be3e6e8718f1dd0c55ac1a8835718f735ff3 [^] => http://code.openbravo.com/erp/devel/pi/rev/40ecade4a006fa6bad33a5484a846ad94ea0bc5e [^]
2011-05-24 10:48dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed

Notes
(0034981)
dalsasua   
2011-03-17 11:04   
Uploaded patch with fix. Pi is logically frozen.
(0035037)
dalsasua   
2011-03-18 12:45   
In order to test:

1.- Configure a P&L structure report as described in http://wiki.openbravo.com/wiki/Balance_sheet_and_PL_structure#Balance_de_situaci.C3.B3n [^]
2.- Launch it once with the "Show only accounts with value" flag active, and other with de-activated
3.- Choose two nodes (one that gives 0 in the report, and other that not), locate then in Account Tree window, and activate the "Title" flag
4.- Run again the reports of point 2.
5.- Check that both reports throw same amounts, but title type node is shown always, and shows no amount.
(0035078)
hgbot   
2011-03-21 11:03   
Repository: erp/devel/pi
Changeset: 43f9be3e6e8718f1dd0c55ac1a8835718f735ff3
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Mar 17 11:02:46 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/43f9be3e6e8718f1dd0c55ac1a8835718f735ff3 [^]

Fixes issue 16184.
Now a new flag Title Node is available in element -> value tab. If flagged, the node is always shown in the b.s.&p.l. reports, with no amount, just as a title node

---
M src-db/database/model/tables/C_ELEMENTVALUE.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReportsPDF.fo
M src/org/openbravo/erpCommon/businessUtility/AccountTree.java
M src/org/openbravo/erpCommon/businessUtility/AccountTree_data.xsql
---
(0035187)
hgbot   
2011-03-24 07:36   
Repository: erp/devel/pi
Changeset: 40ecade4a006fa6bad33a5484a846ad94ea0bc5e
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Mar 23 08:22:42 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/40ecade4a006fa6bad33a5484a846ad94ea0bc5e [^]

Fixes issue 16184.
Column should be mandatory

---
M src-db/database/model/tables/C_ELEMENTVALUE.xml
---