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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021742
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-09-25 11:532012-09-28 14:39
ReportermaiteView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision4b455cfbbff4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021742: Problem when trying to process payment with "orig" data associated

DescriptionIn previous versions, "fin_orig_payment_schedule" and "fin_orig_paym_scheddetail" tables were populated at same time that fin_payment_schedule and fin_payment_scheduledetail tables. Currently, when trying to delete data from fin_payment_schedule and fin_payment_scheduledetail error is obtained as "orig" tables are referencing that records
Steps To Reproduce1. Create Payment In associated to any invoice, ensuring that "orig" tables are populated
2. Reactive Payment In, uncheck "invoice" detail and try to process payment to generate credit
3. Constraint error will be obtained
Proposed SolutionConstraint "fin_orig_paym_origscheddetail" should be modified as follows:
ALTER TABLE fin_orig_paym_scheddetail
  ADD CONSTRAINT fin_payment_origscheddetail FOREIGN KEY (fin_payment_scheduledetail_id)
      REFERENCES fin_payment_scheduledetail (fin_payment_scheduledetail_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE;
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0052834)
hgbot (developer)
2012-09-27 13:57

 Repository: erp/devel/pi
Changeset: 4b455cfbbff452f58ee6c944a6d580aec1d3a835
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Sep 25 17:49:31 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4b455cfbbff452f58ee6c944a6d580aec1d3a835 [^]

Fixes issue 21742: FIN_orig_payment_schedule and FIN_orig_paym_scheddetail
tables are deprecated. All foreign keys should be ON DELETE CASCADE.
There should not be Link to Parent columns.

---
M src-db/database/model/tables/FIN_ORIG_PAYMENT_SCHEDULE.xml
M src-db/database/model/tables/FIN_ORIG_PAYM_SCHEDDETAIL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0052838)
maite (developer)
2012-09-27 15:51

 verified
(0052921)
hudsonbot (developer)
2012-09-28 14:39

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6d2f8cffd4b1 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-09-25 11:53 maite New Issue
2012-09-25 11:53 maite Assigned To => dmiguelez
2012-09-25 11:53 maite Modules => Advanced Payables and Receivables Mngmt
2012-09-25 11:58 maite Issue Monitored: networkb
2012-09-26 09:01 jonalegriaesarte Assigned To dmiguelez => ioritzCia
2012-09-26 13:53 jonalegriaesarte Assigned To ioritzCia => dmiguelez
2012-09-26 16:48 dmiguelez Status new => scheduled
2012-09-26 16:48 dmiguelez fix_in_branch => pi
2012-09-27 13:57 hgbot Checkin
2012-09-27 13:57 hgbot Note Added: 0052834
2012-09-27 13:57 hgbot Status scheduled => resolved
2012-09-27 13:57 hgbot Resolution open => fixed
2012-09-27 13:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b455cfbbff452f58ee6c944a6d580aec1d3a835 [^]
2012-09-27 15:51 maite Note Added: 0052838
2012-09-27 15:51 maite Status resolved => closed
2012-09-28 14:39 hudsonbot Checkin
2012-09-28 14:39 hudsonbot Note Added: 0052921

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker