Hi Aswath,
As per your error concerned - you don't have GlAccountId "150000"
assigned
to PartyId - "Company".
To verify this please look at -
https://demo.ofbiz.org/accounting/control/ListGlAccountOrganization?organizationPartyId=CompanyOR
https://localhost:8080/accounting/control/ListGlAccountOrganization?organizationPartyId=Company
How to set -
If you don't find GlAccount Id "150000" in the list at above page
then you
can assign glAccountId=150000 to your partyId=Company at -
https://demo.ofbiz.org/accounting/control/AssignGlAccount OR
https://localhost:8080/accounting/control/AssignGlAccount
Hope this helps you !!
--
Thanks and Regards
Sumit Pandit
On Sep 23, 2009, at 11:58 PM, aswath narayana wrote:
> 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)]
