diff --git a/src-db/database/model/functions/M_PROMOTION_CALCULATE.xml b/src-db/database/model/functions/M_PROMOTION_CALCULATE.xml
--- a/src-db/database/model/functions/M_PROMOTION_CALCULATE.xml
+++ b/src-db/database/model/functions/M_PROMOTION_CALCULATE.xml
@@ -81,7 +81,7 @@
                      where c_order_id = p_doc_id
                        and p_type = 'O'
                      union
-                    select c_invoiceline_id, gross_unit_price, c_tax_id, 'N', 
+                    select c_invoiceline_id, gross_unit_price, c_tax_id, financial_invoice_line, 
                            M_Product_ID, ad_client_id, ad_org_id, c_orderline_id, line
                       from c_invoiceline 
                      where c_invoice_id = p_doc_id