" . _("CREDIT NOTE") . " #$trans_id"); echo "
"; start_table("$table_style2 width=95%"); echo ""; // outer table /*Now the customer charged to details in a sub table*/ start_table("$table_style width=100%"); $th = array(_("Customer")); table_header($th); label_row(null, $myrow["DebtorName"] . "
" . nl2br($myrow["address"]), "nowrap"); end_table(); /*end of the small table showing charge to account details */ echo ""; // outer table start_table("$table_style width=100%"); $th = array(_("Branch")); table_header($th); label_row(null, $branch["br_name"] . "
" . nl2br($branch["br_address"]), "nowrap"); end_table(); echo ""; // outer table start_table("$table_style width=100%"); start_row(); label_cells(_("Ref"), $myrow["reference"], "class='tableheader2'"); label_cells(_("Date"), sql2date($myrow["tran_date"]), "class='tableheader2'"); label_cells(_("Currency"), $myrow["curr_code"], "class='tableheader2'"); end_row(); start_row(); label_cells(_("Sales Type"), $myrow["sales_type"], "class='tableheader2'"); label_cells(_("Shipping Company"), $myrow["shipper_name"], "class='tableheader2'"); end_row(); comments_display_row(11, $trans_id); end_table(); echo ""; end_table(1); // outer table $sub_total = 0; $result = get_customer_trans_details(11, $trans_id); start_table("$table_style width=95%"); if (db_num_rows($result) > 0) { $th = array(_("Item Code"), _("Item Description"), _("Quantity"), _("Unit"), _("Price"), _("Discount %"), _("Total")); table_header($th); $k = 0; //row colour counter $sub_total = 0; while ($myrow2 = db_fetch($result)) { alt_table_row_color($k); $net = ((1 - $myrow2["discount_percent"]) * $myrow2["FullUnitPrice"] * $myrow2["quantity"]); $sub_total += $net; if ($myrow2["discount_percent"] == 0) { $display_discount = ""; } else { $display_discount = number_format2($myrow2["discount_percent"]*100,user_percent_dec()) . "%"; } label_cell($myrow2["stock_id"]); label_cell($myrow2["StockDescription"]); qty_cell($myrow2["quantity"]); label_cell($myrow2["units"], "align=right"); amount_cell($myrow2["FullUnitPrice"]); label_cell($display_discount, "align=right"); amount_cell($net); end_row(); } //end while there are line items to print out } else display_note(_("There are no line items on this credit note."), 1, 2); $display_sub_tot = number_format2($sub_total,user_price_dec()); $display_freight = number_format2(-$myrow["ov_freight"],user_price_dec()); $display_tax = number_format2(-$myrow["ov_gst"],user_price_dec()); $credit_total = -$myrow["ov_freight"]-$myrow["ov_gst"]-$myrow["ov_amount"]; $display_total = number_format2($credit_total,user_price_dec()); /*Print out the invoice text entered */ if ($sub_total != 0) label_row(_("Sub Total"), $display_sub_tot, "colspan=6 align=right", "nowrap align=right width=15%"); label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right"); $tax_items = get_customer_trans_tax_details(11, $trans_id); display_customer_trans_tax_details($tax_items, 6); label_row("" . _("TOTAL CREDIT") . "$display_total", "colspan=6 align=right", "nowrap align=right"); end_table(1); $voided = is_voided_display(11, $trans_id, _("This credit note has been voided.")); if (!$voided) display_allocations_from(payment_person_types::customer(), $myrow['debtor_no'], 11, $trans_id, $credit_total); /* end of check to see that there was an invoice record to print */ end_page(true); ?>