outgoing payment - Setting status to 'Sent' causes exception

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

outgoing payment - Setting status to 'Sent' causes exception

aswath narayana
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)]
Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

Sumit Pandit-3
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)]

Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

Jacques Le Roux
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)]



Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

aswath narayana
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)]
>
>
Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

aswath narayana
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)]
>>
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

Jacques Le Roux
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)]
>>
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

Scott Gray-2
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
Reply | Threaded
Open this post in threaded view
|

Re: outgoing payment - Setting status to 'Sent' causes exception

Jacques Le Roux
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)]
>>>>
>>>>
>>
>>
>
>