Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037926
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2018-02-15 10:552018-02-22 18:19
ReporterjarmendarizView Statuspublic 
Assigned Tomarkmm82 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q2
StatusclosedFix in branchFixed in SCM revision5b91e028f16d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
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
Summary

0037926: 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 ]
depends on backport 00379443.0PR18Q1 closedmarkmm82 Purchase reports with invoiced purchases shows no data in Excel format 
depends on backport 00379723.0PR17Q4.2 closedmarkmm82 Purchase reports with invoiced purchases shows no data in Excel format 
caused by feature request 0033035 closedairaceburu New filters in Purchase Order Report 

-  Notes
(0102454)
markmm82 (developer)
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 (developer)
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 (developer)
2018-02-20 09:20

 Code Review + Testing Ok
(0102777)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2018-02-15 10:55 jarmendariz New Issue
2018-02-15 10:55 jarmendariz Assigned To => platform
2018-02-15 10:55 jarmendariz Modules => Core
2018-02-15 10:55 jarmendariz Triggers an Emergency Pack => No
2018-02-15 10:58 jarmendariz Steps to Reproduce Updated View Revisions
2018-02-15 11:46 caristu Relationship added caused by 0033035
2018-02-15 11:49 jarmendariz Regression level => Production - Confirmed Stable
2018-02-15 11:49 jarmendariz Regression date => 2017-05-30
2018-02-15 11:49 jarmendariz Regression introduced in release => 3.0PR17Q3
2018-02-15 11:49 jarmendariz Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/c389a2ee19ab9a68d59ce06deb566e26b87ff0b4 [^]
2018-02-15 11:52 caristu Assigned To platform => Triage Finance
2018-02-15 18:41 markmm82 Assigned To Triage Finance => markmm82
2018-02-15 20:47 markmm82 Status new => scheduled
2018-02-15 22:30 markmm82 Note Added: 0102454
2018-02-19 20:59 markmm82 Note Edited: 0102454 View Revisions
2018-02-19 21:14 markmm82 Note Edited: 0102454 View Revisions
2018-02-20 09:12 dmiguelez Status scheduled => acknowledged
2018-02-20 09:12 dmiguelez Status acknowledged => scheduled
2018-02-20 09:13 hgbot Checkin
2018-02-20 09:13 hgbot Note Added: 0102511
2018-02-20 09:13 hgbot Status scheduled => resolved
2018-02-20 09:13 hgbot Resolution open => fixed
2018-02-20 09:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5b91e028f16d9c9ef3c127cd3ed1111b7c8b6b7a [^]
2018-02-20 09:20 dmiguelez Review Assigned To => dmiguelez
2018-02-20 09:20 dmiguelez Note Added: 0102514
2018-02-20 09:20 dmiguelez Status resolved => closed
2018-02-20 09:20 dmiguelez Fixed in Version => 3.0PR18Q2
2018-02-22 18:19 hudsonbot Checkin
2018-02-22 18:19 hudsonbot Note Added: 0102777

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker