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.
