Openbravo Issue Tracking System - POS2
View Issue Details
0058167POS2Corepublic2025-03-06 13:482025-03-06 13:50
sofidossant 
Triage Platform Base 
normalminoralways
newopen 
5
pi 
 
No
0058167: Performance: Slow loading of Product window in Sales Order, Sales Quotation, Sales Purchase, Sales Invoice in the lines.
When we want to create lines in Sales Order, Sales Quotation, Sales Purchase, Sales Invoice, and we select product, the window takes a long time.
This happens when there are several products.

In my case, takes 20''
If we did a sales order and create the line, click in product, open the window

QUERY

select
  pricingpro0_.M_ProductPrice_ID as,
  pricingpro0_.M_PriceList_Version_ID as m_pricel2__,
  pricingpro0_.M_Product_ID as m_produc3__,
  pricingpro0_.AD_Client_ID as ad_clien4__,
  pricingpro0_.AD_Org_ID as ad_org_i5__,
  pricingpro0_.IsActive as isactive6__,
  pricingpro0_.Created as created7__,
  pricingpro0_.CreatedBy as createdb8__,
  pricingpro0_.Updated as updated9__,
  pricingpro0_.UpdatedBy as updated10__,
  pricingpro0_.PriceList as priceli11__,
  pricingpro0_.PriceStd as pricest12__,
  pricingpro0_.PriceLimit as priceli13__,
  pricingpro0_.Cost as cost14__,
  pricingpro0_.Algorithm as algorit15__,
  pricingpro0_.EM_Obpos2_Taxcategory_ID as em_obpo16__,
  pricingpro0_.em_pos2plp_printpriceoptions as em_pos17__,
  pricingpro0_.em_obpos2_printpriceoptions as em_obpo18__,
  pricingpro0_.EM_Obpos2_Printpriceoptionsui as em_obpo19__,
  pricingpro0_.EM_Obpos_Maxprice as em_obpo20__,
  pricingpro0_.EM_Obpos_Skipapplypromotions as em_obpo21__,
  pricingpro0_.EM_Obpos_Useextpromotions as em_obpo22__,
  pricingpro0_.EM_Pos2plp_Attribute_1 as em_pos23__,
  pricingpro0_.EM_Pos2plp_Attribute_2 as em_pos24__,
  pricingpro0_.EM_Pos2plp_Attribute_3 as em_pos25__,
  pricingpro0_.EM_Pos2plp_Printing_Att1 as em_pos26__
from
  M_ProductPrice pricingpro0_
where
  pricingpro0_.M_ProductPrice_ID in (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
No tags attached.
Issue History
2025-03-06 13:48sofidossantNew Issue
2025-03-06 13:48sofidossantAssigned To => Triage Platform Base
2025-03-06 13:48sofidossantTriggers an Emergency Pack => No
2025-03-06 13:50PracticsIssue Monitored: Practics

There are no notes attached to this issue.