From 406b264c2ff690cdfcd797aea92ba137baee8c8f Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 13 Jun 2020 09:17:55 +0200 Subject: [PATCH] Delivery Against Sales Order Inquiry View, Wrong Remainder Value. Fixed. --- sales/includes/db/sales_order_db.inc | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index efbf7ae0..a6bb878c 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -464,6 +464,10 @@ function get_branch_to_order($customer_id, $branch_id) { function get_sql_for_sales_orders_view($trans_type, $trans_no, $filter, $stock_item='', $from='', $to='', $ref='', $location=ALL_TEXT, $customer_id=ALL_TEXT) { + if ($filter=='OutstandingOnly') + $order_value = 'Sum(line.unit_price*(line.quantity-line.qty_sent)*(1-line.discount_percent))+freight_cost'; + else + $order_value = 'Sum(line.unit_price*line.quantity*(1-line.discount_percent))+freight_cost'; $sql = "SELECT sorder.order_no, @@ -476,7 +480,7 @@ function get_sql_for_sales_orders_view($trans_type, $trans_no, $filter, ."sorder.ord_date, sorder.delivery_date, sorder.deliver_to, - Sum(line.unit_price*line.quantity*(1-line.discount_percent))+freight_cost AS OrderValue, + $order_value AS OrderValue, sorder.type, debtor.curr_code, Sum(line.qty_sent) AS TotDelivered, -- 2.30.2