From 541772bc00e5816d404a8859c994d73e59481023 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 17 May 2021 20:46:56 +0200 Subject: [PATCH] [0005245] Added debtors_master.debtor_ref to get_customer_trans() results --- sales/includes/db/cust_trans_db.inc | 1 + 1 file changed, 1 insertion(+) diff --git a/sales/includes/db/cust_trans_db.inc b/sales/includes/db/cust_trans_db.inc index 888181eb..401c7a54 100644 --- a/sales/includes/db/cust_trans_db.inc +++ b/sales/includes/db/cust_trans_db.inc @@ -125,6 +125,7 @@ function get_customer_trans($trans_id, $trans_type, $customer_id=null) $sql = "SELECT trans.*," ."ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total," ."cust.name AS DebtorName, cust.address, " + ."cust.debtor_ref, " ."cust.curr_code, " ."cust.tax_id, trans.prep_amount>0 as prepaid," -- 2.30.2