OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-1173) Settlement Process (Reconciliation Error)

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-1173) Settlement Process (Reconciliation Error)

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.

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-1173) Settlement Process (Reconciliation Error)

[ 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.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-1173) Settlement Process (Reconciliation Error)

In reply to this post by Nicolas Malin (Jira)

[ 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

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.