Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019600Openbravo ERP09. Financial managementpublic2012-01-31 11:472012-02-01 11:58
Reporterxabiermerino 
Assigned ToioritzCia 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP38 
Target Version2.50MP40Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019600: 'Create File' very slow in the Remittance window
Description'Create File' very slow in the Remittance window. The query 'selectLineas' in the CreateFile_data.xsql is very slow.
Steps To ReproduceClick 'Create File' in a remittance with several lines.
Proposed SolutionAdd AND BP_L.C_BPARTNER_ID = BP.C_BPARTNER_ID in the query.


      SELECT RPAD(COALESCE(BA.A_Name,COALESCE(BP.NAME2,BP.NAME)),40,' ') AS TERCERO,RPAD(TO_CHAR(COALESCE(C_INVOICE.DATEINVOICED,DP.DATEPLANNED), 'DDMMYY'),14) AS FECHA_FACTURA,
      TO_CHAR(TO_CHAR(DP.DATEPLANNED, 'DDMMYY')) AS FECHA_VENCIMIENTO,LPAD(TO_CHAR(ROUND(DP.AMOUNT*100,0)),10,'0') AS PAYAMT,
      (SELECT MAX(BP_A.ACCOUNTNO) FROM C_BP_BANKACCOUNT BP_A WHERE BP.C_BPARTNER_ID = BP_A.C_BPARTNER_ID AND BP_A.ISACTIVE='Y') AS CREDITCARDNUMBER,
      LPAD(BP.VALUE,12,'0') AS N_FACTURA, RPAD(LPAD(BP.VALUE,8,'0'),12,' ') AS N_FACTURA19,L.CITY AS CIUDAD, RPAD(L.ADDRESS1,40,' ') AS DIRECCION,
      TO_CHAR(now(),'DD')||TO_CHAR(now(),'MM')||TO_CHAR(now(),'YY') AS HOY, RPAD(COALESCE(TO_CHAR(DP.DESCRIPTION),' '),40,' ') AS CONCEPTO,
      RPAD(L.CITY,35,' ') AS PLAZA, RPAD(L.CITY,38,' ') AS LOCALIDAD, L.POSTAL AS POSTAL, SUBSTR(L.POSTAL,1,2) AS CODIGO_PROVINCIA, BP.TAXID AS NIF
      FROM c_remittanceline S, C_BPARTNER_LOCATION BP_L,
      C_LOCATION L, C_BPARTNER BP, C_BP_BankAccount BA,
      C_DEBT_PAYMENT DP left join C_INVOICE on DP.C_INVOICE_ID = C_INVOICE.C_INVOICE_ID
      WHERE S.C_debt_payment_id = DP.C_debt_payment_id
      AND BA.C_BPartner_ID = BP.C_BPartner_ID
      AND DP.C_BPARTNER_ID = BP.C_BPARTNER_ID
      AND BP_L.C_BPARTNER_ID = BP.C_BPARTNER_ID
      AND BP_L.C_BPARTNER_LOCATION_ID = C_GETBPLOCATIONID(BP.C_BPARTNER_ID, 'B')
      AND BP_L.C_LOCATION_ID = L.C_LOCATION_ID
      AND BA.IsActive = 'Y'
      and s.C_Remittance_ID = ?
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-01-31 11:47xabiermerinoNew Issue
2012-01-31 11:47xabiermerinoAssigned To => jonalegriaesarte
2012-01-31 11:47xabiermerinoModules => Core
2012-01-31 11:47xabiermerinoResolution time => 1333231200
2012-01-31 11:50xabiermerinoIssue Monitored: networkb
2012-02-01 10:10jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-02-01 11:39hgbotCheckin
2012-02-01 11:39hgbotNote Added: 0044764
2012-02-01 11:39hgbotStatusnew => resolved
2012-02-01 11:39hgbotResolutionopen => fixed
2012-02-01 11:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/77b70e95d4b1cc2943f8ad4ef60bac7b8fbe55e9 [^]
2012-02-01 11:58xabiermerinoNote Added: 0044765
2012-02-01 11:58xabiermerinoStatusresolved => closed

Notes
(0044764)
hgbot   
2012-02-01 11:39   
Repository: erp/stable/2.50
Changeset: 77b70e95d4b1cc2943f8ad4ef60bac7b8fbe55e9
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Feb 01 11:38:07 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/77b70e95d4b1cc2943f8ad4ef60bac7b8fbe55e9 [^]

Fixes issue 19600: 'Create File' very slow in the Remittance window.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql
---
(0044765)
xabiermerino   
2012-02-01 11:58   
verifed