changeset: 33638:5dbcb5394a22
user:      Mark <markmm82 <at>>
date:      Thu Mar 01 18:45:40 2018 -0500
summary:   Fixes issue 37960: When not stocked product is exploded before 
booking the order
and price includes taxes, Gross Unit Price is updated to 0.

When the it is exploded a BOM line with not stock and the price list includes 
then the M_EXPLODEBOMNOTSTOCK function was creating lines with the 
grosspricelist and line_gross_amount values, but it wasn't copying the 
column and it was taking 0 as default value.

For this reason, when the order was booked, as the Explode process sets the
grosspricestd to 0, M_PROMOTION_CALCULATE function uses and transfers it for the
gross_unit_price column.

To fix this issue, the grosspricestd is also inserted into the exploded lines at
line insertion in M_EXPLODEBOMNOTSTOCK PL.


 src-db/database/model/functions/M_EXPLODEBOMNOTSTOCK.xml |  7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diffs (31 lines):

diff -r ce890b7032d4 -r 5dbcb5394a22 
--- a/src-db/database/model/functions/M_EXPLODEBOMNOTSTOCK.xml  Tue Mar 06 
09:07:37 2018 +0100
+++ b/src-db/database/model/functions/M_EXPLODEBOMNOTSTOCK.xml  Thu Mar 01 
18:45:40 2018 -0500
@@ -19,7 +19,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) 2013-2017 Openbravo SLU
+* All portions are Copyright (C) 2013-2018 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
@@ -193,7 +193,7 @@
             QuantityOrder, M_Product_Uom_ID, PriceStd,
             c_project_id, a_asset_id, c_costcenter_id,
             user1_id, user2_id, bom_parent_id,
-            gross_unit_price, grosspricelist, line_gross_amount,
+            gross_unit_price, grosspricelist, line_gross_amount, grosspricestd,
             c_aum, aumqty
@@ -212,7 +212,8 @@
             CUR_BOM_Line.QuantityOrder, CUR_BOM_Line.M_Product_UOM_ID, 
M_BOM_PriceStd(CUR_BOM.M_ProductBOM_ID, v_PriceList_Version_ID),
             CUR_BOM_Line.c_project_id, CUR_BOM_Line.a_asset_id, 
             CUR_BOM_Line.user1_id, CUR_BOM_Line.user2_id, v_Record_ID,
-            v_gross_unit_price, v_gross_price_list, v_line_gross_amount, 
v_aum, v_aumqty*CUR_BOM.BOMQty
+            v_gross_unit_price, v_gross_price_list, v_line_gross_amount, 
+            v_aum, v_aumqty*CUR_BOM.BOMQty
           INTO v_BaseAmount

Check out the vibrant tech community on one of the world's most
engaging tech sites,!
Openbravo-commits mailing list

Reply via email to