Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007540
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2009-02-12 17:022009-04-22 00:00
ReportershuehnerView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version2.50beta
StatusclosedFix in branchFixed in SCM revision13241
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007540: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0013539)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2009-02-12 17:02 shuehner New Issue
2009-02-12 17:02 shuehner Assigned To => eduardo_Argal
2009-02-12 17:02 shuehner Regression testing => No
2009-02-16 17:23 svnbot Checkin
2009-02-16 17:23 svnbot Note Added: 0013539
2009-02-16 17:23 svnbot Status new => resolved
2009-02-16 17:23 svnbot Resolution open => fixed
2009-02-16 17:23 svnbot svn_revision => 13240
2009-02-16 17:31 svnbot Checkin
2009-02-16 17:31 svnbot Note Added: 0013540
2009-02-16 17:31 svnbot svn_revision 13240 => 13241
2009-04-21 10:54 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777932


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker