+function get_open_balance($supplier_id, $to, $convert)
+{
+ $to = date2sql($to);
+
+ $sql = "SELECT SUM(IF(".TB_PREF."supp_trans.type = ".ST_SUPPINVOICE.", (".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst +
+ ".TB_PREF."supp_trans.ov_discount)";
+ if ($convert)
+ $sql .= " * rate";
+ $sql .= ", 0)) AS charges,
+ SUM(IF(".TB_PREF."supp_trans.type <> ".ST_SUPPINVOICE.", (".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst +
+ ".TB_PREF."supp_trans.ov_discount)";
+ if ($convert)
+ $sql .= "* rate";
+ $sql .= ", 0)) AS credits,
+ SUM(".TB_PREF."supp_trans.alloc";
+ if ($convert)
+ $sql .= " * rate";
+ $sql .= ") AS Allocated,
+ SUM((".TB_PREF."supp_trans.ov_amount + ".TB_PREF."supp_trans.ov_gst +
+ ".TB_PREF."supp_trans.ov_discount - ".TB_PREF."supp_trans.alloc)";
+ if ($convert)
+ $sql .= " * rate";
+ $sql .= ") AS OutStanding
+ FROM ".TB_PREF."supp_trans
+ WHERE ".TB_PREF."supp_trans.tran_date < '$to'
+ AND ".TB_PREF."supp_trans.supplier_id = '$supplier_id' GROUP BY supplier_id";
+
+ $result = db_query($sql,"No transactions were returned");
+ return db_fetch($result);
+}
+
+function getTransactions($supplier_id, $from, $to)