From 51424b406ea62e399fed7f88e55028e7b0731963 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 7 May 2018 08:59:22 +0200 Subject: [PATCH] The function get_customer_trans_details now includes itemPrice ex tax in SQL. --- sales/includes/db/cust_trans_details_db.inc | 1 + 1 file changed, 1 insertion(+) diff --git a/sales/includes/db/cust_trans_details_db.inc b/sales/includes/db/cust_trans_details_db.inc index ffef4e51..b4b93314 100644 --- 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 " -- 2.30.2