Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011280 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-11-09 13:16 | 2009-11-17 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP9 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | a7d586d61c5c | |||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP3 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011280: General Ledger group information for BP with same name | |||||||
| Description | If 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 Reproduce | Go 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 Solution | In 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, "/> | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0021655) networkb (viewer) 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 (developer) 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 (viewer) 2009-11-16 08:14 |
Tested, General Ledger working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-11-09 13:16 | networkb | New Issue | |
| 2009-11-09 13:16 | networkb | Assigned To | => rafaroda |
| 2009-11-09 13:16 | networkb | OBNetwork customer | => Yes |
| 2009-11-09 15:37 | networkb | Note Added: 0021655 | |
| 2009-11-10 08:09 | rafaroda | Assigned To | rafaroda => vmromanos |
| 2009-11-10 08:09 | rafaroda | Priority | immediate => urgent |
| 2009-11-10 08:09 | rafaroda | Status | new => scheduled |
| 2009-11-10 08:09 | rafaroda | fix_in_branch | => pi |
| 2009-11-12 19:38 | vmromanos | Relationship added | depends on 0011231 |
| 2009-11-13 11:16 | hgbot | Checkin | |
| 2009-11-13 11:16 | hgbot | Note Added: 0021801 | |
| 2009-11-13 11:16 | hgbot | Status | scheduled => resolved |
| 2009-11-13 11:16 | hgbot | Resolution | open => fixed |
| 2009-11-13 11:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a7d586d61c5c9063ae7b6ec02213d5ebcfcc98a4 [^] |
| 2009-11-16 08:14 | sureshbabu | Note Added: 0021830 | |
| 2009-11-16 08:14 | sureshbabu | Status | resolved => closed |
| 2009-11-16 08:14 | sureshbabu | Fixed in Version | => 2.50MP9 |
| 2009-11-17 00:00 | anonymous | sf_bug_id | 0 => 2898756 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |