X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep205.php;h=4b27c182c697804ba060d71be0d8473f254d3c5c;hb=25379bdc9f10bda4aae4b37f04d16eb1bbe7e4f6;hp=b94ebca349c1a34cb4c8187cff40b39e50991730;hpb=5b8f4c4b4aa8cf996bc071f116bfce1273200fa2;p=fa-stable.git diff --git a/reporting/rep205.php b/reporting/rep205.php index b94ebca3..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']); @@ -176,7 +167,7 @@ function print_supplier_details_listing() { $oldrow = $rep->row; $rep->NewLine(); - $rep->TextColLines(1, 2, _("Gereral Notes:")." ".$myrow['notes'], -2); + $rep->TextColLines(1, 2, _("General Notes:")." ".$myrow['notes'], -2); $newrow = $rep->row; $rep->row = $oldrow; }