Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005933Openbravo ERP09. Financial managementpublic2008-11-12 12:342008-12-01 11:31
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version240 SMB
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005933: error to create a new element in account schema general ledger
DescriptionIn 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 ReproduceFinancial 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 SolutionThe 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
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0005944 closed eduardo_Argal error to create a new element in account schema general ledger 
has duplicate defect 00026642.40 closed iperdomo QA-MAS General ledger Tab error inserting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-12 12:34networkbNew Issue
2008-11-12 12:34networkbAssigned To => rafaroda
2008-11-12 12:34networkbsf_bug_id0 => 2268975
2008-11-12 12:34networkbRegression testing => No
2008-11-12 17:39rafarodaNote Added: 0010201
2008-11-12 17:39rafarodaStatusnew => feedback
2008-11-13 08:57networkbOS5 => 30
2008-11-13 08:57networkbversion => 2.40
2008-11-13 09:13rafarodaNote Added: 0010236
2008-11-13 09:28networkbProposed Solution updated
2008-11-13 09:28networkbSteps to Reproduce Updated
2008-11-13 09:28networkbIssue Monitored: networkb
2008-11-13 09:37rafarodaStatusfeedback => scheduled
2008-11-13 09:37rafarodaAssigned Torafaroda => eduardo_Argal
2008-11-13 09:37rafarodafix_in_branch => trunk
2008-11-13 10:25networkbOS Version => 240 SMB
2008-11-13 10:25networkbfix_in_branchtrunk =>
2008-11-20 20:40svnbotCheckin
2008-11-20 20:40svnbotNote Added: 0010474
2008-11-20 20:40svnbotStatusscheduled => resolved
2008-11-20 20:40svnbotResolutionopen => fixed
2008-11-20 20:40svnbotsvn_revision => 10356
2008-12-01 11:31krishnaStatusresolved => closed
2008-12-01 11:31krishnaNote Added: 0010836
2009-01-09 19:17rafarodaRelationship addedhas duplicate 0002664

Notes
(0010201)
rafaroda   
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   
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   
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   
2008-12-01 11:31   
Tested in Windows/postgres and linux/oracle