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 <[EMAIL PROTECTED]> 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. >> >> >> >>