X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Forder_lines.inc;h=891da684cd16f4e064109f87f0ac69bcaa64502b;hb=e83dd263203cb4f16aec72e084825198b5e12259;hp=dc09a6bcf57d12ddd710fbadfdaa24ebf310e22e;hpb=791f2f0482e01d5d152091edb5ef267300c91d26;p=order_line_extra.git diff --git a/includes/order_lines.inc b/includes/order_lines.inc index dc09a6b..891da68 100644 --- a/includes/order_lines.inc +++ b/includes/order_lines.inc @@ -196,7 +196,7 @@ function get_order_summary($location) { , sum(sub.amount) as amount , sum(greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)) , sum(sub.amount*greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)/sub.quantity) - , `min(required_date)` + , min(`min(required_date)`) , group_concat(distinct order_comment separator ';') as order_comment , group_concat(distinct detail_comment separator ';') as detail_comment FROM $sub sub