outgoing payment - Setting status to 'Sent' causes exception
Locked
outgoing payment - Setting status to 'Sent' causes exception
 
|
Re: outgoing payment - Setting status to 'Sent' causes exception
|
|
Re: outgoing payment - Setting status to 'Sent' causes exception
Administrator
|
Re: outgoing payment - Setting status to 'Sent' causes exception
|
|
Re: outgoing payment - Setting status to 'Sent' causes exception
|
|
Re: outgoing payment - Setting status to 'Sent' causes exception
|
Administrator
|
Re: outgoing payment - Setting status to 'Sent' causes exception
|
|
While that patch did resolve the problem I think we should probably
improve the gl code so that it can better handle cases like this. Regards Scott HotWax Media http://www.hotwaxmedia.com On 19/11/2009, at 8:21 PM, Jacques Le Roux wrote: > Hi Aswath, Sumit, > > Oops, sorry I did not remember that I had commited this. But > actually my question was more about cash mehtod payment being > accessible in outgoing payment. Using demo data OOTB it's not there... > > Jacques > > From: "aswath narayana" <[hidden email]> >> I had filed a bug and submitted a patch related to this. It is in >> resolved >> status now. >> For more information, please see, >> https://issues.apache.org/jira/browse/OFBIZ-2968 >> >> -Aswath >> >> On Thu, Nov 19, 2009 at 4:17 AM, Sumit Pandit >> <[hidden email]>wrote: >> >>> 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)] >>> >>> > > |
smime.p7s (4K)
Re: outgoing payment - Setting status to 'Sent' causes exception
|
Administrator
|
| Free forum by Nabble | Edit this page |