- porder.into_stock_location
- FROM ".TB_PREF."purch_orders as porder, "
+ porder.into_stock_location,
+ chk.isopen
+ FROM ".TB_PREF."purch_orders as porder
+ LEFT JOIN (
+ SELECT order_no, SUM(quantity_ordered-quantity_received + quantity_ordered-qty_invoiced) isopen
+ FROM ".TB_PREF."purch_order_details
+ GROUP BY order_no
+ ) chk ON chk.order_no=porder.order_no,"