Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011297Openbravo ERP09. Financial managementpublic2009-11-09 13:162009-11-13 11:46
Reporternetworkb 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target Version2.40MP11Fixed in Version2.40MP11 
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
Summary0011297: General Ledger group information for BP with same name
DescriptionIf two (or more) BP have the same name, in General Ledger Report, their information is grouped and it should be displayed in diferent sections.

It has been tested in MP10
Steps To ReproduceGo to Financial Management > Accounting > Analysis Tools > General Ledger Report.
Enter From Date: 01-01-2000. To Date: 01-01-2009. Select an Accounting Schema.
Some entries will appear.
Have a look and revise two BP that appears.
For those BP, change their names to "xx" in Master Data Management > Business Partner.
Go back to General Ledger Report.
Enter same filter.
All information is grouped and belongs to diferent partners.
Proposed SolutionIn ReportGeneralLedger_data.xsql should group by c_bpartner_id instead of name.

    <Parameter name="orden2" type="replace" optional="true" after="ORDER BY " text="C_BPARTNER.NAME, FACT_ACCT.C_BPARTNER_ID, "/>
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00112802.40MP11 closed vmromanos General Ledger group information for BP with same name 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-10 08:09rafarodaTypedefect => backport
2009-11-10 08:09rafarodafix_in_branch => 2.40
2009-11-12 19:11hgbotCheckin
2009-11-12 19:11hgbotNote Added: 0021791
2009-11-12 19:11hgbotStatusscheduled => resolved
2009-11-12 19:11hgbotResolutionopen => fixed
2009-11-12 19:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/ba462ee25ed3ab5713b5831cfee1ab2e1fe5c51c [^]
2009-11-13 11:46arunkumarNote Added: 0021805
2009-11-13 11:46arunkumarStatusresolved => closed
2009-11-13 11:46arunkumarFixed in Version => 2.40MP11

Notes
(0021791)
hgbot   
2009-11-12 19:11   
Repository: erp/stable/2.40
Changeset: ba462ee25ed3ab5713b5831cfee1ab2e1fe5c51c
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Nov 12 19:11:08 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/ba462ee25ed3ab5713b5831cfee1ab2e1fe5c51c [^]

Fixed bug 11297: General Ledger group information for BP with same name

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0021805)
arunkumar   
2009-11-13 11:46   
Tested & Working fine