0025673: Posting a gl journal takes long when the journal is a opening journal with thousands of lines

diff --git a/src/org/openbravo/erpCommon/ad_forms/Fact.java b/src/org/openbravo/erpCommon/ad_forms/Fact.java
--- a/src/org/openbravo/erpCommon/ad_forms/Fact.java
+++ b/src/org/openbravo/erpCommon/ad_forms/Fact.java
@@ -451,6 +451,8 @@
         return false;
       }
     }
+    if (m_doc.m_IsOpening.equals("Y"))
+      FactLineData.updateFactAcct(con, conn, m_doc.AD_Table_ID, m_doc.Record_ID);
     return true;
   } // commit
 
diff --git a/src/org/openbravo/erpCommon/ad_forms/FactLine.java b/src/org/openbravo/erpCommon/ad_forms/FactLine.java
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine.java
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine.java
@@ -824,8 +824,8 @@
             C_Costcenter_ID);
         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 --git a/src/org/openbravo/erpCommon/ad_forms/FactLine.java b/src/org/openbravo/erpCommon/ad_forms/FactLine.java
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine.java
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine.java
@@ -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")) ? "0" : "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 --git a/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql b/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
@@ -89,7 +89,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(?),
@@ -97,7 +97,7 @@
            ?, ?, ?, ?,
            TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?),
            ?, TO_NUMBER(?), ?,?, ?, ?,?, ?, ?,?, ?, ?,?, ?, ?, ?, TO_NUMBER(?), ?,
-           ?, ?, ?, ?, ?)
+           ?, ?, ?, ?, ?, ?)
      ]]>
      </Sql>
      <Parameter name="m_Fact_Acct_ID"/>
@@ -146,6 +146,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>