From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Mon, 7 May 2018 06:59:22 +0000 (+0200)
Subject: The function get_customer_trans_details now includes itemPrice ex tax in SQL.
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=51424b406ea62e399fed7f88e55028e7b0731963

The function get_customer_trans_details now includes itemPrice ex tax in SQL.
---

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 "