details: https://code.openbravo.com/erp/devel/pi/rev/9e49204adcd4
changeset: 22809:9e49204adcd4
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Mon Mar 17 17:58:11 2014 +0530
summary: Fixes Issue 25673 Posting opening journal (thousand lines) takes
long time
diffstat:
src/org/openbravo/erpCommon/ad_forms/FactLine.java | 8 ++++----
src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql | 7 ++++---
2 files changed, 8 insertions(+), 7 deletions(-)
diffs (65 lines):
diff -r 5494e746e052 -r 9e49204adcd4
src/org/openbravo/erpCommon/ad_forms/FactLine.java
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine.java Tue Apr 01
18:06:18 2014 +0530
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine.java Mon Mar 17
17:58:11 2014 +0530
@@ -11,7 +11,7 @@
* Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke, parts
* created by ComPiere are Copyright (C) ComPiere, Inc.; All Rights Reserved.
* Contributor(s): Openbravo SLU
- * Contributions are Copyright (C) 2001-2013 Openbravo S.L.U.
+ * Contributions are Copyright (C) 2001-2014 Openbravo S.L.U.
******************************************************************************
*/
package org.openbravo.erpCommon.ad_forms;
@@ -821,11 +821,11 @@
m_Fact_Acct_Group_ID, m_SeqNo, m_DocBaseType, Record_ID2,
(m_docLine != null) ? m_docLine.m_A_Asset_ID : "",
(m_docLine != null) ? m_docLine.m_C_WithHolding_ID : "",
m_docVO.C_DocType_ID,
- C_Costcenter_ID);
+ C_Costcenter_ID, (m_docVO.m_IsOpening.equals("Y")) ? "O" : "N");
log4jFactLine.debug("FactLine - After insertFactAct");
}
- if (m_docVO.m_IsOpening.equals("Y"))
- FactLineData.updateFactAcct(con, conn, m_AD_Table_ID, m_Record_ID);
+ // if (m_docVO.m_IsOpening.equals("Y"))
+ // FactLineData.updateFactAcct(con, conn, m_AD_Table_ID, m_Record_ID);
} catch (ServletException e) {
log4jFactLine.warn(e);
}
diff -r 5494e746e052 -r 9e49204adcd4
src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql Tue Apr 01
18:06:18 2014 +0530
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql Mon Mar 17
17:58:11 2014 +0530
@@ -12,7 +12,7 @@
* Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke, parts
* created by ComPiere are Copyright (C) ComPiere, Inc.; All Rights Reserved.
* Contributor(s): Openbravo SLU
- * Contributions are Copyright (C) 2001-2010 Openbravo S.L.U.
+ * Contributions are Copyright (C) 2001-2014 Openbravo S.L.U.
******************************************************************************
-->
@@ -73,7 +73,7 @@
AmtSourceDR,AmtSourceCR,AmtAcctDR,AmtAcctCR,
C_UOM_ID,Qty,M_Locator_ID,M_Product_ID,C_BPartner_ID,AD_OrgTrx_ID,C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID,
C_Project_ID,C_Campaign_ID,C_Activity_ID,User1_ID,User2_ID,Description,
Fact_Acct_Group_ID, SeqNo, DocBaseType,
- Record_ID2, A_ASSET_ID, C_WithHolding_ID, C_DocType_ID,
C_Costcenter_ID)
+ Record_ID2, A_ASSET_ID, C_WithHolding_ID, C_DocType_ID,
C_Costcenter_ID, FACTACCTTYPE)
VALUES
(?, ?, ?,'Y',now(),?,now(),?,
?, ?, ?, ?, TO_DATE(?), TO_DATE(?),
@@ -81,7 +81,7 @@
?, ?, ?, ?,
TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?),
?, TO_NUMBER(?), ?,?, ?, ?,?, ?, ?,?, ?, ?,?, ?, ?, ?,
TO_NUMBER(?), ?,
- ?, ?, ?, ?, ?)
+ ?, ?, ?, ?, ?, ?)
]]>
</Sql>
<Parameter name="m_Fact_Acct_ID"/>
@@ -130,6 +130,7 @@
<Parameter name="cWithholdingId"/>
<Parameter name="cDocTypeId"/>
<Parameter name="cCostcenterId"/>
+ <Parameter name="FactAcctType"/>
</SqlMethod>
<SqlMethod name="updateFactAcct" type="preparedStatement" connection="true"
return="rowCount">
<SqlMethodComment></SqlMethodComment>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
