details: https://code.openbravo.com/erp/devel/pi/rev/34fb7ad71646
changeset: 22063:34fb7ad71646
user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at>
openbravo.com>
date: Wed Feb 19 21:14:42 2014 +0530
summary: Fixes Issue 25733: Not homogeneous behaviour in Sales management flow
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 6
+++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (30 lines):
diff -r c87386c4f1f7 -r 34fb7ad71646
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Wed Feb 19 14:11:41 2014 +0000
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Wed Feb 19 21:14:42 2014 +0530
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2013 Openbravo SLU
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): Cheli Pineda__________________________.
************************************************************************
@@ -301,7 +301,7 @@
l.C_UOM_ID,uom.UOMSymbol,
l.M_Product_ID,Ad_Column_Identifier(to_char('M_Product'),
to_char(l.m_product_id), to_char(?)) AS NAME,
l.C_OrderLine_ID,l.Line, max(uom.stdprecision) AS stdprecision,
cur.priceprecision, il.M_InOutLine_ID as M_InOutLine_ID, l.Description,
(CASE WHEN il.M_INOUTLINE_ID IS NULL THEN
l.quantityOrder*C_DIVIDE((l.QtyOrdered-COALESCE(l.QTYINVOICED
,0)),(l.QtyOrdered)) ELSE il.quantityOrder END) AS quantityOrder,
- (CASE WHEN il.M_INOUTLINE_ID IS NULL THEN l.M_Product_UOM_ID ELSE
il.M_Product_UOM_ID END) AS M_Product_UOM_ID, l.M_ATTRIBUTESETINSTANCE_ID,
l.ad_org_id,
+ (CASE WHEN il.M_INOUTLINE_ID IS NULL THEN l.M_Product_UOM_ID ELSE
il.M_Product_UOM_ID END) AS M_Product_UOM_ID,
COALESCE(l.M_ATTRIBUTESETINSTANCE_ID, il.M_ATTRIBUTESETINSTANCE_ID) AS
M_ATTRIBUTESETINSTANCE_ID, l.ad_org_id,
l.taxbaseamt, COALESCE(l.A_Asset_ID, o.A_Asset_ID) as A_Asset_ID,
COALESCE(l.C_Project_ID, o.C_Project_ID) as C_Project_ID,
COALESCE(l.C_Costcenter_ID, o.C_Costcenter_ID) as C_Costcenter_ID,
COALESCE(l.User1_ID, o.User1_ID) as User1_ID, COALESCE(l.User2_ID, o.User2_ID)
as User2_ID, l.explode, 'Y' as isOrder
FROM C_ORDERLINE l left join (SELECT M_InOutLine.* FROM M_InOutLine,
M_InOut
@@ -314,7 +314,7 @@
AND l.M_Product_ID=p.M_Product_ID
GROUP BY
l.QtyOrdered,l.qtydelivered,l.C_UOM_ID,uom.UOMSymbol,l.M_Product_ID,p.NAME,l.Line,l.C_OrderLine_ID,
l.QTYINVOICED, il.M_InOutLine_ID, il.MovementQty, l.Description,
l.quantityOrder, il.quantityOrder,
- l.M_Product_UOM_ID, il.M_Product_UOM_ID,
l.M_ATTRIBUTESETINSTANCE_ID,l.ad_org_id, cur.priceprecision,
+ l.M_Product_UOM_ID, il.M_Product_UOM_ID,
COALESCE(l.M_ATTRIBUTESETINSTANCE_ID,
il.M_ATTRIBUTESETINSTANCE_ID),l.ad_org_id, cur.priceprecision,
l.taxbaseamt, COALESCE(l.A_Asset_ID, o.A_Asset_ID),
COALESCE(l.C_Project_ID, o.C_Project_ID), COALESCE(l.C_Costcenter_ID,
o.C_Costcenter_ID),
COALESCE(l.User1_ID, o.User1_ID), COALESCE(l.User2_ID, o.User2_ID),
l.explode
HAVING ( (l.explode='Y') OR ((l.QtyOrdered-COALESCE(l.QTYINVOICED ,0))
<> 0))
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
