[jira] Created: (OFBIZ-434) Screen for entering and updating accounting transactions
Locked
[jira] Created: (OFBIZ-434) Screen for entering and updating accounting transactions
 
|
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 |
[jira] Updated: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Eriks Dobelis updated OFBIZ-434: -------------------------------- Attachment: acctgTrans.diff > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12447818 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- To test the functionality go to Accounting/Companies/Admin/Manual Transaction Posting > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12448297 ]
Si Chen commented on OFBIZ-434: ------------------------------- Did you test your own patch? This can't be correct-- - <set value="INTERNAL_ORGANIZATIO" field="lookupParams.roleTypeId"/> + <set value="INTERNAL_ORGANIZATION" field="lookupParams.roleTypeId"/> because the RoleType is actually INTERNAL_ORGANIZATIO for field length reasons. > 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 |
[jira] Updated: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Eriks Dobelis updated OFBIZ-434: -------------------------------- Attachment: acctgTrans.diff > 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, 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12448495 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- Yes I have tested it for standard cases. The line you are refering to was in the patch by accident and is not related to editing accounting transactions. I removed it and uploaded correct version of the patch. > 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, 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12448986 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- Si, have you had a look into patch? Maybe somebody else could have a look? > 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, 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 |
[jira] Updated: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Jacques Le Roux updated OFBIZ-434: ---------------------------------- Attachment: (was: acctgTrans.diff) > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449166 ]
Jacques Le Roux commented on OFBIZ-434: --------------------------------------- Eriks, I just did a very fast test. I got this trying to create a new accounting transaction 2006-11-12 19:41:12,687 (http-0.0.0.0-8443-Processor2) [ Log4JLoggerFactory.java:96 :ERROR] Expression organizationPartyId is undefined on line 20, column 125 in AdminTabBar.ftl. The problematic instruction: ---------- ==> ${organizationPartyId} [on line 20, column 123 in AdminTabBar.ftl] ---------- Does this means that Financials GPL module is needed and that a company must be chosen there ? BTW the transaction was created and I was able to post it. I did not verify if the posting was good. > 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 |
[jira] Updated: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Eriks Dobelis updated OFBIZ-434: -------------------------------- Attachment: acctgTrans.diff > 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, 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449314 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- This patch is not relying on Financials module in any way. It shouldn't conflict with it either. I have uploaded an updated patch which should fix your issue. The transaction created should be fine. organizationPartyId is needed by CommonAdminDecorator to display the company name and keep organizationPartyId in URL, so that all activities in Accounting/Companies/Admin are performed with specific Organization as a default. I think that passing it through URL all the time is not the best way for that and I think that this should be dealt with similarly to the active language, so that once you choose the language it is active until you choose another language. The same could be done with organizationPartyId where user could "login" or choose organizationPartyId and all the activities would take it as default organizationPartyId, or in some cases data related not related to this organizationPartyId could be hidden. Some of the uses would be related to issue OFBIZ-118 . > 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, 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 |
[jira] Updated: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Jacques Le Roux updated OFBIZ-434: ---------------------------------- Attachment: (was: acctgTrans.diff) > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449336 ]
Jacques Le Roux commented on OFBIZ-434: --------------------------------------- I just read OFBIZ-118 and I agree, your idea seems very interesting. Waiting for other opinions... > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449427 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- Jacques, this error is because you have not assigned account 100000 to SALES party. You can assign accounts to organizations at /accounting/control/AssignGlAccount > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449605 ]
Jacques Le Roux commented on OFBIZ-434: --------------------------------------- Thanks for the tip, It works perfectly. I just wonder if a better error message could not be used for the error above. I'm ok for commit it but will wait Si's opinion if you don't mind. > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12449612 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- Later, if we implement selection of organizational context (OFBIZ-455), then display of accounts could be limited to the active organizational party which would eliminate problem with unassigned account numbers. Let's wait for Si's opinion. > 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 |
[jira] Assigned: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=all ]
Si Chen reassigned OFBIZ-434: ----------------------------- Assignee: Si Chen > 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 > Assigned To: Si Chen > 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 |
[jira] Commented: (OFBIZ-434) Screen for entering and updating accounting transactions
|
|
In reply to this post by Nicolas Malin (Jira)
[ http://issues.apache.org/jira/browse/OFBIZ-434?page=comments#action_12458390 ]
Eriks Dobelis commented on OFBIZ-434: ------------------------------------- Si, will you give opinion on this one? It's been 1.5 months since your last comment. > 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 > Assigned To: Si Chen > 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 |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |