[
https://issues.apache.org/jira/browse/OFBIZ-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aswath Satrasala updated OFBIZ-2968:
------------------------------------
Attachment: patch.txt
VendorPrePayment is mapped to accounttype=prepaid-expenses
There was no mapping for the 'Company' from accounttype=prepaid-expenses to a
GL account
Hence the exception
Please review the patch
> 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
> Attachments: patch.txt
>
>
> 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.
