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" <[email protected]>I had filed a bug and submitted a patch related to this. It is in resolvedstatus 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 <[email protected]>wrote:Hi Aswath,As per your error concerned - you don't have GlAccountId "150000" assignedto 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 youcan 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
Description: S/MIME cryptographic signature
