Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008162Openbravo ERP09. Financial managementpublic2009-03-17 17:122009-08-11 00:00
jaimetorre 
gmauleon 
urgentminoralways
closedfixed 
5
2.40MP1 
2.50MP2 
Core
No
0008162: Payment report does not allow to filter or group by bank account.
The payment report does not separate in any way the data of different bank accounts.
1) Go to Financial Management || Receivables & Payables || Analysis Tools || Payment Report
2) Execute the report

The results of this report can be grouped by Business Partner. It would be great to also group the results by Bank Account (see attached image).
tictech
related to feature request 0008164 closed gmauleon Payment report: does not show the sales representative 
related to feature request 0008777 closed gmauleon Improvements in the Payment Report: show business partner 
png Issue8162.png (17,549) 2009-04-03 10:44
https://issues.openbravo.com/file_download.php?file_id=1116&type=bug
png
Issue History
2009-03-17 17:12jaimetorreNew Issue
2009-03-17 17:12jaimetorreAssigned To => rafaroda
2009-03-17 17:12jaimetorreRegression testing => No
2009-03-17 17:13jaimetorreTag Attached: demo-data
2009-03-17 17:13jaimetorreTag Attached: tictech
2009-03-17 17:13jaimetorreTag Detached: demo-data
2009-03-18 09:27rafarodaversion => 2.40MP1
2009-03-24 13:47gorkaionRelationship addedrelated to 0008164
2009-03-30 16:38rafarodaNote Added: 0015069
2009-03-30 16:38rafarodaStatusnew => feedback
2009-04-03 10:43pmagninNote Added: 0015150
2009-04-03 10:44pmagninFile Added: Issue8162.png
2009-04-03 15:10rafarodaAssigned Torafaroda => gmauleon
2009-04-03 15:10rafarodaStatusfeedback => new
2009-04-03 15:10rafarodaTypedefect => feature request
2009-04-03 15:10rafarodaSummaryPayment report does not allow to filter or group by entity. => Payment report does not allow to filter or group by bank account.
2009-04-03 15:10rafarodaDescription Updated
2009-04-03 15:10rafarodaProposed Solution updated
2009-04-03 15:10rafarodaStatusnew => acknowledged
2009-04-27 16:59rafarodaRelationship addedrelated to 0008777
2009-04-30 09:43gmauleonStatusacknowledged => scheduled
2009-04-30 09:43gmauleonfix_in_branch => pi
2009-05-07 15:56cheliNote Added: 0016138
2009-05-08 14:02cheliNote Added: 0016180
2009-05-08 16:18gmauleonNote Added: 0016190
2009-05-12 13:19hgbotCheckin
2009-05-12 13:19hgbotNote Added: 0016298
2009-05-12 13:19hgbotStatusscheduled => resolved
2009-05-12 13:19hgbotResolutionopen => fixed
2009-05-12 13:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6d631363ffc7416731b54e8e499a7e7a6e3b5d3d [^]
2009-07-03 14:26pjuvaraPriorityimmediate => urgent
2009-08-10 22:36pjuvaraStatusresolved => closed
2009-08-10 22:36pjuvaraFixed in Version => 2.50MP2
2009-08-11 00:00anonymoussf_bug_id0 => 2835184

Notes
(0015069)
rafaroda   
2009-03-30 16:38   
Waiting for steps to reproduce and customer's explanation.
(0015150)
pmagnin   
2009-04-03 10:43   
The term Entity is wrong. The new filter is “Entidad Financiera” (ES), or “Bank Account” (EN).
Please find in attachment a mockup (file Issue8162.png).
(0016138)
cheli   
2009-05-07 15:56   
I have just tested the new functionality and it is all ok except when you only mark "group by bank account" checkbox. In this case the report shows the same data as when you mark group by business partner and bank account at the same time.
(0016180)
cheli   
2009-05-08 14:02   
there is another issue, now the debt payments that are asociated with a bank account are not shown in the report list. It happens if you are in any of the four cases (group by bp=no and group by ba=no,group by bp=yes and group by ba=no, group by bp=no and group by ba=yes, group by bp=yes and group by ba=yes).
(0016190)
gmauleon   
2009-05-08 16:18   
Both issues are Fixed in Rev 184 and 188
(0016298)
hgbot   
2009-05-12 13:19   
Repository: erp/devel/pi
Changeset: 6d631363ffc7416731b54e8e499a7e7a6e3b5d3d
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Tue May 12 13:16:27 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6d631363ffc7416731b54e8e499a7e7a6e3b5d3d [^]

fixes issue 8777 fixes issue 8474 fixes issue 8162 related to issue 4493 Improvement in some report and add the PDF button

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.html
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportCashJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.html
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.java
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.xml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack.html
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack.java
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductionRunJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportProductionRunJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.html
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDaily.html
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDaily.java
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.java
A src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTracker.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
A src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
---