Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0033956Openbravo ERP07. Sales managementpublic2016-09-12 18:412016-09-23 18:22
egoitz 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR16Q4 
aferraz
Core
No
0033956: The generate invoic takes long with big amount of data
When there are thousand of invoices pending to be created, the generate invoices process takes long
-On an environment with thousand of order pending to be invoiced, open the create invoices process and execute it:
*It takes minutes to finish
No tags attached.
related to defect 0033319 closed AtulOpenbravo The generate shipment from orders form takes long to print the data with a lot of orders pending to be deliver 
Issue History
2016-09-12 18:41egoitzNew Issue
2016-09-12 18:41egoitzAssigned To => AtulOpenbravo
2016-09-12 18:41egoitzModules => Core
2016-09-12 18:41egoitzTriggers an Emergency Pack => No
2016-09-12 18:41egoitzIssue generated from0033319
2016-09-12 18:41egoitzRelationship addedrelated to 0033319
2016-09-13 08:39heccamIssue Monitored: heccam
2016-09-13 09:38aferrazAssigned ToAtulOpenbravo => Triage Finance
2016-09-14 12:29aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-09-22 10:24hgbotCheckin
2016-09-22 10:24hgbotNote Added: 0090150
2016-09-22 10:24hgbotStatusnew => resolved
2016-09-22 10:24hgbotResolutionopen => fixed
2016-09-22 10:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/13f7a8be31637e8f44e276bb49066780ae16e3d0 [^]
2016-09-22 10:25aferrazReview Assigned To => aferraz
2016-09-22 10:25aferrazNote Added: 0090151
2016-09-22 10:25aferrazStatusresolved => closed
2016-09-22 10:25aferrazFixed in Version => 3.0PR16Q4
2016-09-23 18:22hudsonbotCheckin
2016-09-23 18:22hudsonbotNote Added: 0090213

Notes
(0090150)
hgbot   
2016-09-22 10:24   
Repository: erp/devel/pi
Changeset: 13f7a8be31637e8f44e276bb49066780ae16e3d0
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Sep 21 00:20:58 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/13f7a8be31637e8f44e276bb49066780ae16e3d0 [^]

Fixes issue 33956: The generate invoice takes long with big amount of data

Added index for column isselected of order table to improve select query and initupdate method used in invoice create process.

---
M src-db/database/model/tables/C_ORDER.xml
---
(0090151)
aferraz   
2016-09-22 10:25   
Code review + Testing OK
(0090213)
hudsonbot   
2016-09-23 18:22   
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/25f7de2ab346 [^]
Maturity status: Test