Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005933 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2008-11-12 12:34 | 2008-12-01 11:31 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 10356 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | 240 SMB | Database version | Ant version | |||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005933: error to create a new element in account schema general ledger | |||||||
| Description | In Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema || General Ledger, application don't work when you try create a new record, in new schema account. Application return error "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items" | |||||||
| Steps To Reproduce | Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema -> create a new registry -> OK Financial Management || Accounting || Setup || Account Tree || Element -> create a new element and new element value Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema || General Ledger -> select Income Summary and save, then error. | |||||||
| Proposed Solution | The problem is because the tab "general ledger" have the same column like parent column and key column. To solve this problem, you have create a new key column in C_ACCTSCHEMA_GL table | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0010201) rafaroda (developer) 2008-11-12 17:39 |
Please provide the required information about the version of Openbravo ERP, database, Operating system, etc... http://wiki.openbravo.com/wiki/Bug_Reporting_Guidelines [^] |
|
(0010236) rafaroda (developer) 2008-11-13 09:13 |
Error in Tomcat log when saving: 09:10:48 [http-8385-Processor23] ERROR org.openbravo.erpWindows.AccountingSchema.GeneralLedgerData - SQL error in query: INSERT INTO C_AcctSchema_GL (AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, IsActive, UseSuspenseBalancing, SuspenseBalancing_Acct, UseSuspenseError, SuspenseError_Acct, UseCurrencyBalancing, CurrencyBalancing_Acct, RetainedEarning_Acct, IncomeSummary_Acct, CFS_Order_Acct, IntercompanyDueTo_Acct, IntercompanyDueFrom_Acct, PPVOffset_Acct, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), (?), (?), TO_NUMBER(?), (?), TO_NUMBER(?), (?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "c_acctschema_gl" violates foreign key constraint "cacctschema_cacctschemagl" Detail: Key (c_acctschema_id)=(0) is not present in table "c_acctschema". |
|
(0010474) svnbot (reporter) 2008-11-20 20:40 |
Repository: openbravo Revision: 10356 Author: eduardoargal Date: 2008-11-20 20:38:12 +0100 (Thu, 20 Nov 2008) Fixes bug 0005933: error to create a new element in account schema general ledger (3 Hrs) --- U trunk/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql U trunk/src/org/openbravo/erpCommon/ad_forms/InitialOrgSetup_data.xsql U trunk/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql U trunk/src-db/database/model/tables/C_ACCTSCHEMA_GL.xml U trunk/src-db/database/sampledata/C_ACCTSCHEMA_GL.xml U trunk/src-db/database/sourcedata/AD_COLUMN.xml U trunk/src-db/database/sourcedata/AD_ELEMENT.xml U trunk/src-db/database/sourcedata/AD_FIELD.xml U trunk/src-db/database/sourcedata/AD_TABLE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=10356&sc=1 [^] |
|
(0010836) krishna (reporter) 2008-12-01 11:31 |
Tested in Windows/postgres and linux/oracle |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-12 12:34 | networkb | New Issue | |
| 2008-11-12 12:34 | networkb | Assigned To | => rafaroda |
| 2008-11-12 12:34 | networkb | sf_bug_id | 0 => 2268975 |
| 2008-11-12 12:34 | networkb | Regression testing | => No |
| 2008-11-12 17:39 | rafaroda | Note Added: 0010201 | |
| 2008-11-12 17:39 | rafaroda | Status | new => feedback |
| 2008-11-13 08:57 | networkb | OS | 5 => 30 |
| 2008-11-13 08:57 | networkb | version | => 2.40 |
| 2008-11-13 09:13 | rafaroda | Note Added: 0010236 | |
| 2008-11-13 09:28 | networkb | Proposed Solution updated | |
| 2008-11-13 09:28 | networkb | Steps to Reproduce Updated | |
| 2008-11-13 09:28 | networkb | Issue Monitored: networkb | |
| 2008-11-13 09:37 | rafaroda | Status | feedback => scheduled |
| 2008-11-13 09:37 | rafaroda | Assigned To | rafaroda => eduardo_Argal |
| 2008-11-13 09:37 | rafaroda | fix_in_branch | => trunk |
| 2008-11-13 10:25 | networkb | OS Version | => 240 SMB |
| 2008-11-13 10:25 | networkb | fix_in_branch | trunk => |
| 2008-11-20 20:40 | svnbot | Checkin | |
| 2008-11-20 20:40 | svnbot | Note Added: 0010474 | |
| 2008-11-20 20:40 | svnbot | Status | scheduled => resolved |
| 2008-11-20 20:40 | svnbot | Resolution | open => fixed |
| 2008-11-20 20:40 | svnbot | svn_revision | => 10356 |
| 2008-12-01 11:31 | krishna | Status | resolved => closed |
| 2008-12-01 11:31 | krishna | Note Added: 0010836 | |
| 2009-01-09 19:17 | rafaroda | Relationship added | has duplicate 0002664 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |