details: https://code.openbravo.com/erp/devel/pi/rev/9ebdb868d92f changeset: 25604:9ebdb868d92f user: Daniel Ruiz <daniel.ruiz <at> openbravo.com> date: Tue Oct 21 17:47:46 2014 +0200 summary: Fixes Issue 27266:United States is always selected in Country field (Business Partner window, Bank account tab).
Default value shown on country field in Bank account tab (Business Partner window) is always United States and it should not be in that way. Now, default value will be the country defined in Location/address tab. If there are no Locations defined, it will take the country which has isDefault column set as 'Y'. Finally, if there are several Locations defined for that Business Partner, the system will take any of them and if there is one record whose country is set as Default, this one will be shown. details: https://code.openbravo.com/erp/devel/pi/rev/0a1b54e001f0 changeset: 25605:0a1b54e001f0 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Tue Dec 23 10:31:52 2014 +0530 summary: Fixes Issue 27266: Added isactive='Y' clause while BP Location selection diffstat: src-db/database/sourcedata/AD_AUXILIARINPUT.xml | 11 +++++++++++ src-db/database/sourcedata/AD_COLUMN.xml | 1 + 2 files changed, 12 insertions(+), 0 deletions(-) diffs (32 lines): diff -r 73cd159d83fb -r 0a1b54e001f0 src-db/database/sourcedata/AD_AUXILIARINPUT.xml --- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Wed Dec 24 10:19:35 2014 -0500 +++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Tue Dec 23 10:31:52 2014 +0530 @@ -3489,6 +3489,17 @@ <!--CF00CC6BA5F747CBB77CA682833A22FE--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--CF00CC6BA5F747CBB77CA682833A22FE--></AD_AUXILIARINPUT> +<!--CF4458717FD243B0953351850E353F23--><AD_AUXILIARINPUT> +<!--CF4458717FD243B0953351850E353F23--> <AD_AUXILIARINPUT_ID><![CDATA[CF4458717FD243B0953351850E353F23]]></AD_AUXILIARINPUT_ID> +<!--CF4458717FD243B0953351850E353F23--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--CF4458717FD243B0953351850E353F23--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--CF4458717FD243B0953351850E353F23--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--CF4458717FD243B0953351850E353F23--> <AD_TAB_ID><![CDATA[226]]></AD_TAB_ID> +<!--CF4458717FD243B0953351850E353F23--> <NAME><![CDATA[COUNTRYDEF]]></NAME> +<!--CF4458717FD243B0953351850E353F23--> <CODE><![CDATA[@SQL= select (case when (select count(l.c_bpartner_location_id) from c_bpartner_location l left join c_location loc on l.c_location_id=loc.c_location_id left join c_country co on loc.c_country_id=co.c_country_id left join c_bpartner bpa on l.c_bpartner_id=bpa.c_bpartner_id where l.isactive='Y' and bpa.c_bpartner_id=@C_BPARTNER_ID@) >0 then (select b.c_country_id from (select a.c_country_id, Row_Number() OVER (ORDER BY a.isdefault desc) as myrow from (select co.c_country_id, co.isDefault from c_bpartner_location bpl left join c_location loc on bpl.c_location_id=loc.c_location_id left join c_country co on loc.c_country_id=co.c_country_id left join c_bpartner bpa on bpl.c_bpartner_id=bpa.c_bpartner_id where bpl.isactive='Y' and bpa.c_bpartner_id=@C_BPARTNER_ID@) a ) b where myrow=1) else (select b.c_country_id from (select a.c_country_id, Row_Number() OVER (ORDER BY a.isdefault desc) as myrow from (select co.c_country_id, co.isDef ault from c_country co where co.isDefault='Y') a) b where myrow=1) end) from c_bpartner where c_bpartner_id=@C_BPARTNER_ID@]]></CODE> +<!--CF4458717FD243B0953351850E353F23--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--CF4458717FD243B0953351850E353F23--></AD_AUXILIARINPUT> + <!--D030CCF0F7514C898D981791049FB0DF--><AD_AUXILIARINPUT> <!--D030CCF0F7514C898D981791049FB0DF--> <AD_AUXILIARINPUT_ID><![CDATA[D030CCF0F7514C898D981791049FB0DF]]></AD_AUXILIARINPUT_ID> <!--D030CCF0F7514C898D981791049FB0DF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 73cd159d83fb -r 0a1b54e001f0 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Dec 24 10:19:35 2014 -0500 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Dec 23 10:31:52 2014 +0530 @@ -218501,6 +218501,7 @@ <!--1005500021--> <AD_TABLE_ID><![CDATA[298]]></AD_TABLE_ID> <!--1005500021--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> <!--1005500021--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--1005500021--> <DEFAULTVALUE><![CDATA[@COUNTRYDEF@]]></DEFAULTVALUE> <!--1005500021--> <ISKEY><![CDATA[N]]></ISKEY> <!--1005500021--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--1005500021--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
