Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021742Openbravo ERP09. Financial managementpublic2012-09-25 11:532012-09-28 14:39
Reportermaite 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021742: 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;
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-25 11:53maiteNew Issue
2012-09-25 11:53maiteAssigned To => dmiguelez
2012-09-25 11:53maiteModules => Advanced Payables and Receivables Mngmt
2012-09-25 11:58maiteIssue Monitored: networkb
2012-09-26 09:01jonalegriaesarteAssigned Todmiguelez => ioritzCia
2012-09-26 13:53jonalegriaesarteAssigned ToioritzCia => dmiguelez
2012-09-26 16:48dmiguelezStatusnew => scheduled
2012-09-26 16:48dmiguelezfix_in_branch => pi
2012-09-27 13:57hgbotCheckin
2012-09-27 13:57hgbotNote Added: 0052834
2012-09-27 13:57hgbotStatusscheduled => resolved
2012-09-27 13:57hgbotResolutionopen => fixed
2012-09-27 13:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b455cfbbff452f58ee6c944a6d580aec1d3a835 [^]
2012-09-27 15:51maiteNote Added: 0052838
2012-09-27 15:51maiteStatusresolved => closed
2012-09-28 14:39hudsonbotCheckin
2012-09-28 14:39hudsonbotNote Added: 0052921

Notes
(0052834)
hgbot   
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   
2012-09-27 15:51   
verified
(0052921)
hudsonbot   
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