Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037944Openbravo ERPA. Platformpublic2018-02-15 10:552018-02-20 09:21
Reporterjarmendariz 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR18Q1Fixed in Version3.0PR18Q1 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2017-05-30
Regression introduced in release3.0PR17Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/c389a2ee19ab9a68d59ce06deb566e26b87ff0b4 [^]
Triggers an Emergency PackNo
Summary0037944: Purchase reports with invoiced purchases shows no data in Excel format
DescriptionPurchare report shows invoiced purchases in html and pdf format, however importing to excel format returns an empty spreadsheet.
Steps To ReproduceAs F&B International Group Admin:

'Purchase Order' window -> create new purchase order:
- Organization: F&B España, S.A
- Business Partner: Refrescos Naturales, S.A
- Order Date: <today's date>

Save and create a line:
- Product: Agua sin Gas 1L
- Ordered quantity: 100
Save and Book order.

Next, go to 'Purchase Invoice' window and create a new item:
- Organization: F&B España, S.A
- Business Partner: Refrescos Naturales, S.A

Save and tap 'Create Lines From" button:
-In the popup, select the created purchase order.
-Check the item 'Agua sin Gas 1L' that appeared and press the OK button
Press the 'Complete' button and 'OK'.

Finally, open 'Purchase order Report':
- Business Partner: Refrescos Naturales, S.A
- Starting Date: <today's date>

Press 'View' button. It should contain the purchase order we just created.
Now move back to 'Purchase order report' and press 'Export to Excel'. The resulting .xlsx spreadsheet is empty.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037926 closed markmm82 Purchase reports with invoiced purchases shows no data in Excel format 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-15 20:47markmm82Typedefect => backport
2018-02-15 20:47markmm82Target Version => 3.0PR18Q1
2018-02-20 09:18hgbotCheckin
2018-02-20 09:18hgbotNote Added: 0102513
2018-02-20 09:18hgbotStatusscheduled => resolved
2018-02-20 09:18hgbotResolutionopen => fixed
2018-02-20 09:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR18Q1/rev/d4261c415047a6329323100966b95410fc7ed5d9 [^]
2018-02-20 09:21dmiguelezReview Assigned To => dmiguelez
2018-02-20 09:21dmiguelezNote Added: 0102516
2018-02-20 09:21dmiguelezStatusresolved => closed
2018-02-20 09:21dmiguelezFixed in Version => 3.0PR18Q1

Notes
(0102513)
hgbot   
2018-02-20 09:18   
Repository: erp/backports/3.0PR18Q1
Changeset: d4261c415047a6329323100966b95410fc7ed5d9
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Feb 19 18:38:44 2018 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR18Q1/rev/d4261c415047a6329323100966b95410fc7ed5d9 [^]

Fixes Issue 37944. Fixes problem in query that was avoiding to show
data for a Purchase Order already Invoiced.

It correctly filters the match_po table to retrieve the quantity
pending to be received

---
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrderXLS.jrxml
---
(0102516)
dmiguelez   
2018-02-20 09:21   
Code Review + Testing Ok