X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep210.php;h=3af1bafbc2eb4ab27bd552d9a08f678ecb25961e;hb=7561718ee5113232ce917f63085d272884b0929c;hp=0b3f92a4463db6bd3962471d38993c54f78e8ac5;hpb=6a4d8e6c1e92ff1b8fc5abb3fae76fb1c1968550;p=fa-stable.git diff --git a/reporting/rep210.php b/reporting/rep210.php index 0b3f92a4..3af1bafb 100644 --- a/reporting/rep210.php +++ b/reporting/rep210.php @@ -33,7 +33,8 @@ print_remittances(); function get_remittance($type, $trans_no) { $sql = "SELECT ".TB_PREF."supp_trans.*, - (".TB_PREF."supp_trans.ov_amount+".TB_PREF."supp_trans.ov_gst+".TB_PREF."supp_trans.ov_discount) AS Total, + (".TB_PREF."supp_trans.ov_amount+".TB_PREF."supp_trans.ov_gst) AS Total, + ".TB_PREF."supp_trans.ov_discount, ".TB_PREF."suppliers.supp_name, ".TB_PREF."suppliers.supp_account_no, ".TB_PREF."suppliers.curr_code, ".TB_PREF."suppliers.payment_terms, ".TB_PREF."suppliers.gst_no AS tax_id, ".TB_PREF."suppliers.address @@ -104,14 +105,14 @@ function print_remittances() $rep = new FrontReport("", "", user_pagesize(), 9, $orientation); $rep->title = _('REMITTANCE'); $rep->filename = "Remittance" . $i . ".pdf"; - } - $rep->SetHeaderType('Header2'); + } $rep->currency = $cur; $rep->Font(); $rep->Info($params, $cols, null, $aligns); $contacts = get_supplier_contacts($myrow['supplier_id'], 'invoice'); $rep->SetCommonData($myrow, null, $myrow, $baccount, ST_SUPPAYMENT, $contacts); + $rep->SetHeaderType('Header2'); $rep->NewPage(); $result = get_allocatable_to_supp_transactions($myrow['supplier_id'], $myrow['trans_no'], $myrow['type']); @@ -143,18 +144,27 @@ function print_remittances() $rep->NewLine(); $rep->TextColLines(1, 5, $memo, -2); } - $rep->row = $rep->bottomMargin + (15 * $rep->lineHeight); + $rep->row = $rep->bottomMargin + (16 * $rep->lineHeight); $rep->TextCol(3, 6, _("Total Allocated"), -2); $rep->AmountCol(6, 7, $total_allocated, $dec, -2); $rep->NewLine(); $rep->TextCol(3, 6, _("Left to Allocate"), -2); $myrow['Total'] *= -1; - $rep->AmountCol(6, 7, $myrow['Total'] - $total_allocated, $dec, -2); + $myrow['ov_discount'] *= -1; + $rep->AmountCol(6, 7, $myrow['Total'] + $myrow['ov_discount'] - $total_allocated, $dec, -2); + if (floatcmp($myrow['ov_discount'], 0)) + { + $rep->NewLine(); + $rep->TextCol(3, 6, _("Discount"), - 2); + $rep->AmountCol(6, 7, -$myrow['ov_discount'], $dec, -2); + } + $rep->NewLine(); $rep->Font('bold'); $rep->TextCol(3, 6, _("TOTAL REMITTANCE"), - 2); $rep->AmountCol(6, 7, $myrow['Total'], $dec, -2); + $words = price_in_words($myrow['Total'], ST_SUPPAYMENT); if ($words != "") { @@ -173,4 +183,3 @@ function print_remittances() $rep->End(); } -?> \ No newline at end of file