Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009561
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 00. Application dictionaryminorhave not tried2009-06-19 13:212012-09-13 10:43
ReporterFrancescoFinamoreView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009561: Default value of Country

DescriptionI have set on Table of Country the Default Country = Italy ,
but when i try to create a bank account for a Business Partner the Default Value
is Spain.
On the Tab of BP Bank Account there isn't a Default Value.
(The same problem when i try to create a Location)
 
Steps To Reproduce1) Go to General Setup || Application || Preference
2) Edit record C_Counrty_ID and set 214 (Italy)
SELECT NAME AS COUNTRY, C_COUNTRY_ID AS ID
FROM C_COUNTRY
WHERE UPPER(NAME) LIKE '%CHINA%' OR UPPER(NAME) LIKE '%ITALY%'
3) Log out and log in again.
4) Go to Master Data Management || Business Partner || Business Partner >> Bank Account and create a new record: Italy is selected by default in Country drop-down: OK
5) Go to Master Data Management || Business Partner || Business Partner >> Location/Address and create a new record: in Location selector Spain is selected by default instead of Italy: WRONG
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0017690)
psarobe (manager)
2009-06-30 19:51

 Hi Francesco,

Please take a look into the preference window. You probably have defined Spain as default country.

Waiting for your news
(0018871)
luciagu (reporter)
2009-08-07 07:33

 I have the same question about default country selection. In location search window, the default country remains spain.But I have changed the default country to China.

And I go to preference window, finding no definition record about Spain as default country.

Can you give some advice?
(0042281)
psarobe (manager)
2011-10-28 18:10

 The default country is calculated like this:

String strDefaultCountry = LocationSearchData.selectDefaultCountry(this, vars.getOrg(),
          Utility.getContext(this, vars, "#User_Client", strWindow));
      if (strDefaultCountry.equals("")) {
        strDefaultCountry = "106";

And the query for LocationSearchData.selectDefaultCountry is:

 <SqlMethod name="selectDefaultCountry" type="preparedStatement" return="String">
   <SqlMethodComment>Select Organization</SqlMethodComment>
   <Sql><![CDATA[
    SELECT MIN(l.C_COUNTRY_ID) FROM AD_ORG o
                left join AD_ORGINFO oinf on oinf.AD_ORG_ID = o.AD_ORG_ID
                left join C_LOCATION l on oinf.C_LOCATION_ID = l.C_LOCATION_ID
    WHERE
     ? IN (o.AD_ORG_ID, '0')
    AND o.ISACTIVE = 'Y'
    AND o.AD_Client_ID IN ('1')
    ]]></Sql>
   <Parameter name="adOrgId"/>
   <Parameter name="adUserClient" type="replace" optional="true" after="o.AD_Client_ID IN (" text="'1'"/>
   </SqlMethod>
</SqlClass>

So it calculates the default country based on the organization info tab of the logged organization. If there is no data then it puts spain

- Issue History
Date Modified Username Field Change
2009-06-19 13:21 FrancescoFinamore New Issue
2009-06-19 13:21 FrancescoFinamore Assigned To => rafaroda
2009-06-30 19:51 psarobe Note Added: 0017690
2009-06-30 19:51 psarobe Status new => feedback
2009-08-07 07:33 luciagu Note Added: 0018871
2009-08-31 11:08 rafaroda Assigned To rafaroda => jeneivemalarkodi
2009-08-31 11:08 rafaroda Priority normal => high
2009-08-31 11:08 rafaroda Status feedback => scheduled
2009-08-31 11:08 rafaroda Proposed Solution updated
2009-08-31 11:09 rafaroda Proposed Solution updated
2010-03-10 11:02 rafaroda Assigned To jeneivemalarkodi => adrianromero
2011-06-03 11:00 dalsasua Assigned To adrianromero => dalsasua
2011-07-20 18:12 dalsasua Assigned To dalsasua => jonalegriaesarte
2011-10-28 18:10 psarobe Note Added: 0042281
2011-10-28 18:11 psarobe Type defect => design defect
2012-09-13 10:43 jonalegriaesarte Assigned To jonalegriaesarte => dmiguelez

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker