Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037926Openbravo ERPA. Platformpublic2018-02-15 10:552018-02-22 18:19
Reporterjarmendariz 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
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
Summary0037926: 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
depends on backport 00379443.0PR18Q1 closed markmm82 Purchase reports with invoiced purchases shows no data in Excel format 
depends on backport 00379723.0PR17Q4.2 closed markmm82 Purchase reports with invoiced purchases shows no data in Excel format 
caused by feature request 0033035 closed airaceburu New filters in Purchase Order Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-15 10:55jarmendarizNew Issue
2018-02-15 10:55jarmendarizAssigned To => platform
2018-02-15 10:55jarmendarizModules => Core
2018-02-15 10:55jarmendarizTriggers an Emergency Pack => No
2018-02-15 10:58jarmendarizSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16699#r16699
2018-02-15 11:46caristuRelationship addedcaused by 0033035
2018-02-15 11:49jarmendarizRegression level => Production - Confirmed Stable
2018-02-15 11:49jarmendarizRegression date => 2017-05-30
2018-02-15 11:49jarmendarizRegression introduced in release => 3.0PR17Q3
2018-02-15 11:49jarmendarizRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/c389a2ee19ab9a68d59ce06deb566e26b87ff0b4 [^]
2018-02-15 11:52caristuAssigned Toplatform => Triage Finance
2018-02-15 18:41markmm82Assigned ToTriage Finance => markmm82
2018-02-15 20:47markmm82Statusnew => scheduled
2018-02-15 22:30markmm82Note Added: 0102454
2018-02-19 20:59markmm82Note Edited: 0102454bug_revision_view_page.php?bugnote_id=0102454#r16738
2018-02-19 21:14markmm82Note Edited: 0102454bug_revision_view_page.php?bugnote_id=0102454#r16739
2018-02-20 09:12dmiguelezStatusscheduled => acknowledged
2018-02-20 09:12dmiguelezStatusacknowledged => scheduled
2018-02-20 09:13hgbotCheckin
2018-02-20 09:13hgbotNote Added: 0102511
2018-02-20 09:13hgbotStatusscheduled => resolved
2018-02-20 09:13hgbotResolutionopen => fixed
2018-02-20 09:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5b91e028f16d9c9ef3c127cd3ed1111b7c8b6b7a [^]
2018-02-20 09:20dmiguelezReview Assigned To => dmiguelez
2018-02-20 09:20dmiguelezNote Added: 0102514
2018-02-20 09:20dmiguelezStatusresolved => closed
2018-02-20 09:20dmiguelezFixed in Version => 3.0PR18Q2
2018-02-22 18:19hudsonbotCheckin
2018-02-22 18:19hudsonbotNote Added: 0102777

Notes
(0102454)
markmm82   
2018-02-15 22:30   
(edited on: 2018-02-19 21:14)
Test Plan:
As 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.

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 press 'Export to Excel'. The resulting .xlsx spreadsheet also contains the order we just created with 100 units as Outstanding quantity.

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'.

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 contains the order we just created with 100 units as Outstanding quantity.

Create a new Goods Receipt:
- Business Partner: Refrescos Naturales, S.A
Press Create Lines From button and select 50 units of the previously created Purchase Order, choose any storage bin and DONE.
Complete the receipt.

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 contains the order we just created with 50 units as Outstanding quantity.

Create another Goods receipt from the purchase order and select the outstanding 50 units.
Go back to 'Purchase order report' and press 'Export to Excel'. The resulting .xlsx spreadsheet contains the order we just created with 0 units as Outstanding quantity.
(0102511)
hgbot   
2018-02-20 09:13   
Repository: erp/devel/pi
Changeset: 5b91e028f16d9c9ef3c127cd3ed1111b7c8b6b7a
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Feb 19 18:38:44 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5b91e028f16d9c9ef3c127cd3ed1111b7c8b6b7a [^]

Fixes Issue 37926. 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
---
(0102514)
dmiguelez   
2018-02-20 09:20   
Code Review + Testing Ok
(0102777)
hudsonbot   
2018-02-22 18:19   
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/980a6ad5bbf5 [^]
Maturity status: Test