Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0021742 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | major | always | 2012-09-25 11:53 | 2012-09-28 14:39 | |||
Reporter | maite | View Status | public | |||||
Assigned To | dmiguelez | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 4b455cfbbff4 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Advanced Payables and Receivables Mngmt | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0021742: Problem when trying to process payment with "orig" data associated | |||||||
Description | In 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 Reproduce | 1. 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 Solution | Constraint "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; | |||||||
Tags | No 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 |