[
https://issues.apache.org/jira/browse/OFBIZ-1173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12516224
]
David E. Jones commented on OFBIZ-1173:
---------------------------------------
This appears to be related only to Opentaps, which is based on but is not part
of OFBiz. I appears the problem is with code that is outside of what Opentaps
is using from OFBiz.
You should use the resources of Opentaps for this rather than those of Apache
OFBiz.
Good luck with it though!
> 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.
