related to issue 39017 code review changes
authorSandra Huguet <sandra.huguet@openbravo.com>
Fri, 10 Aug 2018 15:02:15 +0200
changeset 34504 6bc6e8515310
parent 34503 389e4c0f5e99
child 34505 7d17883ca725
related to issue 39017 code review changes

fix group by clause
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql	Fri Aug 10 14:45:30 2018 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql	Fri Aug 10 15:02:15 2018 +0200
@@ -81,7 +81,7 @@
           AND M_REQUISITIONLINE.AD_ORG_ID IN ('1')
           AND 1=1
         GROUP BY M_REQUISITIONLINE.M_REQUISITIONLINE_ID, M_REQUISITIONLINE.NEEDBYDATE, M_REQUISITIONLINE.QTY, M_REQUISITIONLINE.ORDEREDQTY,
-        QUANTITYORDER, AUMQTY, C_AUM, C_UOM.C_UOM_ID, C_UOM1.NAME, C_UOM.NAME, C_UOM2.NAME, pl.istaxincluded, pl.M_PRICELIST_ID, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.DESCRIPTION,
+        QUANTITYORDER, AUMQTY, C_AUM, C_UOM.C_UOM_ID, C_UOM1.NAME, C_UOM.NAME, C_UOM2.NAME, pl.istaxincluded, pl.name, M_PRODUCT.NAME, M_ATTRIBUTESETINSTANCE.DESCRIPTION,
          AD_USER.NAME, C_BPARTNER.NAME, M_REQUISITIONLINE.GROSS_UNIT_PRICE, M_REQUISITIONLINE.PRICEACTUAL,
         M_REQUISITIONLINE.C_BPARTNER_ID, M_REQUISITION.C_BPARTNER_ID, M_REQUISITIONLINE.M_PRICELIST_ID, M_REQUISITION.M_PRICELIST_ID,
         M_REQUISITIONLINE.M_PRODUCT_ID, M_REQUISITIONLINE.M_ATTRIBUTESETINSTANCE_ID, M_REQUISITION.AD_USER_ID