Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025483Openbravo ERP09. Financial managementpublic2014-01-16 00:362014-05-07 18:11
Reporterchelipf 
Assigned Topramakrishnan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionDebian Wheezy
Product Version3.0MP29.1 
Target Version3.0PR14Q3Fixed in Version 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customer
Web browserMozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025483: It is not possible to add a validate rule to fin_financial_account_id column of fin_payment table
DescriptionThe problem is that there is a callout (SE_PaymentMethod_FinAccount) that is executed just after the select that fills the combo box, and this callout fills the combo box again overriding the former values.
Steps To Reproduce- Create a validation rule.
- Assign that validation to fin_financial_account_id column of fin_payment table.
- Check that the validation is overridden every time the callout is executed.
Proposed SolutionReplace the callout logic with a table validation, then you can add a validation rule without any problem.

Take a look to the patch file.
Additional Information
TagsSidesoft
Relationships
causes defect 0029368 closed jorge-garcia It is possible to create a payment header when a payment method is disabled in a given financial account 
Attached Filesdiff fin_payment.diff (11,970) 2014-01-16 00:36
https://issues.openbravo.com/file_download.php?file_id=6641&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-01-16 00:36chelipfNew Issue
2014-01-16 00:36chelipfAssigned To => dmiguelez
2014-01-16 00:36chelipfFile Added: fin_payment.diff
2014-01-16 00:36chelipfWeb browser => Mozilla Firefox
2014-01-16 00:36chelipfModules => Core
2014-01-16 00:36chelipfTriggers an Emergency Pack => No
2014-01-16 00:37chelipfTag Attached: Sidesoft
2014-01-16 06:11chelipfIssue Monitored: chelipf
2014-02-19 18:05jonalegriaesarteWeb browserMozilla Firefox => Mozilla Firefox
2014-02-19 18:05jonalegriaesarteTarget Version => 3.0MP32
2014-03-10 18:17jonalegriaesarteAssigned Todmiguelez => pramakrishnan
2014-03-10 18:17jonalegriaesarteWeb browserMozilla Firefox => Mozilla Firefox
2014-03-10 18:17jonalegriaesarteResolution time => 1394578800
2014-03-12 15:12pramakrishnanReview Assigned To => jonalegriaesarte
2014-03-12 15:12pramakrishnanWeb browserMozilla Firefox => Mozilla Firefox
2014-03-12 15:12pramakrishnanStatusnew => scheduled
2014-03-31 16:17jonalegriaesarteTarget VersionPR14Q2 => PR14Q3
2014-03-31 16:40jonalegriaesarteWeb browserMozilla Firefox => Mozilla Firefox
2014-03-31 16:40jonalegriaesarteResolution time1394578800 => 1397253600
2014-04-07 09:05hgbotCheckin
2014-04-07 09:05hgbotNote Added: 0066191
2014-04-07 09:05hgbotStatusscheduled => resolved
2014-04-07 09:05hgbotResolutionopen => fixed
2014-04-07 09:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e3ae82ec9ee35e6e4bb728a1c2d7975b5572683f [^]
2014-04-07 11:45pramakrishnanNote Added: 0066199
2014-04-07 15:12hgbotCheckin
2014-04-07 15:12hgbotNote Added: 0066208
2014-04-14 09:55jonalegriaesarteNote Added: 0066370
2014-04-14 09:55jonalegriaesarteStatusresolved => closed
2014-04-14 09:56jonalegriaesarteNote Edited: 0066370bug_revision_view_page.php?bugnote_id=0066370#r5701
2014-05-07 18:11hudsonbotCheckin
2014-05-07 18:11hudsonbotNote Added: 0066895
2014-05-07 18:11hudsonbotCheckin
2014-05-07 18:11hudsonbotNote Added: 0066897
2015-03-23 12:38SandrahuguetRelationship addedcauses 0029368

Notes
(0066191)
hgbot   
2014-04-07 09:05   
Repository: erp/devel/pi
Changeset: e3ae82ec9ee35e6e4bb728a1c2d7975b5572683f
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Apr 07 00:47:11 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e3ae82ec9ee35e6e4bb728a1c2d7975b5572683f [^]

Fixes Issue 25483: It is not possible to add a validate rule to fin_financial_account_id column of fin_payment table

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
M src/org/openbravo/erpCommon/ad_callouts/SE_PaymentMethod_FinAccount.java
---
(0066199)
pramakrishnan   
2014-04-07 11:45   
Repository: erp/devel/pi
Changeset: 97d8cf3e7d76
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Apr 07 15:11:15 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/97d8cf3e7d76 [^] [^]

Related to 25483: Code Reformatting
---
M src/org/openbravo/erpCommon/ad_callouts/SE_PaymentMethod_FinAccount.java
---
(0066208)
hgbot   
2014-04-07 15:12   
Repository: erp/devel/pi
Changeset: f0e068c5bbca03304e2174420e27130a6b90a5cc
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Apr 07 18:39:39 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f0e068c5bbca03304e2174420e27130a6b90a5cc [^]

Related to Issue 25483 : Changed validation for oracle compatibility

---
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0066370)
jonalegriaesarte   
2014-04-14 09:55   
(edited on: 2014-04-14 09:56)
Tested and working fine
(0066895)
hudsonbot   
2014-05-07 18:11   
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/02ca2648bcdc [^]
Maturity status: Test
(0066897)
hudsonbot   
2014-05-07 18:11   
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/02ca2648bcdc [^]
Maturity status: Test