Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009935Openbravo ERP09. Financial managementpublic2009-07-16 18:282009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009935: Several reports depend GeneralAccountingReports_data.xsql which makes customizations harder
DescriptionThese reports just need one method selectCombo of the GeneralAccountingReports file. This method returns the list of organizations accessible by the user. This usage can be replaced easily by using the standard ComboTableData class.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP3releasecandidate, leo
Relationships
related to defect 0009932 closed shuehner Several reports depend ReportTrialBalance_data.xsql which makes customizations harder 
related to defect 0009937 closed shuehner Several reports depend on the ReportGeneralLedger_data.xsql file which makes customizing these harder 
related to defect 0010001 closed harikrishnan Report should/must use ComboTableData with #AccessibleOrgTree for Organization dropdown 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-16 18:28shuehnerNew Issue
2009-07-16 18:28shuehnerAssigned To => shuehner
2009-07-16 18:28shuehnerRelationship addedrelated to 0009932
2009-07-16 18:31hgbotCheckin
2009-07-16 18:31hgbotNote Added: 0018335
2009-07-16 18:31hgbotStatusnew => resolved
2009-07-16 18:31hgbotResolutionopen => fixed
2009-07-16 18:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/83ba2ffb1bfde86d9ce073c423d063941c098639 [^]
2009-07-16 18:58shuehnerRelationship addedrelated to 0009937
2009-07-16 19:34shuehnerNote Added: 0018338
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 19:17plujanStatusresolved => closed
2009-07-22 19:59shuehnerRelationship addedrelated to 0010001
2009-07-23 00:00anonymoussf_bug_id0 => 2825620

Notes
(0018335)
hgbot   
2009-07-16 18:31   
Repository: erp/devel/pi
Changeset: 83ba2ffb1bfde86d9ce073c423d063941c098639
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jul 16 18:31:33 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/83ba2ffb1bfde86d9ce073c423d063941c098639 [^]

Fixed 9935: Remove dependency on GeneralAccountingReport_data.xsql from several reports to make customizing these easier
- replace usage of xsql method selectCombo by standard use of ComboTableData to retrieve list of organizations for displaying a dropdown for selecting an org

---
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
---
(0018338)
shuehner   
2009-07-16 19:34   
@qa:

Please test the organization dropdown functionality (shows correct values for orgs, depending on access, and the filter by the selected access in the report execution) for the following reports:

- ReportAgingBalance
- ReportGeneralLedger
- ReportTrialBalance
- ReportGeneralLedgerJournal
- Depreciation Schedule (Assets)