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.0PR18Q1
StatusclosedFix in branchFixed in SCM revisiond4261c415047
ProjectionnoneETAnoneTarget Version3.0PR18Q1
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

0037944: 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.0PR18Q1
Changeset: d4261c415047a6329323100966b95410fc7ed5d9
Author: David Miguelez <david.miguelez <at>>
Date: Mon Feb 19 18:38:44 2018 +0100
URL: [^]

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

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2018-02-15 20:47 markmm82 Type defect => backport
2018-02-15 20:47 markmm82 Target Version => 3.0PR18Q1
2018-02-20 09:18 hgbot Checkin
2018-02-20 09:18 hgbot Note Added: 0102513
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: 0102516
2018-02-20 09:21 dmiguelez Status resolved => closed
2018-02-20 09:21 dmiguelez Fixed in Version => 3.0PR18Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker