Vendor Prepayment - outgoing payment - Setting status to 'Sent' causes exception
--------------------------------------------------------------------------------
Key: OFBIZ-2968
URL: https://issues.apache.org/jira/browse/OFBIZ-2968
Project: OFBiz
Issue Type: Bug
Affects Versions: SVN trunk
Reporter: Aswath Satrasala
Hi,
I created an outgoing payment
PaymentType: VendorPrepayment.
PaymentMethod: Cash
ToParty: DemoSupplier
I click on 'Status to Sent' - Following exception occurs
The Following Errors Occurred:
Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service
invocation error (Could not commit transaction for service [setPaymentStatus]
call: Roll back error, could not commit transaction, was rolled back instead
because of: Failure in create operation for entity [AcctgTransEntry]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10045(java.lang.String)][amount,333.0000(java.math.BigDecimal)][createdStamp,2009-09-24
11:26:29.156(java.sql.Timestamp)][createdTxStamp,2009-09-24
11:26:27.234(java.sql.Timestamp)][currencyUomId,INR(java.lang.String)][debitCreditFlag,D(java.lang.String)][glAccountId,150000(java.lang.String)][glAccountTypeId,PREPAID_EXPENSES(java.lang.String)][lastUpdatedStamp,2009-09-24
11:26:29.156(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-24
11:26:27.234(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,333.0000(java.math.BigDecimal)][origCurrencyUomId,INR(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.ACCTG_TRANS_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID,
ACCTG_TRANS_ENTRY_TYPE_ID, DESCRIPTION, VOUCHER_REF, PARTY_ID, ROLE_TYPE_ID,
THEIR_PARTY_ID, PRODUCT_ID, THEIR_PRODUCT_ID, GL_ACCOUNT_TYPE_ID,
GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, AMOUNT, CURRENCY_UOM_ID, ORIG_AMOUNT,
ORIG_CURRENCY_UOM_ID, DEBIT_CREDIT_FLAG, DUE_DATE, GROUP_ID, TAX_ID,
RECONCILE_STATUS_ID, SETTLEMENT_TERM_ID, IS_SUMMARY, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on
table 'ACCTG_TRANS_ENTRY' caused a violation of foreign key constraint
'ACCTTXENT_GLACOG' for key (150000,Company). The statement has been rolled
back.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException:
Error while inserting:
[GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10045(java.lang.String)][amount,333.0000(java.math.BigDecimal)][createdStamp,2009-09-24
11:26:29.156(java.sql.Timestamp)][createdTxStamp,2009-09-24
11:26:27.234(java.sql.Timestamp)][currencyUomId,INR(java.lang.String)][debitCreditFlag,D(java.lang.String)]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
