Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminoralways2018-02-15 10:552018-02-20 09:21
ReporterjarmendarizView Statuspublic 
Assigned Tomarkmm82 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q4.2
StatusclosedFix in branchFixed in SCM revision745b2146ac23
ProjectionnoneETAnoneTarget Version3.0PR17Q4.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression levelProduction - Confirmed Stable
Regression date2017-05-30
Regression introduced in release3.0PR17Q3
Regression introduced by commit [^]
Triggers an Emergency PackNo

0037972: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0037926 closedmarkmm82 Purchase reports with invoiced purchases shows no data in Excel format 

-  Notes
hgbot (developer)
2018-02-20 09:18

Repository: erp/backports/3.0PR17Q4.2
Changeset: 745b2146ac23082b6473f5e3f2303fd1aeac995f
Author: David Miguelez <david.miguelez <at>>
Date: Mon Feb 19 18:38:44 2018 +0100
URL: [^]

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
dmiguelez (developer)
2018-02-20 09:21

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2018-02-20 09:12 dmiguelez Type defect => backport
2018-02-20 09:12 dmiguelez Target Version => 3.0PR17Q4.2
2018-02-20 09:18 hgbot Checkin
2018-02-20 09:18 hgbot Note Added: 0102512
2018-02-20 09:18 hgbot Status scheduled => resolved
2018-02-20 09:18 hgbot Resolution open => fixed
2018-02-20 09:18 hgbot Fixed in SCM revision => [^]
2018-02-20 09:21 dmiguelez Review Assigned To => dmiguelez
2018-02-20 09:21 dmiguelez Note Added: 0102515
2018-02-20 09:21 dmiguelez Status resolved => closed
2018-02-20 09:21 dmiguelez Fixed in Version => 3.0PR17Q4.2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker