It should be ok to have a outgoing payment in cash, as cash transactions are normal for small business in India.
-Aswath On Thu, Nov 19, 2009 at 4:45 AM, Jacques Le Roux < [email protected]> wrote: > Thanks Sumit, > > So its possible to have an outgoing pyament in cash ? > > Jacques > > From: "Sumit Pandit" <[email protected]> > > 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)] >> > > > >
