Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015186Openbravo ERP09. Financial managementpublic2010-11-12 14:142010-12-21 00:00
Reportermalsasua 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP23 
Target Version2.50MP25Fixed in Version 
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
Summary0015186: accounts displayed in combo are not filtered by schema
Descriptionin Financial Management || Accounting || Setup || Account Tree || Element >> Element Value >> Customized Elements
the Accounts displayed in account combo are not filtered by schema
Steps To Reproduce. create two elements (A, B) in
 Financial Management || Accounting || Setup || Account Tree || Element
. create elements value in the two schemas created
   in A -> element value a1
   in B -> element value b1

. go to Financial Management || Accounting || Setup || Account Tree || Element >> Element Value >> Customized Elements of element A and element value a1
 . in account combo are displayed elements value a1 and b1
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-12 14:14malsasuaNew Issue
2010-11-12 14:14malsasuaAssigned To => dalsasua
2010-11-16 21:58tds-peterNote Added: 0032646
2010-11-17 13:20adrianromeroTarget Version2.50MP24 => 2.50MP25
2010-11-23 15:41dalsasuaStatusnew => scheduled
2010-11-23 15:41dalsasuafix_in_branch => pi
2010-11-23 16:31hgbotCheckin
2010-11-23 16:31hgbotNote Added: 0032795
2010-11-23 16:31hgbotStatusscheduled => resolved
2010-11-23 16:31hgbotResolutionopen => fixed
2010-11-23 16:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a4d188a307e6ff75c0157409dd19d4fafcddfc5f [^]
2010-11-30 17:52hudsonbotCheckin
2010-11-30 17:52hudsonbotNote Added: 0032938
2010-12-20 13:31psarobeNote Added: 0033289
2010-12-20 13:31psarobeStatusresolved => closed
2010-12-21 00:00anonymoussf_bug_id0 => 3141008

Notes
(0032646)
tds-peter   
2010-11-16 21:58   
Some additional information - this issue was originally seen in our client GFR Pharma. They have five organizations, one of which is '*'. So '*' is the parent and the other are siblings to each other.
Even if you select a specific org on this customized elements screen, you will always see the account for the selected org and the same account for '*'. Since the schema is not displayed in the dropdown list, you merely see two 1000 - Assets, two 2000 - Liabilities and so on.

The problem is even worse if the client wants financial reports for the parent Organization (*), as the list of elements on the Customized Element screen will list all five of each account (five 1000-Asset, five 2000-liabilities and so on). If you select an account from the wrong org, you'll get Stack Overflow exception trying to run the Balance Sheet, as well.

If you could either scope the list specifically to the selected org OR add the related schema in the display in the listbox, this problem should be addressed.
(0032795)
hgbot   
2010-11-23 16:31   
Repository: erp/devel/pi
Changeset: a4d188a307e6ff75c0157409dd19d4fafcddfc5f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Nov 23 16:29:53 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a4d188a307e6ff75c0157409dd19d4fafcddfc5f [^]

Fixes issue 15186: accounts displayed in combo are not filtered by schema
Added a validation that filters by the element to which the element value belongs

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0032938)
hudsonbot   
2010-11-30 17:52   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/a4d188a307e6 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c27b4b566df [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19017.obx [^]
(0033289)
psarobe   
2010-12-20 13:31   
Tested working fine