X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep205.php;h=4b27c182c697804ba060d71be0d8473f254d3c5c;hb=5a3cbfe6d2df1c8c32edcab8bf93e8a8432a15fc;hp=d2f500b3957d5f2f85fa4c599ba443dc5d35f7b7;hpb=8ffddf50ffbe93672c769e2cf0501d0f9125e2a0;p=fa-stable.git

diff --git a/reporting/rep205.php b/reporting/rep205.php
index d2f500b3..4b27c182 100644
--- a/reporting/rep205.php
+++ b/reporting/rep205.php
@@ -30,20 +30,11 @@ print_supplier_details_listing();
 
 function get_supplier_details_for_report()
 {
-	$sql = "SELECT ".TB_PREF."suppliers.supplier_id,
-			".TB_PREF."suppliers.supp_name,
-			".TB_PREF."suppliers.address,
-			".TB_PREF."suppliers.supp_address,
-			".TB_PREF."suppliers.supp_ref,
-			".TB_PREF."suppliers.contact,
-			".TB_PREF."suppliers.curr_code,
-			".TB_PREF."suppliers.dimension_id,
-			".TB_PREF."suppliers.dimension2_id,
-			".TB_PREF."suppliers.notes,
-			".TB_PREF."suppliers.gst_no
-		FROM ".TB_PREF."suppliers
-		WHERE inactive = 0
-	 	ORDER BY supp_name";
+	$sql = "SELECT supplier_id,	supp_name, address, supp_address, supp_ref,
+				contact, curr_code,	dimension_id, dimension2_id, notes, gst_no
+			FROM ".TB_PREF."suppliers
+			WHERE inactive = 0
+	 		ORDER BY supp_name";
 
     return db_query($sql,"No transactions were returned");
 }
@@ -133,7 +124,7 @@ function print_supplier_details_listing()
 		{
 			$newrow = 0;
 			$rep->NewLine();
-			// Here starts the new report lines 2013-01-28 Joe Hunt
+			// Here starts the new report lines
 			$contacts = get_supplier_contacts($myrow['supplier_id']);
 			$rep->TextCol(0, 1,	$myrow['supp_name']);
 			$rep->TextCol(1, 2,	_('Tax_Id') . ": " . $myrow['gst_no']);