Settlement Process (Reconciliation Error) -----------------------------------------
Key: OFBIZ-1173 URL: https://issues.apache.org/jira/browse/OFBIZ-1173 Project: OFBiz Issue Type: Bug Components: accounting Environment: Opentaps 1.0.0 (Preview 3 and 4). Windows xp, Hp Pavilion Reporter: Karl Pieleck After entering an order and then going to financials / dashboard. Click the settlement for a credit card (AMEX). Fill out the first screen. Second screen for checking off transactions appears to display ok. I then check off the transactions and click "Reconcile" and the following error appears. The Following Errors Occurred: ERROR: Could not complete the Create an GlReconciliation [file:/C:/ofbiz/opentaps-1.0.0/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createGlReconciliation] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:GlReconciliation][createdByUserLogin,admin(java.lang.String)][createdStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][createdTxStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][description,null()][glAccountId,122100(java.lang.String)][glReconciliationId,10001(java.lang.String)][glReconciliationName,Reconciled as of 2007-07-29 10:16:37.843(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastUpdatedStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][organizationPartyId,10007|00002(java.lang.String)][reconciledBalance,0.0(java.lang.Double)][reconciledDate,2007-07-29 10:16:37.843(java.sql.Timestamp)] (while inserting: [GenericEntity:GlReconciliation][createdByUserLogin,admin(java.lang.String)][createdStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][createdTxStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][description,null()][glAccountId,122100(java.lang.String)][glReconciliationId,10001(java.lang.String)][glReconciliationName,Reconciled as of 2007-07-29 10:16:37.843(java.lang.String)][lastModifiedByUserLogin,admin(java.lang.String)][lastUpdatedStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-29 10:16:47.578(java.sql.Timestamp)][organizationPartyId,10007|00002(java.lang.String)][reconciledBalance,0.0(java.lang.Double)][reconciledDate,2007-07-29 10:16:37.843(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO public.GL_RECONCILIATION (GL_RECONCILIATION_ID, GL_RECONCILIATION_NAME, DESCRIPTION, CREATED_BY_USER_LOGIN, LAST_MODIFIED_BY_USER_LOGIN, GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, RECONCILED_BALANCE, RECONCILED_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "gl_reconciliation" violates foreign key constraint "glrec_glparty" Detail: Key (organization_party_id)=(10007|00002) is not present in table "party".)))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.