OFBiz › OFBiz - User

TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

11 messages Options

brijesh m

TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

I have configured the accounting quite well but still facing two
problems

a.) can't able to close any of the existing or newly formed TIME
PERIOD as it shows following error:
The Following Errors Occurred:Error running the
simple-method: Error in simple-method operation []: java.lang.RuntimeException:
Error in simple-method operation []: java.lang.NumberFormatException:
For input string: "0-1"
null

b.) can't understand the concept of SETTLEMENT in the ADD
TRANSACTION ENTRIES for the unposted transaction as it
shows error presently as:
The Following Errors Occurred:
ERROR: Could not complete the Add Entry To AcctgTrans
[file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
process [problem creating the newEntity value: Error while inserting:

[GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30

21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
(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_STLEN' for key (4). The
statement has been rolled back.))]

kindly help as i think many among us have faced this similar problem.

Thanks
Brijesh M.

ankurgupta3056

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

Hi Brijesh

You need to put Settlement Id in Settlement tex box but i dont know how it
is functioning.Somebody please tell what is its function and how to resolve
it...I am also facing this problem

Regards,
Ankur

On Mon, Jun 30, 2008 at 11:31 PM, brijesh m <[hidden email]> wrote:

>
> I have configured the accounting quite well but still facing two
> problems
>
> a.) can't able to close any of the existing or newly formed TIME
> PERIOD as it shows following error:
> The Following Errors Occurred:Error running the
> simple-method: Error in simple-method operation []:
> java.lang.RuntimeException:
> Error in simple-method operation []: java.lang.NumberFormatException:
> For input string: "0-1"
> null
>
>
>
> b.) can't understand the concept of SETTLEMENT in the ADD
> TRANSACTION ENTRIES for the unposted transaction as it
> shows error presently as:
> The Following Errors Occurred:
> ERROR: Could not complete the Add Entry To AcctgTrans
>
> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
> process [problem creating the newEntity value: Error while inserting:
>
>
> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>
> 21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>
>
> 21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
> (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_STLEN' for key (4). The
> statement has been rolled back.))]
>
>
>
> kindly help as i think many among us have faced this similar problem.
>
> Thanks
> Brijesh M.
>
>

ankur gupta-11

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

In reply to this post by brijesh m

Hi Brijesh

This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody give the
solution for this.

Regards,
Ankur

> I have configured the accounting quite well but still facing two
> problems
>
> a.) can't able to close any of the existing or newly formed TIME
> PERIOD as it shows following error:
> The Following Errors Occurred:Error running the
> simple-method: Error in simple-method operation []:
> java.lang.RuntimeException:
> Error in simple-method operation []: java.lang.NumberFormatException:
> For input string: "0-1"
> null
>
>
>
> b.) can't understand the concept of SETTLEMENT in the ADD
> TRANSACTION ENTRIES for the unposted transaction as it
> shows error presently as:
> The Following Errors Occurred:
> ERROR: Could not complete the Add Entry To AcctgTrans
>
> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
> process [problem creating the newEntity value: Error while inserting:
>
>
> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>
> 21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>
>
> 21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
> (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_STLEN' for key (4). The
> statement has been rolled back.))]
>
>
>
> kindly help as i think many among us have faced this similar problem.
>
> Thanks
> Brijesh M.
>
>
>
>

Jacopo Cappellato-3

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

Could you please send me the direct link to the demo server?
I would like to test it.

Thanks,

Jacopo

On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:

> Hi Brijesh
>
> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody
> give the
> solution for this.
>
> Regards,
> Ankur
>
>
>
>> I have configured the accounting quite well but still facing two
>> problems
>>
>> a.) can't able to close any of the existing or newly formed TIME
>> PERIOD as it shows following error:
>> The Following Errors Occurred:Error running the
>> simple-method: Error in simple-method operation []:
>> java.lang.RuntimeException:
>> Error in simple-method operation []: java.lang.NumberFormatException:
>> For input string: "0-1"
>> null
>>
>>
>>
>> b.) can't understand the concept of SETTLEMENT in the ADD
>> TRANSACTION ENTRIES for the unposted transaction as it
>> shows error presently as:
>> The Following Errors Occurred:
>> ERROR: Could not complete the Add Entry To AcctgTrans
>>
>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/
>> ledger/AcctgTransServices.xml#createAcctgTransEntry]
>> process [problem creating the newEntity value: Error while inserting:
>>
>>
>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,
>> 00005(java.lang.String)]
>> [acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,
>> 10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,
>> 2008-06-30
>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>
>> 21:42:31.75(java.sql.Timestamp)]
>> [currencyUomId,USD(java.lang.String)]
>> [debitCreditFlag,C(java.lang.String)][description,null()]
>> [glAccountId,421000(java.lang.String)]
>> [glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)]
>> [isSummary,null()][lastUpdatedStamp,2008-06-30
>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>
>>
>> 21:42:31.75(java.sql.Timestamp)]
>> [organizationPartyId,Company(java.lang.String)][origAmount,
>> 5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)]
>> [partyId,null()][productId,null()]
>> [reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)]
>> [settlementTermId,4(java.lang.String)][voucherRef,null()]
>> (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_STLEN' for key (4).
>> The
>> statement has been rolled back.))]
>>
>>
>>
>> kindly help as i think many among us have faced this similar problem.
>>
>> Thanks
>> Brijesh M.
>>
>>
>>
>>

Adrian Crum

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

https://localhost:8443/accounting/control/closeFinancialTimePeriod?organizationPartyId=Company&customTimePeriodId=6001

I'm checking into it also. There seems to be a problem with the
set-calendar operation.

-Adrian

Jacopo Cappellato wrote:

> Could you please send me the direct link to the demo server?
> I would like to test it.
>
> Thanks,
>
> Jacopo
>
> On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:
>
>> Hi Brijesh
>>
>> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody give
>> the
>> solution for this.
>>
>> Regards,
>> Ankur
>>
>>
>>
>>> I have configured the accounting quite well but still facing two
>>> problems
>>>
>>> a.) can't able to close any of the existing or newly formed TIME
>>> PERIOD as it shows following error:
>>> The Following Errors Occurred:Error running the
>>> simple-method: Error in simple-method operation []:
>>> java.lang.RuntimeException:
>>> Error in simple-method operation []: java.lang.NumberFormatException:
>>> For input string: "0-1"
>>> null
>>>
>>>
>>>
>>> b.) can't understand the concept of SETTLEMENT in the ADD
>>> TRANSACTION ENTRIES for the unposted transaction as it
>>> shows error presently as:
>>> The Following Errors Occurred:
>>> ERROR: Could not complete the Add Entry To AcctgTrans
>>>
>>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
>>>
>>> process [problem creating the newEntity value: Error while inserting:
>>>
>>>
>>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
>>>
>>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>>
>>> 21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
>>>
>>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>>
>>>
>>> 21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
>>>
>>> (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_STLEN' for key (4). The
>>> statement has been rolled back.))]
>>>
>>>
>>>
>>> kindly help as i think many among us have faced this similar problem.
>>>
>>> Thanks
>>> Brijesh M.
>>>
>>>
>>>
>>>
>
>

ankur gupta-11

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

In reply to this post by Jacopo Cappellato-3

Hi jacopo

this is the link for demo server...

https://demo.hotwaxmedia.com/accounting/control/main

pls reply asap.

Ankur

On Tue, Jul 1, 2008 at 9:21 PM, Jacopo Cappellato <
[hidden email]> wrote:

> Could you please send me the direct link to the demo server?
> I would like to test it.
>
> Thanks,
>
> Jacopo
>
>
> On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:
>
> Hi Brijesh
>>
>> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody give the
>> solution for this.
>>
>> Regards,
>> Ankur
>>
>>
>>
>> I have configured the accounting quite well but still facing two
>>> problems
>>>
>>> a.) can't able to close any of the existing or newly formed TIME
>>> PERIOD as it shows following error:
>>> The Following Errors Occurred:Error running the
>>> simple-method: Error in simple-method operation []:
>>> java.lang.RuntimeException:
>>> Error in simple-method operation []: java.lang.NumberFormatException:
>>> For input string: "0-1"
>>> null
>>>
>>>
>>>
>>> b.) can't understand the concept of SETTLEMENT in the ADD
>>> TRANSACTION ENTRIES for the unposted transaction as it
>>> shows error presently as:
>>> The Following Errors Occurred:
>>> ERROR: Could not complete the Add Entry To AcctgTrans
>>>
>>>
>>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
>>> process [problem creating the newEntity value: Error while inserting:
>>>
>>>
>>>
>>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
>>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>>
>>>
>>> 21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
>>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>>
>>>
>>>
>>> 21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
>>> (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_STLEN' for key (4). The
>>> statement has been rolled back.))]
>>>
>>>
>>>
>>> kindly help as i think many among us have faced this similar problem.
>>>
>>> Thanks
>>> Brijesh M.
>>>
>>>
>>>
>>>
>>>
>

brijesh m

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

In reply to this post by Jacopo Cappellato-3

Below is the link for the demo server, error also persist here although i have also checked the debit/credit balance for different time periods and they are balanced also but still can't be able to close the time period.

https://demo.hotwaxmedia.com/accounting/control/TimePeriods?organizationPartyId=Company

thanks for your concern i am somewhat getting restless over this error as it is getting me involved for the last two days.

thanks
Brijesh M.
Jacopo Cappellato <[hidden email]> wrote: Could you please send me the direct link to the demo server?
I would like to test it.

Thanks,

Jacopo

On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:

Adrian Crum

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

In reply to this post by Adrian Crum

I fixed the set-calendar operation in rev 673129, but now there seems to
be another problem - having to do with a GL account ID not being set.

-Adrian

Adrian Crum wrote:

> https://localhost:8443/accounting/control/closeFinancialTimePeriod?organizationPartyId=Company&customTimePeriodId=6001
>
>
> I'm checking into it also. There seems to be a problem with the
> set-calendar operation.
>
> -Adrian
>
> Jacopo Cappellato wrote:
>> Could you please send me the direct link to the demo server?
>> I would like to test it.
>>
>> Thanks,
>>
>> Jacopo
>>
>> On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:
>>
>>> Hi Brijesh
>>>
>>> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody
>>> give the
>>> solution for this.
>>>
>>> Regards,
>>> Ankur
>>>
>>>
>>>
>>>> I have configured the accounting quite well but still facing two
>>>> problems
>>>>
>>>> a.) can't able to close any of the existing or newly formed TIME
>>>> PERIOD as it shows following error:
>>>> The Following Errors Occurred:Error running the
>>>> simple-method: Error in simple-method operation []:
>>>> java.lang.RuntimeException:
>>>> Error in simple-method operation []: java.lang.NumberFormatException:
>>>> For input string: "0-1"
>>>> null
>>>>
>>>>
>>>>
>>>> b.) can't understand the concept of SETTLEMENT in the ADD
>>>> TRANSACTION ENTRIES for the unposted transaction as it
>>>> shows error presently as:
>>>> The Following Errors Occurred:
>>>> ERROR: Could not complete the Add Entry To AcctgTrans
>>>>
>>>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
>>>>
>>>> process [problem creating the newEntity value: Error while inserting:
>>>>
>>>>
>>>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00005(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10316(java.lang.String)][amount,5.0(java.lang.Double)][createdStamp,2008-06-30
>>>>
>>>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>>>
>>>> 21:42:31.75(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][description,null()][glAccountId,421000(java.lang.String)][glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)][isSummary,null()][lastUpdatedStamp,2008-06-30
>>>>
>>>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>>>
>>>>
>>>> 21:42:31.75(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,null()][productId,null()][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,4(java.lang.String)][voucherRef,null()]
>>>>
>>>> (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_STLEN' for key (4). The
>>>> statement has been rolled back.))]
>>>>
>>>>
>>>>
>>>> kindly help as i think many among us have faced this similar problem.
>>>>
>>>> Thanks
>>>> Brijesh M.
>>>>
>>>>
>>>>
>>>>
>>
>>
>

Jacopo Cappellato-3

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

After Adrian's fix I was able to close the time period.

Jacopo

On Jul 1, 2008, at 6:28 PM, Adrian Crum wrote:

> I fixed the set-calendar operation in rev 673129, but now there
> seems to be another problem - having to do with a GL account ID not
> being set.
>
> -Adrian
>
> Adrian Crum wrote:
>> https://localhost:8443/accounting/control/closeFinancialTimePeriod?organizationPartyId=Company&customTimePeriodId=6001
>> I'm checking into it also. There seems to be a problem with the
>> set-calendar operation.
>> -Adrian
>> Jacopo Cappellato wrote:
>>> Could you please send me the direct link to the demo server?
>>> I would like to test it.
>>>
>>> Thanks,
>>>
>>> Jacopo
>>>
>>> On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:
>>>
>>>> Hi Brijesh
>>>>
>>>> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody
>>>> give the
>>>> solution for this.
>>>>
>>>> Regards,
>>>> Ankur
>>>>
>>>>
>>>>
>>>>> I have configured the accounting quite well but still facing two
>>>>> problems
>>>>>
>>>>> a.) can't able to close any of the existing or newly formed TIME
>>>>> PERIOD as it shows following error:
>>>>> The Following Errors Occurred:Error running the
>>>>> simple-method: Error in simple-method operation []:
>>>>> java.lang.RuntimeException:
>>>>> Error in simple-method operation []:
>>>>> java.lang.NumberFormatException:
>>>>> For input string: "0-1"
>>>>> null
>>>>>
>>>>>
>>>>>
>>>>> b.) can't understand the concept of SETTLEMENT in the ADD
>>>>> TRANSACTION ENTRIES for the unposted transaction as it
>>>>> shows error presently as:
>>>>> The Following Errors Occurred:
>>>>> ERROR: Could not complete the Add Entry To AcctgTrans
>>>>>
>>>>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/
>>>>> accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
>>>>> process [problem creating the newEntity value: Error while
>>>>> inserting:
>>>>>
>>>>>
>>>>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,
>>>>> 00005(java.lang.String)]
>>>>> [acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,
>>>>> 10316(java.lang.String)][amount,5.0(java.lang.Double)]
>>>>> [createdStamp,2008-06-30
>>>>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>>>>
>>>>> 21:42:31.75(java.sql.Timestamp)]
>>>>> [currencyUomId,USD(java.lang.String)]
>>>>> [debitCreditFlag,C(java.lang.String)][description,null()]
>>>>> [glAccountId,421000(java.lang.String)]
>>>>> [glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)]
>>>>> [isSummary,null()][lastUpdatedStamp,2008-06-30
>>>>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>>>>
>>>>>
>>>>> 21:42:31.75(java.sql.Timestamp)]
>>>>> [organizationPartyId,Company(java.lang.String)][origAmount,
>>>>> 5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)]
>>>>> [partyId,null()][productId,null()]
>>>>> [reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)]
>>>>> [settlementTermId,4(java.lang.String)][voucherRef,null()]
>>>>> (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_STLEN' for key
>>>>> (4). The
>>>>> statement has been rolled back.))]
>>>>>
>>>>>
>>>>>
>>>>> kindly help as i think many among us have faced this similar
>>>>> problem.
>>>>>
>>>>> Thanks
>>>>> Brijesh M.
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>

brijesh m

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

Hi friends,
Time Period problem solved but not sure about the Settlement in accounting transaction as it only works if given COD,net_15,net_60,net_90 as input which was retrived from the webtools after SQL query processing. So, is it really not supported presently as suggested by Jacopo or it is working as I mentioned with the above inputs only somebody kindly confirm.

Thanks
Brijesh M.
Jacopo Cappellato <[hidden email]> wrote: After Adrian's fix I was able to close the time period.

Jacopo

On Jul 1, 2008, at 6:28 PM, Adrian Crum wrote:

Jacopo Cappellato-3

Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

Since there is no user interface (apart from the generic ones provided
by the Webtools application), you have to use the Webtools to add new
SettlementTerm entries; then you can use them in the AcctgTrans. If
you set in the "settlement term id" field a value that is not in the
SettlementTerm entity, then you get the error you have reported
(foreign key exception).
However I can confirm that there is no other code in OFBiz that uses
this entity; payment terms in OFBiz are implemented using the
AgreementTerm, OrderTerm, InvoiceTerm entities.

Jacopo

On Jul 2, 2008, at 3:17 PM, brijesh m wrote:

> Hi friends,
> Time Period problem solved but not sure about the Settlement in
> accounting transaction as it only works if given
> COD,net_15,net_60,net_90 as input which was retrived from the
> webtools after SQL query processing. So, is it really not supported
> presently as suggested by Jacopo or it is working as I mentioned
> with the above inputs only somebody kindly confirm.
>
>
> Thanks
> Brijesh M.
> Jacopo Cappellato <[hidden email]> wrote: After
> Adrian's fix I was able to close the time period.
>
> Jacopo
>
> On Jul 1, 2008, at 6:28 PM, Adrian Crum wrote:
>
>> I fixed the set-calendar operation in rev 673129, but now there
>> seems to be another problem - having to do with a GL account ID not
>> being set.
>>
>> -Adrian
>>
>> Adrian Crum wrote:
>>> https://localhost:8443/accounting/control/closeFinancialTimePeriod?organizationPartyId=Company&customTimePeriodId=6001
>>> I'm checking into it also. There seems to be a problem with the
>>> set-calendar operation.
>>> -Adrian
>>> Jacopo Cappellato wrote:
>>>> Could you please send me the direct link to the demo server?
>>>> I would like to test it.
>>>>
>>>> Thanks,
>>>>
>>>> Jacopo
>>>>
>>>> On Jul 1, 2008, at 5:48 PM, ankur gupta wrote:
>>>>
>>>>> Hi Brijesh
>>>>>
>>>>> This TIME PERIOD error also exist in DEMO server of ofbiz.Anybody
>>>>> give the
>>>>> solution for this.
>>>>>
>>>>> Regards,
>>>>> Ankur
>>>>>
>>>>>
>>>>>
>>>>>> I have configured the accounting quite well but still facing two
>>>>>> problems
>>>>>>
>>>>>> a.) can't able to close any of the existing or newly formed TIME
>>>>>> PERIOD as it shows following error:
>>>>>> The Following Errors Occurred:Error running the
>>>>>> simple-method: Error in simple-method operation []:
>>>>>> java.lang.RuntimeException:
>>>>>> Error in simple-method operation []:
>>>>>> java.lang.NumberFormatException:
>>>>>> For input string: "0-1"
>>>>>> null
>>>>>>
>>>>>>
>>>>>>
>>>>>> b.) can't understand the concept of SETTLEMENT in the ADD
>>>>>> TRANSACTION ENTRIES for the unposted transaction as it
>>>>>> shows error presently as:
>>>>>> The Following Errors Occurred:
>>>>>> ERROR: Could not complete the Add Entry To AcctgTrans
>>>>>>
>>>>>> [file:/D:/ofbiz/applications/accounting/script/org/ofbiz/
>>>>>> accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
>>>>>> process [problem creating the newEntity value: Error while
>>>>>> inserting:
>>>>>>
>>>>>>
>>>>>> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,
>>>>>> 00005(java.lang.String)]
>>>>>> [acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,
>>>>>> 10316(java.lang.String)][amount,5.0(java.lang.Double)]
>>>>>> [createdStamp,2008-06-30
>>>>>> 21:42:31.953(java.sql.Timestamp)][createdTxStamp,2008-06-30
>>>>>>
>>>>>> 21:42:31.75(java.sql.Timestamp)]
>>>>>> [currencyUomId,USD(java.lang.String)]
>>>>>> [debitCreditFlag,C(java.lang.String)][description,null()]
>>>>>> [glAccountId,421000(java.lang.String)]
>>>>>> [glAccountTypeId,ACCOUNTS_RECEIVABLE(java.lang.String)]
>>>>>> [isSummary,null()][lastUpdatedStamp,2008-06-30
>>>>>> 21:42:31.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-06-30
>>>>>>
>>>>>>
>>>>>> 21:42:31.75(java.sql.Timestamp)]
>>>>>> [organizationPartyId,Company(java.lang.String)][origAmount,
>>>>>> 5.0(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)]
>>>>>> [partyId,null()][productId,null()]
>>>>>> [reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)]
>>>>>> [settlementTermId,4(java.lang.String)][voucherRef,null()]
>>>>>> (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_STLEN' for key
>>>>>> (4). The
>>>>>> statement has been rolled back.))]
>>>>>>
>>>>>>
>>>>>>
>>>>>> kindly help as i think many among us have faced this similar
>>>>>> problem.
>>>>>>
>>>>>> Thanks
>>>>>> Brijesh M.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>
>
>