details: /erp/devel/pi/rev/8c73191b4b40
changeset: 9852:8c73191b4b40
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon Jan 17 12:23:39 2011 +0100
summary: Issue 14513: Create Lines From Goods Receipt loads quantity of
primary unit in both primary and secondary unit
Reverts changeset 8424 a4c4d0f0a33c
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql | 5
+++--
1 files changed, 3 insertions(+), 2 deletions(-)
diffs (15 lines):
diff -r a8a9ffdb50d5 -r 8c73191b4b40
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Mon Jan 17 11:15:59 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Mon Jan 17 12:23:39 2011 +0100
@@ -33,8 +33,9 @@
'' AS C_UOM_ID_Conversion, '' AS QUANTITYORDER, '' AS
M_Product_UOM_ID, l.M_ATTRIBUTESETINSTANCE_ID AS M_ATTRIBUTESETINSTANCE_ID,
l.C_OrderLine_ID AS ID, '' AS C_Invoice_ID, l.DESCRIPTION AS
DESCRIPTION,
((l.QtyOrdered-SUM(COALESCE(m.Qty,0)))/COALESCE(
- (SELECT DIVIDERATE FROM C_UOM_CONVERSION WHERE
C_UOM_CONVERSION.C_UOM_ID = l.C_UOM_ID
- AND C_UOM_CONVERSION.C_UOM_TO_ID = (SELECT C_UOM.C_UOM_ID FROM
M_PRODUCT_UOM, C_UOM WHERE M_PRODUCT_UOM_ID = l.M_PRODUCT_UOM_ID AND
M_PRODUCT_UOM.C_UOM_ID = C_UOM.C_UOM_ID)),1))
+ (SELECT MULTIPLYRATE FROM C_UOM_CONVERSION WHERE
C_UOM_CONVERSION.C_UOM_ID =
+ (SELECT C_UOM.C_UOM_ID FROM M_PRODUCT_UOM, C_UOM WHERE
M_PRODUCT_UOM_ID = l.M_PRODUCT_UOM_ID AND M_PRODUCT_UOM.C_UOM_ID =
C_UOM.C_UOM_ID)
+ AND C_UOM_CONVERSION.C_UOM_TO_ID = l.C_UOM_ID),1))
as SECQTY, l.M_PRODUCT_UOM_ID as SEC_PRODUCT_UOM_ID,
(SELECT M_ATTRIBUTESETINSTANCE.DESCRIPTION FROM M_ATTRIBUTESETINSTANCE
WHERE
l.M_ATTRIBUTESETINSTANCE_ID =
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID) as ATTRIBUTESETINSTANCENAME,
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
