details:   https://code.openbravo.com/erp/devel/pi/rev/059d60b862a4
changeset: 19795:059d60b862a4
user:      Javier Etxarri <javier.echarri <at> openbravo.com>
date:      Tue Feb 26 09:36:29 2013 +0100
summary:   issue 22913: Second UOM not shown when
creating a receipt from an order that has been partially received

diffstat:

 src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql |  2 
+-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 2fe7a6f9618c -r 059d60b862a4 
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql 
Tue Feb 26 09:00:10 2013 +0530
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql 
Tue Feb 26 09:36:29 2013 +0100
@@ -45,7 +45,7 @@
         coalesce (l.c_bpartner_id,o.c_bpartner_id) as c_bpartner_id
         FROM C_ORDERLINE l left join  M_MATCHPO m on 
l.C_OrderLine_ID=m.C_OrderLine_ID
                                                  and m.M_InOutLine_ID IS NOT 
NULL
-                           LEFT JOIN M_Product_UOM mpu on mpu.m_product_id 
=l.m_product_id,  
+                           LEFT JOIN M_Product_UOM mpu on mpu.M_PRODUCT_UOM_ID 
=l.M_PRODUCT_UOM_ID,  
         C_ORDER o, C_UOM uom, M_PRODUCT p, C_DOCTYPE dt
         WHERE o.C_ORDER_ID = l.C_ORDER_ID 
         AND o.C_DOCTYPE_ID = dt.C_DOCTYPE_ID

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to