- FROM ".TB_PREF."supp_trans,
- ".TB_PREF."sys_types
- WHERE ".TB_PREF."sys_types.type_id = ".TB_PREF."supp_trans.type
- AND ".TB_PREF."supp_trans.supplier_id = '" . $supplier . "'
- AND ABS(".TB_PREF."supp_trans.ov_amount) + ABS(".TB_PREF."supp_trans.ov_gst) - ".TB_PREF."supp_trans.alloc != 0
+ FROM ".TB_PREF."supp_trans
+ WHERE ".TB_PREF."supp_trans.supplier_id = '" . $supplier . "'
+ AND ROUND(ABS(".TB_PREF."supp_trans.ov_amount),$dec) + ROUND(ABS(".TB_PREF."supp_trans.ov_gst),$dec) -
+ ROUND(".TB_PREF."supp_trans.alloc,$dec) != 0