You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by brijesh m <br...@yahoo.com> on 2008/07/01 08:31:55 UTC
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.
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by ANKUR GUPTA <an...@gmail.com>.
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 <br...@yahoo.com> 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.
>
>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by ankur gupta <an...@gmail.com>.
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 <
jacopo.cappellato@gmail.com> 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.
>>>
>>>
>>>
>>>
>>>
>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by Jacopo Cappellato <ja...@gmail.com>.
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 <ja...@gmail.com> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>
>
>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by brijesh m <br...@yahoo.com>.
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 <ja...@gmail.com> 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.
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by Jacopo Cappellato <ja...@gmail.com>.
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.
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by Adrian Crum <ad...@hlmksw.com>.
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.
>>>>
>>>>
>>>>
>>>>
>>
>>
>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by Adrian Crum <ad...@hlmksw.com>.
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.
>>>
>>>
>>>
>>>
>
>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by brijesh m <br...@yahoo.com>.
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 <ja...@gmail.com> 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.
>>
>>
>>
>>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by Jacopo Cappellato <ja...@gmail.com>.
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.
>>
>>
>>
>>
Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.
Posted by ankur gupta <an...@gmail.com>.
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.
>
>
>
>