Re: outgoing payment - Setting status to 'Sent' causes exception

[Jacques Le Roux]

Thanks Sumit,

So its possible to have an outgoing pyament in cash ?
Jacques

From: "Sumit Pandit" <sumit.pan...@hotwaxmedia.com>
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=Company
 OR
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)]