- $sql = "SELECT ".TB_PREF."grn_batch.id batch_no,
- ".TB_PREF."grn_batch.supplier_id,
- ".TB_PREF."purch_order_details.*,
- ".TB_PREF."stock_master.description,
- ".TB_PREF."grn_items.qty_recd,
- ".TB_PREF."grn_items.quantity_inv,
- ".TB_PREF."grn_items.id grn_item_id
- FROM ".TB_PREF."stock_master,
- ".TB_PREF."purch_order_details,
- ".TB_PREF."grn_batch,
- ".TB_PREF."grn_items
- WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."purch_order_details.item_code
- AND ".TB_PREF."grn_batch.purch_order_no=".TB_PREF."purch_order_details.order_no
- AND ".TB_PREF."grn_batch.id = ".TB_PREF."grn_items.grn_batch_id
- AND ".TB_PREF."grn_items.po_detail_item = ".TB_PREF."purch_order_details.po_detail_item
- AND ".TB_PREF."grn_items.qty_recd>0
- AND ".TB_PREF."grn_batch.delivery_date>='$from'
- AND ".TB_PREF."grn_batch.delivery_date<='$to'
- ORDER BY ".TB_PREF."stock_master.stock_id, ".TB_PREF."grn_batch.delivery_date";
+ $sql = "SELECT grn.id batch_no,
+ grn.supplier_id,
+ poline.*,
+ item.description,
+ grn_line.qty_recd,
+ grn_line.quantity_inv,
+ grn_line.id grn_item_id
+ FROM "
+ .TB_PREF."stock_master item,"
+ .TB_PREF."purch_order_details poline,"
+ .TB_PREF."grn_batch grn,"
+ .TB_PREF."grn_items grn_line
+ WHERE item.stock_id=poline.item_code
+ AND grn.purch_order_no=poline.order_no
+ AND grn.id = grn_line.grn_batch_id
+ AND grn_line.po_detail_item = poline.po_detail_item
+ AND grn_line.qty_recd>0
+ AND grn.delivery_date>='$from'
+ AND grn.delivery_date<='$to'
+ AND item.mb_flag <>'F'
+ ORDER BY item.stock_id, grn.delivery_date";