Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018273Openbravo ERP09. Financial managementpublic2011-08-12 10:552016-06-17 19:37
ReporterioritzCia 
Assigned ToioritzCia 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browserMozilla Firefox
ModulesPayment Report
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018273: It would be nice to have a Sales Representative filter.
DescriptionIt would be nice to have a Sales Representative filter.
Steps To Reproduce- Go to Payment Report.
- There is not Sales Representative filter.
- It would be nice to have it.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff PaymentReport.diff (67,228) 2016-03-03 13:07
https://issues.openbravo.com/file_download.php?file_id=9128&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-08-12 10:55ioritzCiaNew Issue
2011-08-12 10:55ioritzCiaAssigned To => ioritzCia
2011-08-12 10:55ioritzCiaWeb browser => Mozilla Firefox
2011-08-12 10:55ioritzCiaModules => Payment Report
2011-08-12 10:55ioritzCiaIssue Monitored: ioritzCia
2011-08-12 10:56ioritzCiaIssue End Monitor: ioritzCia
2011-08-12 10:57ioritzCiaIssue Monitored: networkb
2016-03-03 13:04ngarciaFile Added: PaymentReport.diff
2016-03-03 13:04ngarciaFile Deleted: PaymentReport.diff
2016-03-03 13:07ngarciaFile Added: PaymentReport.diff
2016-04-20 19:17dmiguelezNote Added: 0085788
2016-04-20 19:23hgbotCheckin
2016-04-20 19:23hgbotNote Added: 0085790
2016-04-20 19:23hgbotStatusnew => resolved
2016-04-20 19:23hgbotResolutionopen => fixed
2016-04-20 19:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9f8588c74edccc3cf1a07cc91cd05182cf91fd24 [^]
2016-04-20 19:23hgbotCheckin
2016-04-20 19:23hgbotNote Added: 0085793
2016-04-20 19:31dmiguelezReview Assigned To => dmiguelez
2016-04-20 19:31dmiguelezNote Added: 0085795
2016-04-20 19:31dmiguelezStatusresolved => closed
2016-04-20 19:59hgbotCheckin
2016-04-20 19:59hgbotNote Added: 0085798
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087467
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087470
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087471

Notes
(0085788)
dmiguelez   
2016-04-20 19:17   
Test Plan:

Open Payment Report Window

Set filters
Organization: F&B España
Document Date From: 01-01-2016
Document Date To:31-12-2016

Launch report

Check that you can see some data.
Check that, in the Status: Payment Cleared section there are some Transactions without Payment or Invoice

With same filters, add filter
Sales Representative: Javier Martín

Launch report

Check that there is no data (no Invoices against this Sales representative)

Create a new Sales Invoice with Javier Martin as a Sales Representative, for F&B España Región Norte Organization and within the year 2016

Launch the report again with the same parameters.

Check that there is a line related to the previously created Invoice in Awaiting Payment Status.

Create a Payment for that Invoice

Launch the report again and check that the Status has changed to Deposited not Cleared.

Check the output of the report in xls and pdf outputs, must be the same.
(0085790)
hgbot   
2016-04-20 19:23   
Repository: erp/devel/pi
Changeset: 9f8588c74edccc3cf1a07cc91cd05182cf91fd24
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Apr 20 13:30:16 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9f8588c74edccc3cf1a07cc91cd05182cf91fd24 [^]

Fixes Issue 18273. Adds ability to filter Payment Report by
Sales Representative.

Adapts code to be able to filter the data based on Sales Rep.

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.html
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.java
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.xml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0085793)
hgbot   
2016-04-20 19:23   
Repository: erp/devel/pi
Changeset: a4c45ff02eb96de46eb7a37371f872935d8fd2e7
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Apr 20 09:56:17 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a4c45ff02eb96de46eb7a37371f872935d8fd2e7 [^]

Related to Issue 18271. Related to Issue 18273. Export of
AD_TEXTINTERFACES.

---
M modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0085795)
dmiguelez   
2016-04-20 19:31   
Code Review + Testing Ok
(0085798)
hgbot   
2016-04-20 19:59   
Repository: erp/devel/pi
Changeset: 112bc5f8f2c60fb65f6f779fa0c615396220fd06
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Apr 20 19:58:48 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/112bc5f8f2c60fb65f6f779fa0c615396220fd06 [^]

Related to Issue 18273, related to Issue 18271. Fixes extra characters in html.

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.html
---
(0087467)
hudsonbot   
2016-06-17 19:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test
(0087470)
hudsonbot   
2016-06-17 19:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test
(0087471)
hudsonbot   
2016-06-17 19:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test