Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020326Openbravo ERPZ. Otherspublic2012-04-23 12:252012-04-26 19:31
Reportermaite 
Assigned ToioritzCia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesPayment Report
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020326: Null Pointer Exception error when executing report "Include Empty Business Partner" and there is a transaction without payment
DescriptionNull Pointer Exception error when executing report "Include Empty Business Partner" and there is a transaction without payment
Steps To Reproduce1. Go to "Banco de España - Cuenta 1" Financial Account and "Add Transaction" associated to GLItem for any IN amount.
2. Go to Payment In window and create new record for "España" organization. Leave Business Partner empty. Deposit to "EUR - Banco de España - Cuenta 1" and select any Payment Method. Amount=100.
3. Press Add Details and select any GLItem with IN amount=100. Process.
4. Go to Payment Report and execute report for:
- "España" organization
- Empty business partner="Include Empty Business Partner"
- Ordering Criteria= Date

You will receive NullPointerException error.

Realize that if you change option "Empty business partner" to "Exclude Empty Business Partner" you will obtain data
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-23 12:25maiteNew Issue
2012-04-23 12:25maiteAssigned To => vmromanos
2012-04-23 12:25maiteModules => Payment Report
2012-04-23 12:25maiteOBNetwork customer => Yes
2012-04-23 12:33maiteAssigned Tovmromanos => ioritzCia
2012-04-23 12:33maitePriorityurgent => immediate
2012-04-23 17:53hgbotCheckin
2012-04-23 17:53hgbotNote Added: 0047886
2012-04-23 17:53hgbotStatusnew => resolved
2012-04-23 17:53hgbotResolutionopen => fixed
2012-04-23 17:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/84f458364b70e35c78316aef330908393aabbb29 [^]
2012-04-23 17:56ioritzCiaNote Added: 0047888
2012-04-24 12:19ioritzCiaNote Added: 0047906
2012-04-25 10:47maiteNote Added: 0047952
2012-04-25 10:47maiteStatusresolved => closed
2012-04-26 19:31hudsonbotCheckin
2012-04-26 19:31hudsonbotNote Added: 0048071

Notes
(0047886)
hgbot   
2012-04-23 17:53   
Repository: erp/devel/pi
Changeset: 84f458364b70e35c78316aef330908393aabbb29
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Apr 23 17:44:56 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/84f458364b70e35c78316aef330908393aabbb29 [^]

Fixes issue 20326: Null Pointer Exception error.
Null Pointer Exception when executing report 'Include Empty Business Partner' and there is a transaction without payment.

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0047888)
ioritzCia   
2012-04-23 17:56   
Testing plan:

The error was due to the date ordering criteria. In some specific cases. Follow the steps to reproduce and play with the ordering criteria field. Compare with live for example to check that the report continues to order correctly.
(0047906)
ioritzCia   
2012-04-24 12:19   
Related to changeset: 5d79b4ec08f5
(0047952)
maite   
2012-04-25 10:47   
verified
(0048071)
hudsonbot   
2012-04-26 19:31   
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/70a717a9ffa1 [^]

Maturity status: Test