X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fsales_db.inc;h=55d6138516dfee8b84464be2176db5d81f8453f1;hb=41f4f83b97d8afc5f4c1be4afccd5049cd5641c0;hp=e3b3e5a34752fa304d8bef0e191487b6ded1b598;hpb=0c1bcd8ce3c089d7ddb3722a097f8fc8417f41e6;p=fa-stable.git

diff --git a/sales/includes/sales_db.inc b/sales/includes/sales_db.inc
index e3b3e5a3..55d61385 100644
--- a/sales/includes/sales_db.inc
+++ b/sales/includes/sales_db.inc
@@ -46,14 +46,13 @@ function add_gl_trans_customer($type, $type_no, $date_, $account, $dimension, $d
 
 //----------------------------------------------------------------------------------------
 
-function get_price ($stock_id, $debtor_no)
+function get_price ($stock_id, $currency, $sales_type_id)
 {
 	$sql = "SELECT ".TB_PREF."prices.price
-		FROM ".TB_PREF."prices, ".TB_PREF."debtors_master
-		WHERE ".TB_PREF."debtors_master.sales_type=".TB_PREF."prices.sales_type_id
-			AND ".TB_PREF."debtors_master.debtor_no='" . $debtor_no . "'
-			AND ".TB_PREF."prices.stock_id = '" . $stock_id . "'
-			AND ".TB_PREF."prices.curr_abrev = ".TB_PREF."debtors_master.curr_code";
+		FROM ".TB_PREF."prices
+		WHERE ".TB_PREF."prices.stock_id = '" . $stock_id . "'
+		  AND ".TB_PREF."prices.sales_type_id = " . $sales_type_id . "
+		  AND ".TB_PREF."prices.curr_abrev = '$currency'";
 
 	$result = db_query($sql, "There was a problem retrieving the pricing information for the part $stock_id for customer");