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)]
