{
$from = date2sql($from);
$to = date2sql($to);
-
+
$sql = "SELECT ".TB_PREF."grn_batch.id batch_no,
".TB_PREF."grn_batch.supplier_id,
".TB_PREF."purch_order_details.*,
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";
-
+
return db_query($sql,"No transactions were returned");
}
$rep->TextCol(2, 3, $trans['order_no']);
$qdec = get_qty_dec($trans['item_code']);
$rep->TextCol(3, 4, $trans['batch_no']);
-
+
if ($trans['quantity_inv'])
{
$suppinv = getSuppInvDetails($trans['grn_item_id']);