[
http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449333 ]
Jacques Le Roux commented on OFBIZ-434:
---------------------------------------
The transaction was created without problem. After that I tried to fill fields
below and apply with "Create" button, I got :
The Following Errors Occurred:
* ERROR: Could not complete the Add Entry To AcctgTrans
[file:/D:/WorkspaceNew/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/AcctgTransServices.xml#createAcctgTransEntry]
process [problem creating the newEntity value: Exception while inserting the
following entity:
[GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00001(java.lang.String)][acctgTransId,10010(java.lang.String)][amount,10000.0(java.lang.Double)][createdStamp,2006-11-13
12:48:49.968(java.sql.Timestamp)][createdTxStamp,2006-11-13
12:48:49.921(java.sql.Timestamp)][debitCreditFlag,C(java.lang.String)][description,test(java.lang.String)][glAccountId,100000(java.lang.String)][isSummary,null()][lastUpdatedStamp,2006-11-13
12:48:49.968(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-13
12:48:49.921(java.sql.Timestamp)][organizationPartyId,SALES(java.lang.String)][partyId,admin(java.lang.String)][productId,11111111(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,null()][voucherRef,null()]
(while inserting:
[GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00001(java.lang.String)][acctgTransId,10010(java.lang.String)][amount,10000.0(java.lang.Double)][createdStamp,2006-11-13
12:48:49.968(java.sql.Timestamp)][createdTxStamp,2006-11-13
12:48:49.921(java.sql.Timestamp)][debitCreditFlag,C(java.lang.String)][description,test(java.lang.String)][glAccountId,100000(java.lang.String)][isSummary,null()][lastUpdatedStamp,2006-11-13
12:48:49.968(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-13
12:48:49.921(java.sql.Timestamp)][organizationPartyId,SALES(java.lang.String)][partyId,admin(java.lang.String)][productId,11111111(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][settlementTermId,null()][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_ID,
ORGANIZATION_PARTY_ID, AMOUNT, CURRENCY_UOM_ID, ORIG_AMOUNT, 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 sur la table 'ACCTG_TRANS_ENTRY' a entraîné la
violation de la contrainte de clé externe 'ACCTTXENT_GLACOG' pour la clé
(100000,SALES). L'instruction a été annulée.)))]
Sorry you may find fields values I used in the error above beause Jira is no
longer taking screen shoots from me :(
That's pretty annoying BTW, I think I will create a Jira issue about this Jira
pb but where to put it, somebody an idea ?
Thanks
> Screen for entering and updating accounting transactions
> --------------------------------------------------------
>
> Key: OFBIZ-434
> URL: http://issues.apache.org/jira/browse/OFBIZ-434
> Project: OFBiz (The Open for Business Project)
> Issue Type: Improvement
> Components: accounting
> Reporter: Eriks Dobelis
> Attachments: acctgTrans.diff
>
>
> This patch allows manual creating and editing accounting transactions.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
