0019600: '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 Reproduce

Click 'Create File' in a remittance with several lines.

Proposed Solution

Add 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 = ?

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0044764) hgbot (developer) 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 (reporter) 2012-02-01 11:58	verifed

Issue History
Date Modified	Username	Field	Change
2012-01-31 11:47	xabiermerino	New Issue
2012-01-31 11:47	xabiermerino	Assigned To	=> jonalegriaesarte
2012-01-31 11:47	xabiermerino	Modules	=> Core
2012-01-31 11:47	xabiermerino	Resolution time	=> 1333231200
2012-01-31 11:50	xabiermerino	Issue Monitored: networkb
2012-02-01 10:10	jonalegriaesarte	Assigned To	jonalegriaesarte => ioritzCia
2012-02-01 11:39	hgbot	Checkin
2012-02-01 11:39	hgbot	Note Added: 0044764
2012-02-01 11:39	hgbot	Status	new => resolved
2012-02-01 11:39	hgbot	Resolution	open => fixed
2012-02-01 11:39	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/77b70e95d4b1cc2943f8ad4ef60bac7b8fbe55e9 [^]
2012-02-01 11:58	xabiermerino	Note Added: 0044765
2012-02-01 11:58	xabiermerino	Status	resolved => closed