[
https://issues.apache.org/jira/browse/OFBIZ-1173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David E. Jones closed OFBIZ-1173.
---------------------------------
Resolution: Invalid
> 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.
