+function fmt_debit($row)
+{
+ $value = $row["TotalAmount"];
+ return $value>0 ? price_format($value) : '';
+
+}
+
+function fmt_credit($row)
+{
+ $value = -$row["TotalAmount"];
+ return $value>0 ? price_format($value) : '';
+}
+
+function prt_link($row)
+{
+ if ($row['type'] == ST_SUPPAYMENT || $row['type'] == ST_BANKPAYMENT || $row['type'] == ST_SUPPCREDIT)
+ return print_document_link($row['trans_no']."-".$row['type'], _("Print Remittance"), true, ST_SUPPAYMENT, ICON_PRINT);
+}
+
+function check_overdue($row)
+{
+ return $row['OverDue'] == 1
+ && (abs($row["TotalAmount"]) - $row["Allocated"] != 0);
+}
+//------------------------------------------------------------------------------------------------
+
+$sql = get_sql_for_supplier_inquiry($_POST['filterType'], $_POST['TransAfterDate'], $_POST['TransToDate'], $_POST['supplier_id']);
+
+$cols = array(
+ _("Type") => array('fun'=>'systype_name', 'ord'=>''),
+ _("#") => array('fun'=>'trans_view', 'ord'=>''),
+ _("Reference"),
+ _("Supplier"),
+ _("Supplier's Reference"),
+ _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'desc'),
+ _("Due Date") => array('type'=>'date', 'fun'=>'due_date'),
+ _("Currency") => array('align'=>'center'),
+ _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'),
+ _("Credit") => array('align'=>'right', 'insert'=>true,'fun'=>'fmt_credit'),
+ array('insert'=>true, 'fun'=>'gl_view'),
+ array('insert'=>true, 'fun'=>'credit_link'),
+ array('insert'=>true, 'fun'=>'prt_link')
+ );
+
+if ($_POST['supplier_id'] != ALL_TEXT)
+{
+ $cols[_("Supplier")] = 'skip';
+ $cols[_("Currency")] = 'skip';
+}