Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037972Openbravo ERPA. Platformpublic2018-02-15 10:552018-02-20 09:21
Reporterjarmendariz 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q4.2Fixed in Version3.0PR17Q4.2 
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
Summary0037972: 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-20 09:12dmiguelezTypedefect => backport
2018-02-20 09:12dmiguelezTarget Version => 3.0PR17Q4.2
2018-02-20 09:18hgbotCheckin
2018-02-20 09:18hgbotNote Added: 0102512
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.0PR17Q4.2/rev/745b2146ac23082b6473f5e3f2303fd1aeac995f [^]
2018-02-20 09:21dmiguelezReview Assigned To => dmiguelez
2018-02-20 09:21dmiguelezNote Added: 0102515
2018-02-20 09:21dmiguelezStatusresolved => closed
2018-02-20 09:21dmiguelezFixed in Version => 3.0PR17Q4.2

Notes
(0102512)
hgbot   
2018-02-20 09:18   
Repository: erp/backports/3.0PR17Q4.2
Changeset: 745b2146ac23082b6473f5e3f2303fd1aeac995f
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.0PR17Q4.2/rev/745b2146ac23082b6473f5e3f2303fd1aeac995f [^]

Fixes Issue 37972. 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
---
(0102515)
dmiguelez   
2018-02-20 09:21   
Code Review + Testing Ok