You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "David E. Jones (JIRA)" <ji...@apache.org> on 2007/07/29 17:00:54 UTC
[jira] Closed: (OFBIZ-1173) Settlement Process (Reconciliation
Error)
[ 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.