Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0033320Openbravo ERP07. Sales managementpublic2016-06-20 18:472016-08-11 18:40
0033320: On environment whit big volumnes the create from process takes long to print the popup.
When do you want to deliver a order creating the shipment using the create from process, the popup takes minutes to be printed on environment with big amount of orders,shipements and invoices.

The alernative is to use the create shipments from order window but has also performance problems: [^]
-On an environment with thousends of invoices, orders and shipment, create a shipment header, and click on the create from button.
It takes long to show the popup.
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-06-20 18:47egoitzNew Issue
2016-06-20 18:47egoitzAssigned To => Triage Finance
2016-06-20 18:47egoitzModules => Core
2016-06-20 18:47egoitzTriggers an Emergency Pack => No
2016-06-20 18:47egoitzTag Attached: Performance
2016-06-20 18:47egoitzRelationship addedrelated to 0033319
2016-06-21 13:42aferrazAssigned ToTriage Finance => markmm82
2016-07-06 17:37vmromanosAssigned Tomarkmm82 => AtulOpenbravo
2016-07-19 22:19AtulOpenbravoStatusnew => scheduled
2016-07-20 10:06hgbotCheckin
2016-07-20 10:06hgbotNote Added: 0088593
2016-07-20 10:06hgbotStatusscheduled => resolved
2016-07-20 10:06hgbotResolutionopen => fixed
2016-07-20 10:06hgbotFixed in SCM revision => [^]
2016-07-20 10:07aferrazReview Assigned To => aferraz
2016-07-20 10:07aferrazNote Added: 0088595
2016-07-20 10:07aferrazStatusresolved => closed
2016-07-20 10:07aferrazFixed in Version => 3.0PR16Q4
2016-08-11 18:40hudsonbotCheckin
2016-08-11 18:40hudsonbotNote Added: 0089023

2016-07-20 10:06   
Repository: erp/devel/pi
Changeset: 734222ff0bdd35a2ab8948a6f5dd366cdd97c3e7
Author: Atul Gaware <atul.gaware <at>>
Date: Tue Jul 19 20:20:24 2016 +0530
URL: [^]

Fixes Issue 33320: Performance problems in Create Lines From process

Problem was with loading invoices and orders in the respective combos.
Changed both queries to improve the performance.

M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
2016-07-20 10:07   
Code review + Testing OK
2016-08-11 18:40   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test