Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016189Openbravo ERP00. Application dictionarypublic2011-03-09 18:452011-04-09 00:00
Reporterxabiermerino 
Assigned ToAinhoaPagola 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP27 
Target Version3.0RC6Fixed in Version3.0RC6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016189: Error in the validation 'C_AcctSchema - Schemas matching organizations'
DescriptionThis validation (C_AcctSchema - Schemas matching organizations):

EXISTS (SELECT 1 FROM AD_ORG_ACCTSCHEMA WHERE AD_ORG_ACCTSCHEMA.C_ACCTSCHEMA_ID = C_ACCTSCHEMA.C_ACCTSCHEMA_ID AND (AD_ISORGINCLUDED(@AD_Org_ID@, AD_ORG_ID, AD_CLIENT_ID)<>-1 OR AD_ISORGINCLUDED(@AD_Org_ID@, AD_ORG_ID, AD_CLIENT_ID)<>-1))

the condition 'AD_ISORGINCLUDED(@AD_Org_ID@, AD_ORG_ID, AD_CLIENT_ID)<>-1)' appears twice.
Steps To ReproduceAs System Administrator go to Application Dictionary || Setup || Validation Setup || Validation
- Select the validation C_AcctSchema - Schemas matching organizations
- Realize that the Validation Code is wrong
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00164902.50MP28 closed AinhoaPagola Error in the validation 'C_AcctSchema - Schemas matching organizations' 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-09 18:45xabiermerinoNew Issue
2011-03-09 18:45xabiermerinoAssigned To => alostale
2011-03-09 18:45xabiermerinoModules => Core
2011-03-09 18:45xabiermerinoIssue Monitored: networkb
2011-03-10 08:21dalsasuaAssigned Toalostale => dalsasua
2011-03-24 14:03AinhoaPagolaAssigned Todalsasua => AinhoaPagola
2011-03-25 13:46AinhoaPagolaStatusnew => scheduled
2011-03-25 13:46AinhoaPagolafix_in_branch => pi
2011-03-31 08:50AinhoaPagolaTarget Version2.50MP28 => 3.0RC6
2011-03-31 08:50AinhoaPagolafix_in_branchpi =>
2011-04-04 13:47AinhoaPagolaNote Added: 0035547
2011-04-05 15:42hgbotCheckin
2011-04-05 15:42hgbotNote Added: 0035608
2011-04-05 15:42hgbotStatusscheduled => resolved
2011-04-05 15:42hgbotResolutionopen => fixed
2011-04-05 15:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ab9e699df9459e640d8e65a262dbd24bd3762f4f [^]
2011-04-08 12:14dalsasuaNote Added: 0035761
2011-04-08 12:15dalsasuaStatusresolved => closed
2011-04-08 12:15dalsasuaFixed in Version => 3.0RC6
2011-04-09 00:00anonymoussf_bug_id0 => 3281266

Notes
(0035547)
AinhoaPagola   
2011-04-04 13:47   
This validation should retrieve data from parent organizations as well has from child organizations. The issue is that it only retrieves data from the child organizations at the moment.

The unnecessary repeated code in "C_AcctSchema - Schemas matching organizations" validation is going to be removed and the validation maintained in case is being used.

This validation (in core) is only used for the parameters of "copy account" process linked to buttons in:
- Business Partner Category || Account
- Product Category || Account

Both parameters will be linked to a new validation that checks parent and child organizations.
(0035608)
hgbot   
2011-04-05 15:42   
Repository: erp/devel/pi
Changeset: ab9e699df9459e640d8e65a262dbd24bd3762f4f
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Mon Apr 04 18:38:50 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ab9e699df9459e640d8e65a262dbd24bd3762f4f [^]

Fixes issue 16189. New validation created

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0035761)
dalsasua   
2011-04-08 12:14   
Verified. Working fine.