Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012848Openbravo ERP09. Financial managementpublic2010-03-03 13:432010-04-13 15:21
networkb 
dalsasua 
urgentmajorhave not tried
closedfixed 
20Community Appliance
2.40MP12 
2.40 
OBPS
Core
No
0012848: trial balance report group by business partner name
In trial balance reports the results are grouped by business partner name.
The problem is when two partners have the same name
. Financial Management || Accounting || Analysis Tools || Trial Balance Report || Trial Balance Report
. from date: 01/01/2006
. to date: 31/12/2009
. Accounting schema: smallbazar
. Organization: *
. Account Level: subaccount
. Show selected level only: checked
. From Account: 40000
. To Account: 40000
. All: checked
. bussines partner: void
. results is:
   ....
   partner: McGiver Supplies
     account: 40000
     Initial: 0.00
     Debit: 0.00
     Credit: 345.22
     Final: 345.22

now, we change the name of bussines partner "Edison Energy" to "McGiver Supplies":
 Master Data Management || Business Partner || Business Partner
 change the name of partner "Edison Energy" to "McGiver Supplies"

now, execute again the report
. Financial Management || Accounting || Analysis Tools || Trial Balance Report || Trial Balance Report
. from date: 01/01/2006
. to date: 31/12/2009
. Accounting schema: smallbazar
. Organization: *
. Account Level: subaccount
. Show selected level only: checked
. From Account: 40000
. To Account: 40000
. All: checked
. bussines partner: void
. results is:
   ....
   partner: McGiver Supplies
     account: 40000
     Initial: 0.00
     Debit: 0.00
     Credit: -3.210,41
     Final: -3.210,41
No tags attached.
blocks defect 0012540 closed dalsasua trial balance report group by business partner name 
Issue History
2010-03-30 10:39dalsasuaTypedefect => backport
2010-03-30 10:39dalsasuafix_in_branch => 2.40
2010-03-30 11:00dalsasuaStatusscheduled => resolved
2010-03-30 11:00dalsasuaFixed in Version => 2.40
2010-03-30 11:00dalsasuaResolutionopen => fixed
2010-03-30 11:01dalsasuaNote Added: 0025801
2010-04-13 15:21psarobeNote Added: 0026144
2010-04-13 15:21psarobeStatusresolved => closed

Notes
(0025801)
dalsasua   
2010-03-30 11:01   
Repository: erp/stable/2.40
Changeset: c6723316bb34e943b373863fc96eee82e3c7dfcf
Author: Salvador Zapata <salvador.zapata <at> openbravo.com>
Date: Mon Mar 15 22:34:35 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/c6723316bb34e943b373863fc96eee82e3c7dfcf [^]

Fixed bug 12540:trial balance report group by business partner name

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0026144)
psarobe   
2010-04-13 15:21   
Tested seeing the solution. Fine