You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Sumit Pandit <su...@hotwaxmedia.com> on 2009/11/18 23:47:53 UTC
Re: outgoing payment - Setting status to 'Sent' causes exception
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)]
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by aswath narayana <as...@gmail.com>.
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 <
jacques.le.roux@les7arts.com> wrote:
> Thanks Sumit,
>
> So its possible to have an outgoing pyament in cash ?
>
> Jacques
>
> From: "Sumit Pandit" <su...@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=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)]
>>
>
>
>
>
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks Sumit,
So its possible to have an outgoing pyament in cash ?
Jacques
From: "Sumit Pandit" <su...@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)]
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks for confirmation Scott,
Jacques
From: "Scott Gray" <sc...@hotwaxmedia.com>
> 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" <as...@gmail.com>
>>> 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
>>> <su...@hotwaxmedia.com>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)]
>>>>
>>>>
>>
>>
>
>
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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" <as...@gmail.com>
>> 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
>> <su...@hotwaxmedia.com>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)]
>>>
>>>
>
>
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <as...@gmail.com>
>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
> <su...@hotwaxmedia.com>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)]
>>
>>
>
Re: outgoing payment - Setting status to 'Sent' causes exception
Posted by aswath narayana <as...@gmail.com>.
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
<su...@hotwaxmedia.com>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)]
>
>