Fixes Issue 25989: Lot information not populated in Sales Invoices using Generate Invoices process regarding Sales Orders
authorPandeeswari Ramakrishnan <pandeeswari.ramakrishnan@openbravo.com>
Tue, 18 Mar 2014 17:31:42 +0530
changeset 22732 a368fe956596
parent 22731 9f9e444b81de
child 22733 614f58fa156d
child 22734 a4bac660abf1
Fixes Issue 25989: Lot information not populated in Sales Invoices using Generate Invoices process regarding Sales Orders
src-db/database/model/functions/C_INVOICE_CREATE.xml
--- a/src-db/database/model/functions/C_INVOICE_CREATE.xml	Wed Mar 19 01:41:17 2014 +0000
+++ b/src-db/database/model/functions/C_INVOICE_CREATE.xml	Tue Mar 18 17:31:42 2014 +0530
@@ -25,7 +25,7 @@
   * parts created by ComPiere are Copyright (C) ComPiere, Inc.;
   * All Rights Reserved.
   * Contributor(s): Openbravo SLU
-  * Contributions are Copyright (C) 2001-2013 Openbravo, S.L.U.
+  * Contributions are Copyright (C) 2001-2014 Openbravo, S.L.U.
   *
   * Specifically, this derivative work is based upon the following Compiere
   * file and version.
@@ -127,7 +127,7 @@
           ol.Line,
           ol.DirectShip,
           ol.PriceStd,
-          ol.m_attributesetinstance_id,
+          COALESCE(ol.m_attributesetinstance_id, sl.m_attributesetinstance_id) AS m_attributesetinstance_id,
           ol.taxbaseamt,
           ol.gross_unit_price,
           ol.grosspricestd,
@@ -900,7 +900,7 @@
                 sh.movementDate,
                 ol.PriceStd,
                 ol.gross_unit_price,
-                ol.m_attributesetinstance_id,
+                COALESCE(ol.m_attributesetinstance_id, sl.m_attributesetinstance_id) AS m_attributesetinstance_id,
                 ol.taxbaseamt, o.fin_paymentmethod_id,
                 pl.istaxincluded,
                 ol.grosspricestd,