Re: TIME PERIOD AND SETTLEMENT ISSUE IN ACCOUNTING.

[Jacopo Cappellato]

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