The function get_customer_trans_details now includes itemPrice ex tax in SQL.

[fa-stable.git] / sales / includes / db / cust_trans_details_db.inc

diff --git a/sales/includes/db/cust_trans_details_db.inc b/sales/includes/db/cust_trans_details_db.inc
index ffef4e5159da71ed8b2f6f7f854e68effeb84b7c..b4b9331450bf4d0f50d26992b17bc1992d519a2a 100644 (file)
--- a/sales/includes/db/cust_trans_details_db.inc
+++ b/sales/includes/db/cust_trans_details_db.inc
@@ -18,6 +18,7 @@ if (!is_array($debtor_trans_no))
 
        $sql = "SELECT line.*,
                line.unit_price+line.unit_tax AS FullUnitPrice,
+        line.unit_price AS UnitPriceExTax,  
                line.description As StockDescription,
                item.units, item.mb_flag
                FROM "