. ***********************************************************************/ $page_security = 'SA_SALESTRANSVIEW'; $path_to_root = "../.."; include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/includes/ui.inc"); include_once($path_to_root . "/sales/includes/sales_db.inc"); $js = ""; if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(900, 500); page(_($help_context = "View Credit Note"), true, false, "", $js); if (isset($_GET["trans_no"])) { $trans_id = $_GET["trans_no"]; } elseif (isset($_POST["trans_no"])) { $trans_id = $_POST["trans_no"]; } $myrow = get_customer_trans($trans_id, ST_CUSTCREDIT); $branch = get_branch($myrow["branch_code"]); display_heading("" . sprintf(_("CREDIT NOTE #%d"), $trans_id). ""); echo "
"; start_table(TABLESTYLE2, "width='95%'"); echo ""; // outer table /*Now the customer charged to details in a sub table*/ start_table(TABLESTYLE, "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(TABLESTYLE, "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(TABLESTYLE, "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(ST_CUSTCREDIT, $trans_id); end_table(); echo ""; end_table(1); // outer table $sub_total = 0; $result = get_customer_trans_details(ST_CUSTCREDIT, $trans_id); start_table(TABLESTYLE, "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)) { if ($myrow2["quantity"] == 0) continue; alt_table_row_color($k); $value = round2(((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec()); $sub_total += $value; if ($myrow2["discount_percent"] == 0) { $display_discount = ""; } else { $display_discount = percent_format($myrow2["discount_percent"]*100) . "%"; } label_cell($myrow2["stock_id"]); label_cell($myrow2["StockDescription"]); qty_cell($myrow2["quantity"], false, get_qty_dec($myrow2["stock_id"])); label_cell($myrow2["units"], "align=right"); amount_cell($myrow2["unit_price"]); label_cell($display_discount, "align=right"); amount_cell($value); 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 = price_format($sub_total); $credit_total = $myrow["ov_freight"]+$myrow["ov_gst"]+$myrow["ov_amount"]+$myrow["ov_freight_tax"]; $display_total = price_format($credit_total); /*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%'"); if ($myrow["ov_freight"] != 0.0) { $display_freight = price_format($myrow["ov_freight"]); label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right"); } $tax_items = get_trans_tax_details(ST_CUSTCREDIT, $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(ST_CUSTCREDIT, $trans_id, _("This credit note has been voided.")); if (!$voided) display_allocations_from(PT_CUSTOMER, $myrow['debtor_no'], ST_CUSTCREDIT, $trans_id, $credit_total); /* end of check to see that there was an invoice record to print */ end_page(true, false, false, ST_CUSTCREDIT, $trans_id);