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)] |
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)] |
Administrator
|
Thanks Sumit,
So its possible to have an outgoing pyament in cash ? Jacques From: "Sumit Pandit" <[hidden email]> 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)] |
In reply to this post by Sumit Pandit-3
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)] > > |
In reply to this post by Jacques Le Roux
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 < [hidden email]> wrote: > Thanks Sumit, > > So its possible to have an outgoing pyament in cash ? > > Jacques > > From: "Sumit Pandit" <[hidden email]> > > 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)] >> > > > > |
Administrator
|
In reply to this post by aswath narayana
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)] >> >> > |
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) Download Attachment |
Administrator
|
Thanks for confirmation Scott,
Jacques From: "Scott Gray" <[hidden email]> > 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)] >>>> >>>> >> >> > > |
Free forum by Nabble | Edit this page |