Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007540Openbravo ERP09. Financial managementpublic2009-02-12 17:022009-04-22 00:00
Reportershuehner 
Assigned Toeduardo_Argal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007540: CreateCashFlowStatement does try to insert record with non-existant fk
DescriptionThe CreateCashFlowStatement does call insertStatements-method with hardcoded fact_acct_ref_id = "0". As this field in the fact_acct_cfs table is not null and has a foreign-key constraint to the fact_acct table. So the insert fails with a FK violation.
Steps To Reproduce1.) Setup a report in the user defined accounting report setup windows
2.) Start the Create Cash Flow statement process
3.) if you have a fact_acct entry with (ad_table_id 392 or 407) and record_id2 = '' the process from step 2.) fails
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-12 17:02shuehnerNew Issue
2009-02-12 17:02shuehnerAssigned To => eduardo_Argal
2009-02-12 17:02shuehnerOBNetwork customer => No
2009-02-12 17:02shuehnerRegression testing => No
2009-02-16 17:23svnbotCheckin
2009-02-16 17:23svnbotNote Added: 0013539
2009-02-16 17:23svnbotStatusnew => resolved
2009-02-16 17:23svnbotResolutionopen => fixed
2009-02-16 17:23svnbotsvn_revision => 13240
2009-02-16 17:31svnbotCheckin
2009-02-16 17:31svnbotNote Added: 0013540
2009-02-16 17:31svnbotsvn_revision13240 => 13241
2009-04-21 10:54psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777932

Notes
(0013539)
svnbot   
2009-02-16 17:23   
Repository: openbravo
Revision: 13240
Author: eduardoargal
Date: 2009-02-16 17:23:15 +0100 (Mon, 16 Feb 2009)

Fixes bug 0007540: CreateCashFlowStatement does try to insert record with non-existant fk

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=13240&sc=1 [^]
(0013540)
svnbot   
2009-02-16 17:31   
Repository: openbravo
Revision: 13241
Author: eduardoargal
Date: 2009-02-16 17:31:17 +0100 (Mon, 16 Feb 2009)

Fixes bug 0007540: CreateCashFlowStatement does try to insert record with non-existant fk. DataBase changes missing in las commit. Sorrysvn status

---
U trunk/src-db/database/model/tables/FACT_ACCT_CFS.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13241&sc=1 [^]