- $sql = "SELECT taxrec.*, IF(ISNULL(dtrans.rate),IF(ISNULL(strans.rate), taxrec.amount, taxrec.amount*strans.rate),
- taxrec.amount*dtrans.rate) AS amount,
- IF(ISNULL(dtrans.rate),IF(ISNULL(strans.rate), taxrec.net_amount,taxrec.net_amount*strans.rate),
- taxrec.net_amount*dtrans.rate) AS net_amount,
+ $sql = "SELECT taxrec.*, taxrec.amount*ex_rate AS amount,
+ taxrec.net_amount*ex_rate AS net_amount,