Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

[Jacopo Cappellato]

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.