details: https://code.openbravo.com/erp/devel/pi/rev/cf1e11ee7ade changeset: 21121:cf1e11ee7ade user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Fri Sep 13 00:04:30 2013 +0200 summary: Fixes issue 24462: Warehouse field (goods shipment window) does not take user´s default warehouse
diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 11 ++++++++++- 1 files changed, 10 insertions(+), 1 deletions(-) diffs (21 lines): diff -r b4a6052148fe -r cf1e11ee7ade src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Sep 12 22:48:01 2013 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Fri Sep 13 00:04:30 2013 +0200 @@ -61536,7 +61536,16 @@ <!--3798--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> <!--3798--> <AD_REFERENCE_VALUE_ID><![CDATA[263693E51C7847BF90C897ADB830E2BB]]></AD_REFERENCE_VALUE_ID> <!--3798--> <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH> -<!--3798--> <DEFAULTVALUE><![CDATA[@SQL=select m_warehouse_id from ad_org_warehouse where ad_org_id = @ad_org_id@ group by m_warehouse_id, priority having min(priority) = priority]]></DEFAULTVALUE> +<!--3798--> <DEFAULTVALUE><![CDATA[@SQL=select coalesce( warehouse,m_warehouse_id) as m_warehouse_id +from ad_org_warehouse , (select min(m_warehouse_id) as warehouse + from ad_org_warehouse + where m_warehouse_id =@m_warehouse_id@ + and ad_org_id = @ad_org_id@) a + +where ad_org_id = @ad_org_id@ +group by m_warehouse_id, priority ,warehouse +having min(priority) = priority +]]></DEFAULTVALUE> <!--3798--> <ISKEY><![CDATA[N]]></ISKEY> <!--3798--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--3798--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> ------------------------------------------------------------------------------ How ServiceNow helps IT people transform IT departments: 1. Consolidate legacy IT systems to a single system of record for IT 2. Standardize and globalize service processes across IT 3. Implement zero-touch automation to replace manual, redundant tasks http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
