Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011280Openbravo ERP09. Financial managementpublic2009-11-09 13:162009-11-17 00:00
Reporternetworkb 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target Version2.40MP11Fixed in Version2.50MP9 
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
Summary0011280: 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
depends on backport 00112972.40MP11 closed vmromanos General Ledger group information for BP with same name 
depends on defect 00112312.50MP9 closed vmromanos Error shown when a BP is selected in General Ledger Report and try to print it in PDF or Excel 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-09 13:16networkbNew Issue
2009-11-09 13:16networkbAssigned To => rafaroda
2009-11-09 15:37networkbNote Added: 0021655
2009-11-10 08:09rafarodaAssigned Torafaroda => vmromanos
2009-11-10 08:09rafarodaPriorityimmediate => urgent
2009-11-10 08:09rafarodaStatusnew => scheduled
2009-11-10 08:09rafarodafix_in_branch => pi
2009-11-12 19:38vmromanosRelationship addeddepends on 0011231
2009-11-13 11:16hgbotCheckin
2009-11-13 11:16hgbotNote Added: 0021801
2009-11-13 11:16hgbotStatusscheduled => resolved
2009-11-13 11:16hgbotResolutionopen => fixed
2009-11-13 11:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a7d586d61c5c9063ae7b6ec02213d5ebcfcc98a4 [^]
2009-11-16 08:14sureshbabuNote Added: 0021830
2009-11-16 08:14sureshbabuStatusresolved => closed
2009-11-16 08:14sureshbabuFixed in Version => 2.50MP9
2009-11-17 00:00anonymoussf_bug_id0 => 2898756

Notes
(0021655)
networkb   
2009-11-09 15:37   
When the report is executed with only one of this partners with the same name, the total amount is correct, but if you run the report selecting the two partners with the same name the total amout is not correct, because
the sql executed groups by partner name.
(0021801)
hgbot   
2009-11-13 11:16   
Repository: erp/devel/pi
Changeset: a7d586d61c5c9063ae7b6ec02213d5ebcfcc98a4
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Nov 13 11:17:43 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a7d586d61c5c9063ae7b6ec02213d5ebcfcc98a4 [^]

Fixed bug 11280: 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
---
(0021830)
sureshbabu   
2009-11-16 08:14   
Tested, General Ledger working fine