From f393f0b6e6dbd73b8371cc0ebf2d858b05592d30 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 13 Jan 2020 15:53:39 +0100 Subject: [PATCH] Sales Order Inquiry Sort Descenting?, Fixed. --- sales/includes/db/sales_order_db.inc | 3 ++- sales/inquiry/sales_orders_view.php | 4 ++-- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index 5da5cc56..efbf7ae0 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -557,7 +557,8 @@ function get_sql_for_sales_orders_view($trans_type, $trans_no, $filter, sorder.branch_code, sorder.customer_ref, sorder.ord_date, - sorder.deliver_to"; + sorder.deliver_to + ORDER BY sorder.order_no DESC"; return $sql; } diff --git a/sales/inquiry/sales_orders_view.php b/sales/inquiry/sales_orders_view.php index bc088899..6a7186d9 100644 --- a/sales/inquiry/sales_orders_view.php +++ b/sales/inquiry/sales_orders_view.php @@ -254,7 +254,7 @@ $sql = get_sql_for_sales_orders_view($trans_type, get_post('OrderNumber'), get_p if ($trans_type == ST_SALESORDER) $cols = array( - _("Order #") => array('fun'=>'view_link', 'align'=>'right'), + _("Order #") => array('fun'=>'view_link', 'align'=>'right', 'ord' =>''), _("Ref") => array('type' => 'sorder.reference', 'ord' => '') , _("Customer") => array('type' => 'debtor.name' , 'ord' => '') , _("Branch"), @@ -268,7 +268,7 @@ if ($trans_type == ST_SALESORDER) ); else $cols = array( - _("Quote #") => array('fun'=>'view_link', 'align'=>'right'), + _("Quote #") => array('fun'=>'view_link', 'align'=>'right', 'ord' => ''), _("Ref"), _("Customer"), _("Branch"), -- 2.30.2