X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep108.php;h=27063c609e517e8cf2db4591037374a869534aca;hb=b0c4c9777f9574e9c2805fddc2a12576d75d94ce;hp=894e7f61e5442fcc4afcbf9047ec3d1e7842adc9;hpb=00d6656483e9b0630e325f0772268223b6762ece;p=fa-stable.git diff --git a/reporting/rep108.php b/reporting/rep108.php index 894e7f61..27063c60 100644 --- a/reporting/rep108.php +++ b/reporting/rep108.php @@ -44,7 +44,7 @@ function getTransactions($debtorno, $date, $show_also_allocated) AND ABS(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_freight_tax + ".TB_PREF."debtor_trans.ov_discount) > 1e-6"; if (!$show_also_allocated) - $sql .= " AND ABS (ABS(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + + $sql .= " AND ABS(ABS(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_freight_tax + ".TB_PREF."debtor_trans.ov_discount) - alloc) > 1e-6"; $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date"; @@ -83,9 +83,9 @@ function print_statements() if ($email == 0) $rep = new FrontReport(_('STATEMENT'), "StatementBulk", user_pagesize(), 9, $orientation); - if ($orientation == 'L') + if ($orientation == 'L') recalculate_cols($cols); - + $sql = "SELECT debtor_no, name AS DebtorName, address, tax_id, curr_code, curdate() AS tran_date FROM ".TB_PREF."debtors_master"; if ($customer != ALL_TEXT) $sql .= " WHERE debtor_no = ".db_escape($customer); @@ -174,4 +174,3 @@ function print_statements() $rep->End(); } -?>