details: https://code.openbravo.com/erp/devel/pi/rev/9cb6170994b1 changeset: 33528:9cb6170994b1 user: V=EDctor Mart=EDnez Romanos <victor.martinez <at> openbravo.com> date: Tue Feb 13 18:05:20 2018 +0100 summary: Fixed issue 37827: [ri] redesign M_REFINVENTORY_VALUE_UN unique = constraint For AWO purposes it's better to ensure a unique referenced inventory per cl= ient.
details: https://code.openbravo.com/erp/devel/pi/rev/499ed06c9d18 changeset: 33529:499ed06c9d18 user: V=EDctor Mart=EDnez Romanos <victor.martinez <at> openbravo.com> date: Sat Feb 17 09:33:17 2018 +0100 summary: Fixed issue 37827: [ri] set original attributesetinstance=3D0 if= null details: https://code.openbravo.com/erp/devel/pi/rev/526633fb1fd0 changeset: 33530:526633fb1fd0 user: V=EDctor Mart=EDnez Romanos <victor.martinez <at> openbravo.com> date: Tue Feb 20 17:38:26 2018 +0100 summary: Fixed issue 37827: [ri] Moved validation over storage bin in box= ing to Core details: https://code.openbravo.com/erp/devel/pi/rev/28ecb6656be7 changeset: 33531:28ecb6656be7 user: V=EDctor Mart=EDnez Romanos <victor.martinez <at> openbravo.com> date: Tue Feb 20 17:50:47 2018 +0100 summary: Fixed issue 37827: [ri] transform index to partial index details: https://code.openbravo.com/erp/devel/pi/rev/b6a93ba857f3 changeset: 33532:b6a93ba857f3 user: V=EDctor Mart=EDnez Romanos <victor.martinez <at> openbravo.com> date: Wed Feb 21 10:12:00 2018 +0100 summary: Fixed issue 37827: [ri] Added RefInventory to M_PRODUCT_STOCK_V = and related selectors diffstat: src-db/database/model/tables/M_REFINVENTORY.xml |= 1 - src-db/database/model/tables/M_STORAGE_DETAIL.xml |= 1 + src-db/database/model/views/M_PRODUCT_STOCK_V.xml |= 2 +- src-db/database/sourcedata/AD_COLUMN.xml |= 38 +++++++++ src-db/database/sourcedata/AD_VAL_RULE.xml |= 13 +++ src-db/database/sourcedata/OBUIAPP_PARAMETER.xml |= 1 + src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml |= 42 ++++++++++ src/org/openbravo/materialmgmt/refinventory/ReferencedInventoryUtil.java |= 5 +- 8 files changed, 100 insertions(+), 3 deletions(-) diffs (195 lines): diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/model/tables/M_REFINVE= NTORY.xml --- a/src-db/database/model/tables/M_REFINVENTORY.xml Wed Feb 21 12:53:07 2= 018 +0100 +++ b/src-db/database/model/tables/M_REFINVENTORY.xml Wed Feb 21 10:12:00 2= 018 +0100 @@ -60,7 +60,6 @@ </foreign-key> <unique name=3D"M_REFINVENTORY_VALUE_UN"> <unique-column name=3D"VALUE"/> - <unique-column name=3D"M_REFINVENTORY_TYPE_ID"/> <unique-column name=3D"AD_CLIENT_ID"/> </unique> <check name=3D"M_REFINV_ISACTIVE_CH"><![CDATA[ISACTIVE IN ('Y', 'N')= ]]></check> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/model/tables/M_STORAGE= _DETAIL.xml --- a/src-db/database/model/tables/M_STORAGE_DETAIL.xml Wed Feb 21 12:53:07= 2018 +0100 +++ b/src-db/database/model/tables/M_STORAGE_DETAIL.xml Wed Feb 21 10:12:00= 2018 +0100 @@ -126,6 +126,7 @@ </index> <index name=3D"M_STORAGEDET_REFINVENTORY" unique=3D"false"> <index-column name=3D"M_REFINVENTORY_ID"/> + <whereClause><![CDATA[M_REFINVENTORY_ID IS NOT NULL]]></whereClaus= e> </index> <unique name=3D"M_STORAGE_DETAIL_UN"> <unique-column name=3D"M_PRODUCT_ID"/> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/model/views/M_PRODUCT_= STOCK_V.xml --- a/src-db/database/model/views/M_PRODUCT_STOCK_V.xml Wed Feb 21 12:53:07= 2018 +0100 +++ b/src-db/database/model/views/M_PRODUCT_STOCK_V.xml Wed Feb 21 10:12:00= 2018 +0100 @@ -1,4 +1,4 @@ <?xml version=3D"1.0"?> <database name=3D"VIEW M_PRODUCT_STOCK_V"> - <view name=3D"M_PRODUCT_STOCK_V"><![CDATA[SELECT p.m_product_id || sd.= m_storage_detail_id AS m_product_stock_v_id, l.ad_client_id, l.ad_org_id, l= .isactive, sd.created, sd.createdby, sd.updated, sd.updatedby, sd.m_product= _id, sd.qtyonhand, sd.qtyorderonhand, sd.preqtyonhand, sd.preqtyorderonhand= , sd.c_uom_id, sd.m_product_uom_id, sd.m_attributesetinstance_id, sd.m_loca= tor_id, 'Y' AS stocked, l.m_warehouse_id FROM m_storage_detail sd JOIN m_lo= cator l ON sd.m_locator_id =3D l.m_locator_id JOIN m_product p ON sd.m_prod= uct_id =3D p.m_product_id AND p.isactive =3D 'Y' WHERE sd.qtyonhand <> 0 OR= COALESCE(sd.qtyorderonhand, 0) <> 0 UNION ALL SELECT p.m_product_id AS m_p= roduct_stock_v_id, p.ad_client_id, p.ad_org_id, p.isactive, p.created, p.cr= eatedby, p.updated, p.updatedby, p.m_product_id, 0 AS qtyonhand, NULL AS qt= yorderonhand, 0 AS preqtyonhand, NULL AS preqtyorderonhand, p.c_uom_id, NUL= L AS m_product_uom_id, CASE p.attrsetvaluetype WHEN 'D' THEN p.m_attributes= etinstance_id ELSE NULL END AS m_attributesetinstance_id, NULL AS m_locator= _id, 'N' AS stocked, NULL AS m_warehouse_id FROM m_product p WHERE p.isgene= ric =3D 'N']]></view> + <view name=3D"M_PRODUCT_STOCK_V"><![CDATA[SELECT p.m_product_id || sd.= m_storage_detail_id AS m_product_stock_v_id, l.ad_client_id, l.ad_org_id, l= .isactive, sd.created, sd.createdby, sd.updated, sd.updatedby, sd.m_product= _id, sd.qtyonhand, sd.qtyorderonhand, sd.preqtyonhand, sd.preqtyorderonhand= , sd.c_uom_id, sd.m_product_uom_id, sd.m_attributesetinstance_id, sd.m_loca= tor_id, 'Y' AS stocked, l.m_warehouse_id, sd.m_refinventory_id FROM m_stora= ge_detail sd JOIN m_locator l ON sd.m_locator_id =3D l.m_locator_id JOIN m_= product p ON sd.m_product_id =3D p.m_product_id AND p.isactive =3D 'Y' WHER= E sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 UNION ALL SELECT= p.m_product_id AS m_product_stock_v_id, p.ad_client_id, p.ad_org_id, p.isa= ctive, p.created, p.createdby, p.updated, p.updatedby, p.m_product_id, 0 AS= qtyonhand, NULL AS qtyorderonhand, 0 AS preqtyonhand, NULL AS preqtyordero= nhand, p.c_uom_id, NULL AS m_product_uom_id, CASE p.attrsetvaluetype WHEN '= D' THEN p.m_attributesetinstance_id ELSE NULL END AS m_attributesetinstance= _id, NULL AS m_locator_id, 'N' AS stocked, NULL AS m_warehouse_id, NULL AS = m_refinventory_id FROM m_product p WHERE p.isgeneric =3D 'N']]></view> </database> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/sourcedata/AD_COLUMN.x= ml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Feb 21 12:53:07 2018 +01= 00 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Feb 21 10:12:00 2018 +01= 00 @@ -347793,6 +347793,43 @@ <!--B22C83F80E9748D0B2E096984736918E--> <EM_OBUIAPP_PROCESS_ID><![CDATA[A= 2C19D0EF6594D14A64BC62E99A89CC3]]></EM_OBUIAPP_PROCESS_ID> <!--B22C83F80E9748D0B2E096984736918E--></AD_COLUMN> =20 +<!--B24838F17F1F46CCA7091E97A1A92E19--><AD_COLUMN> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_COLUMN_ID><![CDATA[B24838F17F= 1F46CCA7091E97A1A92E19]]></AD_COLUMN_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_= ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <NAME><![CDATA[Referenced Invento= ry]]></NAME> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <HELP><![CDATA[ID for a Reference= d Inventory]]></HELP> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <COLUMNNAME><![CDATA[M_Refinvento= ry_ID]]></COLUMNNAME> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_TABLE_ID><![CDATA[FF8080812E3= 81D1E012E3898C5DD0010]]></AD_TABLE_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_REFERENCE_ID><![CDATA[19]]></= AD_REFERENCE_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <FIELDLENGTH><![CDATA[32]]></FIEL= DLENGTH> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISKEY><![CDATA[N]]></ISKEY> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISMANDATORY><![CDATA[N]]></ISMAN= DATORY> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISUPDATEABLE><![CDATA[Y]]></ISUP= DATEABLE> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISIDENTIFIER><![CDATA[N]]></ISID= ENTIFIER> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <SEQNO><![CDATA[200]]></SEQNO> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISTRANSLATED><![CDATA[N]]></ISTR= ANSLATED> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISENCRYPTED><![CDATA[N]]></ISENC= RYPTED> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISSELECTIONCOLUMN><![CDATA[N]]><= /ISSELECTIONCOLUMN> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_ELEMENT_ID><![CDATA[E13E9A859= 32B43B58C569625C5662AE3]]></AD_ELEMENT_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISSESSIONATTR><![CDATA[N]]></ISS= ESSIONATTR> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISSECONDARYKEY><![CDATA[N]]></IS= SECONDARYKEY> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISDESENCRYPTABLE><![CDATA[N]]></= ISDESENCRYPTABLE> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <DEVELOPMENTSTATUS><![CDATA[RE]]>= </DEVELOPMENTSTATUS> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <POSITION><![CDATA[20]]></POSITIO= N> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISTRANSIENT><![CDATA[N]]></ISTRA= NSIENT> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTO= SAVE> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <VALIDATEONNEW><![CDATA[Y]]></VAL= IDATEONNEW> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <IMAGESIZEVALUESACTION><![CDATA[N= ]]></IMAGESIZEVALUESACTION> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ISUSEDSEQUENCE><![CDATA[N]]></IS= USEDSEQUENCE> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ALLOWSORTING><![CDATA[Y]]></ALLO= WSORTING> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ALLOWFILTERING><![CDATA[Y]]></AL= LOWFILTERING> +<!--B24838F17F1F46CCA7091E97A1A92E19--> <ALLOWED_CROSS_ORG_LINK><![CDATA[= N]]></ALLOWED_CROSS_ORG_LINK> +<!--B24838F17F1F46CCA7091E97A1A92E19--></AD_COLUMN> + <!--B2A4D134FC224A4A91826B7B096A2A8C--><AD_COLUMN> <!--B2A4D134FC224A4A91826B7B096A2A8C--> <AD_COLUMN_ID><![CDATA[B2A4D134FC= 224A4A91826B7B096A2A8C]]></AD_COLUMN_ID> <!--B2A4D134FC224A4A91826B7B096A2A8C--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> @@ -365071,6 +365108,7 @@ <!--D13ED1C864DB4720B31E0E6D3FB71298--> <ISDESENCRYPTABLE><![CDATA[N]]></= ISDESENCRYPTABLE> <!--D13ED1C864DB4720B31E0E6D3FB71298--> <DEVELOPMENTSTATUS><![CDATA[RE]]>= </DEVELOPMENTSTATUS> <!--D13ED1C864DB4720B31E0E6D3FB71298--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> +<!--D13ED1C864DB4720B31E0E6D3FB71298--> <POSITION><![CDATA[19]]></POSITIO= N> <!--D13ED1C864DB4720B31E0E6D3FB71298--> <ISTRANSIENT><![CDATA[N]]></ISTRA= NSIENT> <!--D13ED1C864DB4720B31E0E6D3FB71298--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTO= SAVE> <!--D13ED1C864DB4720B31E0E6D3FB71298--> <VALIDATEONNEW><![CDATA[Y]]></VAL= IDATEONNEW> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/sourcedata/AD_VAL_RULE= .xml --- a/src-db/database/sourcedata/AD_VAL_RULE.xml Wed Feb 21 12:53:07 2018 += 0100 +++ b/src-db/database/sourcedata/AD_VAL_RULE.xml Wed Feb 21 10:12:00 2018 += 0100 @@ -1435,6 +1435,19 @@ <!--34A2733B41B04DC19B3E54F764753D19--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> <!--34A2733B41B04DC19B3E54F764753D19--></AD_VAL_RULE> =20 +<!--37ACEA9559724E168D4237C46FFBEE2A--><AD_VAL_RULE> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <AD_VAL_RULE_ID><![CDATA[37ACEA95= 59724E168D4237C46FFBEE2A]]></AD_VAL_RULE_ID> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_= ID> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <NAME><![CDATA[Only current refer= enced inventory bin or all bins if empty]]></NAME> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <TYPE><![CDATA[HQL_JS]]></TYPE> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <CODE><![CDATA[if (OB.getParamete= rs().get('M_RefInventory_ID') !=3D null && OB.getParameters().get('M_RefInv= entory_ID') !=3D "null") {=20 + "exists (select 1 from MaterialMgmtStorageDetail sd where sd.quantityOnH= and > 0 and sd.storageBin.id =3D e.id and sd.referencedInventory.id =3D '" = + OB.getParameters().get('M_RefInventory_ID') + "' ) or not exists (select = 1 from MaterialMgmtStorageDetail sd where sd.quantityOnHand > 0 and sd.refe= rencedInventory.id =3D '" + OB.getParameters().get('M_RefInventory_ID') + "= ' )" +}]]></CODE> +<!--37ACEA9559724E168D4237C46FFBEE2A--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> +<!--37ACEA9559724E168D4237C46FFBEE2A--></AD_VAL_RULE> + <!--3934616F1F6745D8964D66CF4B9C8895--><AD_VAL_RULE> <!--3934616F1F6745D8964D66CF4B9C8895--> <AD_VAL_RULE_ID><![CDATA[3934616F= 1F6745D8964D66CF4B9C8895]]></AD_VAL_RULE_ID> <!--3934616F1F6745D8964D66CF4B9C8895--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/sourcedata/OBUIAPP_PAR= AMETER.xml --- a/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Wed Feb 21 12:53:07 = 2018 +0100 +++ b/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Wed Feb 21 10:12:00 = 2018 +0100 @@ -1817,6 +1817,7 @@ <!--CDB2669B5A4B42E08777C6E1B974A74A--> <EVALUATEFIXEDVALUE><![CDATA[N]]>= </EVALUATEFIXEDVALUE> <!--CDB2669B5A4B42E08777C6E1B974A74A--> <OBUIAPP_PROCESS_ID><![CDATA[0B90= 883A379A4736B7016B8D5E8E75DB]]></OBUIAPP_PROCESS_ID> <!--CDB2669B5A4B42E08777C6E1B974A74A--> <STARTINNEWLINE><![CDATA[N]]></ST= ARTINNEWLINE> +<!--CDB2669B5A4B42E08777C6E1B974A74A--> <AD_VAL_RULE_ID><![CDATA[37ACEA95= 59724E168D4237C46FFBEE2A]]></AD_VAL_RULE_ID> <!--CDB2669B5A4B42E08777C6E1B974A74A--> <DISPLAYEDROWS><![CDATA[5]]></DIS= PLAYEDROWS> <!--CDB2669B5A4B42E08777C6E1B974A74A--> <DISPLAYTITLE><![CDATA[Y]]></DISP= LAYTITLE> <!--CDB2669B5A4B42E08777C6E1B974A74A--> <ATT_SHOWINDESCRIPTION><![CDATA[N= ]]></ATT_SHOWINDESCRIPTION> diff -r 5591d21a0627 -r b6a93ba857f3 src-db/database/sourcedata/OBUISEL_SEL= ECTOR_FIELD.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Wed Feb 21 12:5= 3:07 2018 +0100 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Wed Feb 21 10:1= 2:00 2018 +0100 @@ -1732,6 +1732,27 @@ <!--56CF04D01F364FD1AC5BA64E0D5CC4D6--> <SHOWINPICKLIST><![CDATA[N]]></SH= OWINPICKLIST> <!--56CF04D01F364FD1AC5BA64E0D5CC4D6--></OBUISEL_SELECTOR_FIELD> =20 +<!--58352361C2E6416190F8B42EFE4FE1AF--><OBUISEL_SELECTOR_FIELD> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <OBUISEL_SELECTOR_FIELD_ID><![CDA= TA[58352361C2E6416190F8B42EFE4FE1AF]]></OBUISEL_SELECTOR_FIELD_ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <OBUISEL_SELECTOR_ID><![CDATA[4C8= BC3E8E56441F4B8C98C684A0C9212]]></OBUISEL_SELECTOR_ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_= ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <AD_COLUMN_ID><![CDATA[B24838F17F= 1F46CCA7091E97A1A92E19]]></AD_COLUMN_ID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <NAME><![CDATA[Referenced Invento= ry]]></NAME> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <HELP><![CDATA[ID for a Reference= d Inventory]]></HELP> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <PROPERTY><![CDATA[referencedInve= ntory]]></PROPERTY> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <ISCENTRALLYMAINTAINED><![CDATA[Y= ]]></ISCENTRALLYMAINTAINED> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <SORT><![CDATA[Y]]></SORT> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <FILTER><![CDATA[Y]]></FILTER> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <SEARCHINSUGGESTIONBOX><![CDATA[N= ]]></SEARCHINSUGGESTIONBOX> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <SHOWINGRID><![CDATA[Y]]></SHOWIN= GRID> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <SORTNO><![CDATA[120]]></SORTNO> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <ISOUTFIELD><![CDATA[N]]></ISOUTF= IELD> +<!--58352361C2E6416190F8B42EFE4FE1AF--> <SHOWINPICKLIST><![CDATA[N]]></SH= OWINPICKLIST> +<!--58352361C2E6416190F8B42EFE4FE1AF--></OBUISEL_SELECTOR_FIELD> + <!--595A55CFF6EE4272A3B4330A1814FCDB--><OBUISEL_SELECTOR_FIELD> <!--595A55CFF6EE4272A3B4330A1814FCDB--> <OBUISEL_SELECTOR_FIELD_ID><![CDA= TA[595A55CFF6EE4272A3B4330A1814FCDB]]></OBUISEL_SELECTOR_FIELD_ID> <!--595A55CFF6EE4272A3B4330A1814FCDB--> <OBUISEL_SELECTOR_ID><![CDATA[2E6= 4F551C7C4470C80C29DBA24B34A5F]]></OBUISEL_SELECTOR_ID> @@ -3675,6 +3696,27 @@ <!--B4059CC0CC2847DA9B9F60513919B1DF--> <SHOWINPICKLIST><![CDATA[N]]></SH= OWINPICKLIST> <!--B4059CC0CC2847DA9B9F60513919B1DF--></OBUISEL_SELECTOR_FIELD> =20 +<!--B579FFF4DCDA451B9386D582AAD0706E--><OBUISEL_SELECTOR_FIELD> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <OBUISEL_SELECTOR_FIELD_ID><![CDA= TA[B579FFF4DCDA451B9386D582AAD0706E]]></OBUISEL_SELECTOR_FIELD_ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <OBUISEL_SELECTOR_ID><![CDATA[4D3= AD61E57AF460EAB4D36A4E1476667]]></OBUISEL_SELECTOR_ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <AD_CLIENT_ID><![CDATA[0]]></AD_C= LIENT_ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_= ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <AD_MODULE_ID><![CDATA[0]]></AD_M= ODULE_ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <AD_COLUMN_ID><![CDATA[B24838F17F= 1F46CCA7091E97A1A92E19]]></AD_COLUMN_ID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <NAME><![CDATA[Referenced Invento= ry]]></NAME> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <HELP><![CDATA[ID for a Reference= d Inventory]]></HELP> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <PROPERTY><![CDATA[referencedInve= ntory]]></PROPERTY> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <ISCENTRALLYMAINTAINED><![CDATA[Y= ]]></ISCENTRALLYMAINTAINED> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <SORT><![CDATA[Y]]></SORT> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <FILTER><![CDATA[Y]]></FILTER> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <SEARCHINSUGGESTIONBOX><![CDATA[N= ]]></SEARCHINSUGGESTIONBOX> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <SHOWINGRID><![CDATA[Y]]></SHOWIN= GRID> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <SORTNO><![CDATA[130]]></SORTNO> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <ISOUTFIELD><![CDATA[N]]></ISOUTF= IELD> +<!--B579FFF4DCDA451B9386D582AAD0706E--> <SHOWINPICKLIST><![CDATA[N]]></SH= OWINPICKLIST> +<!--B579FFF4DCDA451B9386D582AAD0706E--></OBUISEL_SELECTOR_FIELD> + <!--B759B8BC264044D1A93CD79594A72F38--><OBUISEL_SELECTOR_FIELD> <!--B759B8BC264044D1A93CD79594A72F38--> <OBUISEL_SELECTOR_FIELD_ID><![CDA= TA[B759B8BC264044D1A93CD79594A72F38]]></OBUISEL_SELECTOR_FIELD_ID> <!--B759B8BC264044D1A93CD79594A72F38--> <OBUISEL_SELECTOR_ID><![CDATA[A35= B6EC33A2243018915908AEB1B3F5E]]></OBUISEL_SELECTOR_ID> diff -r 5591d21a0627 -r b6a93ba857f3 src/org/openbravo/materialmgmt/refinve= ntory/ReferencedInventoryUtil.java --- a/src/org/openbravo/materialmgmt/refinventory/ReferencedInventoryUtil.j= ava Wed Feb 21 12:53:07 2018 +0100 +++ b/src/org/openbravo/materialmgmt/refinventory/ReferencedInventoryUtil.j= ava Wed Feb 21 10:12:00 2018 +0100 @@ -57,8 +57,11 @@ * link it to the given referencedInventory */ public static final AttributeSetInstance cloneAttributeSetInstance( - final AttributeSetInstance originalAttributeSetInstance, + final AttributeSetInstance _originalAttributeSetInstance, final ReferencedInventory referencedInventory) { + final AttributeSetInstance originalAttributeSetInstance =3D _originalA= ttributeSetInstance =3D=3D null ? OBDal + .getInstance().get(AttributeSetInstance.class, "0") : _originalAtt= ributeSetInstance; + final AttributeSetInstance newAttributeSetInstance =3D (AttributeSetIn= stance) DalUtil.copy( originalAttributeSetInstance, false); newAttributeSetInstance.setClient(referencedInventory.getClient()); ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits