sales/customer_invoice.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 //---------------------------------------------------------------------------
  13 //
  14 //      Entry/Modify Sales Invoice against single delivery
  15 //      Entry/Modify Batch Sales Invoice against batch of deliveries
  16 //
  17 $page_security = 'SA_SALESINVOICE';
  18 $path_to_root = "..";
  19 include_once($path_to_root . "/sales/includes/cart_class.inc");
  20 include_once($path_to_root . "/includes/session.inc");
  21 include_once($path_to_root . "/includes/data_checks.inc");
  22 include_once($path_to_root . "/sales/includes/sales_db.inc");
  23 include_once($path_to_root . "/sales/includes/sales_ui.inc");
  24 include_once($path_to_root . "/reporting/includes/reporting.inc");
  25 include_once($path_to_root . "/taxes/tax_calc.inc");
  26 include_once($path_to_root . "/admin/db/shipping_db.inc");
  27
  28 $js = "";
  29 if ($SysPrefs->use_popup_windows) {
  30         $js .= get_js_open_window(900, 500);
  31 }
  32 if (user_use_date_picker()) {
  33         $js .= get_js_date_picker();
  34 }
  35
  36 if (isset($_GET['ModifyInvoice'])) {
  37         $_SESSION['page_title'] = sprintf(_("Modifying Sales Invoice # %d.") ,$_GET['ModifyInvoice']);
  38         $help_context = "Modifying Sales Invoice";
  39 } elseif (isset($_GET['DeliveryNumber'])) {
  40         $_SESSION['page_title'] = _($help_context = "Issue an Invoice for Delivery Note");
  41 } elseif (isset($_GET['BatchInvoice'])) {
  42         $_SESSION['page_title'] = _($help_context = "Issue Batch Invoice for Delivery Notes");
  43 } elseif (isset($_GET['AllocationNumber']) || isset($_GET['InvoicePrepayments'])) {
  44         $_SESSION['page_title'] = _($help_context = "Prepayment or Final Invoice Entry");
  45 }
  46 page($_SESSION['page_title'], false, false, "", $js);
  47
  48 //-----------------------------------------------------------------------------
  49
  50 check_edit_conflicts(get_post('cart_id'));
  51
  52 if (isset($_GET['AddedID'])) {
  53
  54         $invoice_no = $_GET['AddedID'];
  55         $trans_type = ST_SALESINVOICE;
  56
  57         display_notification(_("Selected deliveries has been processed"), true);
  58
  59         display_note(get_customer_trans_view_str($trans_type, $invoice_no, _("&View This Invoice")), 0, 1);
  60
  61         display_note(print_document_link($invoice_no."-".$trans_type, _("&Print This Invoice"), true, ST_SALESINVOICE));
  62         display_note(print_document_link($invoice_no."-".$trans_type, _("&Email This Invoice"), true, ST_SALESINVOICE, false, "printlink", "", 1),1);
  63
  64         display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL &Journal Entries for this Invoice")),1);
  65
  66         hyperlink_params("$path_to_root/sales/inquiry/sales_deliveries_view.php", _("Select Another &Delivery For Invoicing"), "OutstandingOnly=1");
  67
  68         if (!db_num_rows(get_allocatable_from_cust_transactions(null, $invoice_no, $trans_type)))
  69                 hyperlink_params("$path_to_root/sales/customer_payments.php", _("Entry &customer payment for this invoice"),
  70                 "SInvoice=".$invoice_no);
  71
  72         hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$trans_type&trans_no=$invoice_no");
  73
  74         display_footer_exit();
  75
  76 } elseif (isset($_GET['UpdatedID']))  {
  77
  78         $invoice_no = $_GET['UpdatedID'];
  79         $trans_type = ST_SALESINVOICE;
  80
  81         display_notification_centered(sprintf(_('Sales Invoice # %d has been updated.'),$invoice_no));
  82
  83         display_note(get_trans_view_str(ST_SALESINVOICE, $invoice_no, _("&View This Invoice")));
  84         echo '<br>';
  85         display_note(print_document_link($invoice_no."-".$trans_type, _("&Print This Invoice"), true, ST_SALESINVOICE));
  86         display_note(print_document_link($invoice_no."-".$trans_type, _("&Email This Invoice"), true, ST_SALESINVOICE, false, "printlink", "", 1),1);
  87
  88         hyperlink_no_params($path_to_root . "/sales/inquiry/customer_inquiry.php", _("Select Another &Invoice to Modify"));
  89
  90         display_footer_exit();
  91
  92 } elseif (isset($_GET['RemoveDN'])) {
  93
  94         for($line_no = 0; $line_no < count($_SESSION['Items']->line_items); $line_no++) {
  95                 $line = &$_SESSION['Items']->line_items[$line_no];
  96                 if ($line->src_no == $_GET['RemoveDN']) {
  97                         $line->quantity = $line->qty_done;
  98                         $line->qty_dispatched=0;
  99                 }
 100         }
 101         unset($line);
 102
 103     // Remove also src_doc delivery note
 104     $sources = &$_SESSION['Items']->src_docs;
 105     unset($sources[$_GET['RemoveDN']]);
 106 }
 107
 108 //-----------------------------------------------------------------------------
 109
 110 if ( (isset($_GET['DeliveryNumber']) && ($_GET['DeliveryNumber'] > 0) )
 111         || isset($_GET['BatchInvoice'])) {
 112
 113         processing_start();
 114
 115         if (isset($_GET['BatchInvoice'])) {
 116                 $src = $_SESSION['DeliveryBatch'];
 117                 unset($_SESSION['DeliveryBatch']);
 118         } else {
 119                 $src = array($_GET['DeliveryNumber']);
 120         }
 121
 122         /*read in all the selected deliveries into the Items cart  */
 123         $dn = new Cart(ST_CUSTDELIVERY, $src, true);
 124
 125         if ($dn->count_items() == 0) {
 126                 hyperlink_params($path_to_root . "/sales/inquiry/sales_deliveries_view.php",
 127                         _("Select a different delivery to invoice"), "OutstandingOnly=1");
 128                 die ("<br><b>" . _("There are no delivered items with a quantity left to invoice. There is nothing left to invoice.") . "</b>");
 129         }
 130
 131         $_SESSION['Items'] = $dn;
 132         copy_from_cart();
 133
 134 } elseif (isset($_GET['ModifyInvoice']) && $_GET['ModifyInvoice'] > 0) {
 135
 136         check_is_editable(ST_SALESINVOICE, $_GET['ModifyInvoice']);
 137
 138         processing_start();
 139         $_SESSION['Items'] = new Cart(ST_SALESINVOICE, $_GET['ModifyInvoice']);
 140
 141         if ($_SESSION['Items']->count_items() == 0) {
 142                 echo"<center><br><b>" . _("All quantities on this invoice has been credited. There is nothing to modify on this invoice") . "</b></center>";
 143                 display_footer_exit();
 144         }
 145         copy_from_cart();
 146 } elseif (isset($_GET['AllocationNumber']) || isset($_GET['InvoicePrepayments'])) {
 147
 148         check_deferred_income_act(_("You have to set Deferred Income Account in GL Setup to entry prepayment invoices."));
 149
 150         if (isset($_GET['AllocationNumber']))
 151         {
 152                 $payments = array(get_cust_allocation($_GET['AllocationNumber']));
 153
 154                 if (!$payments || ($payments[0]['trans_type_to'] != ST_SALESORDER))
 155                 {
 156                         display_error(_("Please select correct Sales Order Prepayment to be invoiced and try again."));
 157                         display_footer_exit();
 158                 }
 159                 $order_no = $payments[0]['trans_no_to'];
 160         }
 161         else {
 162                 $order_no = $_GET['InvoicePrepayments'];
 163         }
 164         processing_start();
 165
 166         $_SESSION['Items'] = new cart(ST_SALESORDER, $order_no, ST_SALESINVOICE);
 167         $_SESSION['Items']->order_no = $order_no;
 168         $_SESSION['Items']->src_docs = array($order_no);
 169         $_SESSION['Items']->trans_no = 0;
 170         $_SESSION['Items']->trans_type = ST_SALESINVOICE;
 171
 172         $_SESSION['Items']->update_payments();
 173
 174         copy_from_cart();
 175 }
 176 elseif (!processing_active()) {
 177         /* This page can only be called with a delivery for invoicing or invoice no for edit */
 178         display_error(_("This page can only be opened after delivery selection. Please select delivery to invoicing first."));
 179
 180         hyperlink_no_params("$path_to_root/sales/inquiry/sales_deliveries_view.php", _("Select Delivery to Invoice"));
 181
 182         end_page();
 183         exit;
 184 } elseif (!isset($_POST['process_invoice']) && (!$_SESSION['Items']->is_prepaid() && !check_quantities())) {
 185         display_error(_("Selected quantity cannot be less than quantity credited nor more than quantity not invoiced yet."));
 186 }
 187
 188 if (isset($_POST['Update'])) {
 189         $Ajax->activate('Items');
 190 }
 191 if (isset($_POST['_InvoiceDate_changed'])) {
 192         $_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->payment, $_POST['InvoiceDate']);
 193         $Ajax->activate('due_date');
 194 }
 195
 196 //-----------------------------------------------------------------------------
 197 function check_quantities()
 198 {
 199         $ok =1;
 200         foreach ($_SESSION['Items']->line_items as $line_no=>$itm) {
 201                 if (isset($_POST['Line'.$line_no])) {
 202                         if($_SESSION['Items']->trans_no) {
 203                                 $min = $itm->qty_done;
 204                                 $max = $itm->quantity;
 205                         } else {
 206                                 $min = 0;
 207                                 $max = $itm->quantity - $itm->qty_done;
 208                         }
 209                         if (check_num('Line'.$line_no, $min, $max)) {
 210                                 $_SESSION['Items']->line_items[$line_no]->qty_dispatched =
 211                                     input_num('Line'.$line_no);
 212                         }
 213                         else {
 214                                 $ok = 0;
 215                         }
 216
 217                 }
 218
 219                 if (isset($_POST['Line'.$line_no.'Desc'])) {
 220                         $line_desc = $_POST['Line'.$line_no.'Desc'];
 221                         if (strlen($line_desc) > 0) {
 222                                 $_SESSION['Items']->line_items[$line_no]->item_description = $line_desc;
 223                         }
 224                 }
 225         }
 226  return $ok;
 227 }
 228
 229 function set_delivery_shipping_sum($delivery_notes)
 230 {
 231
 232     $shipping = 0;
 233
 234     foreach($delivery_notes as $delivery_num)
 235     {
 236         $myrow = get_customer_trans($delivery_num, ST_CUSTDELIVERY);
 237
 238         $shipping += $myrow['ov_freight'];
 239     }
 240     $_POST['ChargeFreightCost'] = price_format($shipping);
 241 }
 242
 243
 244 function copy_to_cart()
 245 {
 246         $cart = &$_SESSION['Items'];
 247         $cart->due_date = $cart->document_date =  $_POST['InvoiceDate'];
 248         $cart->Comments = $_POST['Comments'];
 249         $cart->due_date =  $_POST['due_date'];
 250         if (($cart->pos['cash_sale'] || $cart->pos['credit_sale']) && isset($_POST['payment'])) {
 251                 $cart->payment = $_POST['payment'];
 252                 $cart->payment_terms = get_payment_terms($_POST['payment']);
 253         }
 254         if ($_SESSION['Items']->trans_no == 0)
 255                 $cart->reference = $_POST['ref'];
 256         if (!$cart->is_prepaid())
 257         {
 258                 $cart->ship_via = $_POST['ship_via'];
 259                 $cart->freight_cost = input_num('ChargeFreightCost');
 260         }
 261
 262         $cart->update_payments();
 263
 264         $cart->dimension_id =  $_POST['dimension_id'];
 265         $cart->dimension2_id =  $_POST['dimension2_id'];
 266 }
 267 //-----------------------------------------------------------------------------
 268
 269 function copy_from_cart()
 270 {
 271         $cart = &$_SESSION['Items'];
 272         $_POST['Comments']= $cart->Comments;
 273         $_POST['InvoiceDate']= $cart->document_date;
 274         $_POST['ref'] = $cart->reference;
 275         $_POST['cart_id'] = $cart->cart_id;
 276         $_POST['due_date'] = $cart->due_date;
 277         $_POST['payment'] = $cart->payment;
 278         if (!$_SESSION['Items']->is_prepaid())
 279         {
 280                 $_POST['ship_via'] = $cart->ship_via;
 281                 $_POST['ChargeFreightCost'] = price_format($cart->freight_cost);
 282         }
 283         $_POST['dimension_id'] = $cart->dimension_id;
 284         $_POST['dimension2_id'] = $cart->dimension2_id;
 285 }
 286
 287 //-----------------------------------------------------------------------------
 288
 289 function check_data()
 290 {
 291         global $Refs;
 292
 293         $prepaid = $_SESSION['Items']->is_prepaid();
 294
 295         if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
 296                 display_error(_("The entered invoice date is invalid."));
 297                 set_focus('InvoiceDate');
 298                 return false;
 299         }
 300
 301         if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
 302                 display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
 303                 set_focus('InvoiceDate');
 304                 return false;
 305         }
 306
 307
 308         if (!$prepaid &&(!isset($_POST['due_date']) || !is_date($_POST['due_date'])))   {
 309                 display_error(_("The entered invoice due date is invalid."));
 310                 set_focus('due_date');
 311                 return false;
 312         }
 313
 314         if ($_SESSION['Items']->trans_no == 0) {
 315                 if (!$Refs->is_valid($_POST['ref'], ST_SALESINVOICE)) {
 316                         display_error(_("You must enter a reference."));
 317                         set_focus('ref');
 318                         return false;
 319                 }
 320         }
 321
 322         if(!$prepaid)
 323         {
 324                 if ($_POST['ChargeFreightCost'] == "") {
 325                         $_POST['ChargeFreightCost'] = price_format(0);
 326                 }
 327
 328                 if (!check_num('ChargeFreightCost', 0)) {
 329                         display_error(_("The entered shipping value is not numeric."));
 330                         set_focus('ChargeFreightCost');
 331                         return false;
 332                 }
 333
 334                 if ($_SESSION['Items']->has_items_dispatch() == 0 && input_num('ChargeFreightCost') == 0) {
 335                         display_error(_("There are no item quantities on this invoice."));
 336                         return false;
 337                 }
 338
 339                 if (!check_quantities()) {
 340                         display_error(_("Selected quantity cannot be less than quantity credited nor more than quantity not invoiced yet."));
 341                         return false;
 342                 }
 343         } else {
 344                 if (($_SESSION['Items']->payment_terms['days_before_due'] == -1) && !count($_SESSION['Items']->prepayments)) {
 345                         display_error(_("There is no non-invoiced payments for this order. If you want to issue final invoice, select delayed or cash payment terms."));
 346                         return false;
 347                 }
 348         }
 349
 350         return true;
 351 }
 352
 353 //-----------------------------------------------------------------------------
 354 if (isset($_POST['process_invoice']) && check_data()) {
 355         $newinvoice=  $_SESSION['Items']->trans_no == 0;
 356         copy_to_cart();
 357
 358         if ($newinvoice)
 359                 new_doc_date($_SESSION['Items']->document_date);
 360
 361         $invoice_no = $_SESSION['Items']->write();
 362         if ($invoice_no == -1)
 363         {
 364                 display_error(_("The entered reference is already in use."));
 365                 set_focus('ref');
 366         }
 367         else
 368         {
 369                 processing_end();
 370
 371                 if ($newinvoice) {
 372                         meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
 373                 } else {
 374                         meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$invoice_no");
 375                 }
 376         }
 377 }
 378
 379 if(list_updated('payment')) {
 380         $order = &$_SESSION['Items'];
 381         copy_to_cart();
 382         $order->payment = get_post('payment');
 383         $order->payment_terms = get_payment_terms($order->payment);
 384         $_POST['due_date'] = $order->due_date = get_invoice_duedate($order->payment, $order->document_date);
 385         $_POST['Comments'] = '';
 386         $Ajax->activate('due_date');
 387         $Ajax->activate('options');
 388         if ($order->payment_terms['cash_sale']) {
 389                 $_POST['Location'] = $order->Location = $order->pos['pos_location'];
 390                 $order->location_name = $order->pos['location_name'];
 391         }
 392 }
 393
 394 // find delivery spans for batch invoice display
 395 $dspans = array();
 396 $lastdn = ''; $spanlen=1;
 397
 398 for ($line_no = 0; $line_no < count($_SESSION['Items']->line_items); $line_no++) {
 399         $line = $_SESSION['Items']->line_items[$line_no];
 400         if ($line->quantity == $line->qty_done) {
 401                 continue;
 402         }
 403         if ($line->src_no == $lastdn) {
 404                 $spanlen++;
 405         } else {
 406                 if ($lastdn != '') {
 407                         $dspans[] = $spanlen;
 408                         $spanlen = 1;
 409                 }
 410         }
 411         $lastdn = $line->src_no;
 412 }
 413 $dspans[] = $spanlen;
 414
 415 //-----------------------------------------------------------------------------
 416
 417 $is_batch_invoice = count($_SESSION['Items']->src_docs) > 1;
 418 $prepaid = $_SESSION['Items']->is_prepaid();
 419
 420 $is_edition = $_SESSION['Items']->trans_type == ST_SALESINVOICE && $_SESSION['Items']->trans_no != 0;
 421 start_form();
 422 hidden('cart_id');
 423
 424 start_table(TABLESTYLE2, "width='80%'", 5);
 425
 426 start_row();
 427 $colspan = 1;
 428 $dim = get_company_pref('use_dimension');
 429 if ($dim > 0)
 430         $colspan = 3;
 431 label_cells(_("Customer"), $_SESSION['Items']->customer_name, "class='tableheader2'");
 432 label_cells(_("Branch"), get_branch_name($_SESSION['Items']->Branch), "class='tableheader2'");
 433 if (($_SESSION['Items']->pos['credit_sale'] || $_SESSION['Items']->pos['cash_sale'])) {
 434         $paymcat = !$_SESSION['Items']->pos['cash_sale'] ? PM_CREDIT :
 435                 (!$_SESSION['Items']->pos['credit_sale'] ? PM_CASH : PM_ANY);
 436         label_cells(_("Payment terms:"), sale_payment_list('payment', $paymcat),
 437                 "class='tableheader2'", "colspan=$colspan");
 438 } else
 439         label_cells(_('Payment:'), $_SESSION['Items']->payment_terms['terms'], "class='tableheader2'", "colspan=$colspan");
 440
 441 end_row();
 442 start_row();
 443
 444 if ($_SESSION['Items']->trans_no == 0) {
 445         ref_cells(_("Reference"), 'ref', '', null, "class='tableheader2'", false, ST_SALESINVOICE,
 446                 array('customer' => $_SESSION['Items']->customer_id,
 447                         'branch' => $_SESSION['Items']->Branch,
 448                         'date' => get_post('InvoiceDate')));
 449 } else {
 450         label_cells(_("Reference"), $_SESSION['Items']->reference, "class='tableheader2'");
 451 }
 452
 453 label_cells(_("Sales Type"), $_SESSION['Items']->sales_type_name, "class='tableheader2'");
 454
 455 label_cells(_("Currency"), $_SESSION['Items']->customer_currency, "class='tableheader2'");
 456 if ($dim > 0) {
 457         label_cell(_("Dimension").":", "class='tableheader2'");
 458         $_POST['dimension_id'] = $_SESSION['Items']->dimension_id;
 459         dimensions_list_cells(null, 'dimension_id', null, true, ' ', false, 1, false);
 460 }
 461 else
 462         hidden('dimension_id', 0);
 463
 464 end_row();
 465 start_row();
 466
 467 if (!isset($_POST['ship_via'])) {
 468         $_POST['ship_via'] = $_SESSION['Items']->ship_via;
 469 }
 470 label_cell(_("Shipping Company"), "class='tableheader2'");
 471 if ($prepaid)
 472 {
 473         $shipper = get_shipper($_SESSION['Items']->ship_via);
 474         label_cells(null, $shipper['shipper_name']);
 475 } else
 476         shippers_list_cells(null, 'ship_via', $_POST['ship_via']);
 477
 478 if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
 479         $_POST['InvoiceDate'] = new_doc_date();
 480         if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
 481                 $_POST['InvoiceDate'] = end_fiscalyear();
 482         }
 483 }
 484
 485 date_cells(_("Date"), 'InvoiceDate', '', $_SESSION['Items']->trans_no == 0,
 486         0, 0, 0, "class='tableheader2'", true);
 487
 488 if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
 489         $_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->payment, $_POST['InvoiceDate']);
 490 }
 491
 492 date_cells(_("Due Date"), 'due_date', '', null, 0, 0, 0, "class='tableheader2'");
 493 if ($dim > 1) {
 494         label_cell(_("Dimension")." 2:", "class='tableheader2'");
 495         $_POST['dimension2_id'] = $_SESSION['Items']->dimension2_id;
 496         dimensions_list_cells(null, 'dimension2_id', null, true, ' ', false, 2, false);
 497 }
 498 else
 499         hidden('dimension2_id', 0);
 500 end_row();
 501 end_table();
 502
 503 $row = get_customer_to_order($_SESSION['Items']->customer_id);
 504 if ($row['dissallow_invoices'] == 1)
 505 {
 506         display_error(_("The selected customer account is currently on hold. Please contact the credit control personnel to discuss."));
 507         end_form();
 508         end_page();
 509         exit();
 510 }
 511
 512 display_heading($prepaid ? _("Sales Order Items") : _("Invoice Items"));
 513
 514 div_start('Items');
 515
 516 start_table(TABLESTYLE, "width='80%'");
 517 if ($prepaid)
 518         $th = array(_("Item Code"), _("Item Description"), _("Units"), _("Quantity"),
 519                 _("Price"), _("Tax Type"), _("Discount"), _("Total"));
 520 else
 521         $th = array(_("Item Code"), _("Item Description"), _("Delivered"), _("Units"), _("Invoiced"),
 522                 _("This Invoice"), _("Price"), _("Tax Type"), _("Discount"), _("Total"));
 523
 524 if ($is_batch_invoice) {
 525     $th[] = _("DN");
 526     $th[] = "";
 527 }
 528
 529 if ($is_edition) {
 530     $th[4] = _("Credited");
 531 }
 532
 533 table_header($th);
 534 $k = 0;
 535 $has_marked = false;
 536 $show_qoh = true;
 537
 538 $dn_line_cnt = 0;
 539
 540 foreach ($_SESSION['Items']->line_items as $line=>$ln_itm) {
 541         if (!$prepaid && ($ln_itm->quantity == $ln_itm->qty_done)) {
 542                 continue; // this line was fully invoiced
 543         }
 544         alt_table_row_color($k);
 545         view_stock_status_cell($ln_itm->stock_id);
 546
 547         if ($prepaid)
 548                 label_cell($ln_itm->item_description);
 549         else
 550                 text_cells(null, 'Line'.$line.'Desc', $ln_itm->item_description, 30, 50);
 551         $dec = get_qty_dec($ln_itm->stock_id);
 552         if (!$prepaid)
 553                 qty_cell($ln_itm->quantity, false, $dec);
 554         label_cell($ln_itm->units);
 555         if (!$prepaid)
 556                 qty_cell($ln_itm->qty_done, false, $dec);
 557
 558         if ($is_batch_invoice || $prepaid) {
 559                 // for batch invoices we can only remove whole deliveries
 560                 echo '<td nowrap align=right>';
 561                 hidden('Line' . $line, $ln_itm->qty_dispatched );
 562                 echo number_format2($ln_itm->qty_dispatched, $dec).'</td>';
 563         } else {
 564                 small_qty_cells(null, 'Line'.$line, qty_format($ln_itm->qty_dispatched, $ln_itm->stock_id, $dec), null, null, $dec);
 565         }
 566         $display_discount_percent = percent_format($ln_itm->discount_percent*100) . " %";
 567
 568         $line_total = ($ln_itm->qty_dispatched * $ln_itm->price * (1 - $ln_itm->discount_percent));
 569
 570         amount_cell($ln_itm->price);
 571         label_cell($ln_itm->tax_type_name);
 572         label_cell($display_discount_percent, "nowrap align=right");
 573         amount_cell($line_total);
 574
 575         if ($is_batch_invoice) {
 576                 if ($dn_line_cnt == 0) {
 577                         $dn_line_cnt = $dspans[0];
 578                         $dspans = array_slice($dspans, 1);
 579                         label_cell($ln_itm->src_no, "rowspan=$dn_line_cnt class='oddrow'");
 580                         label_cell("<a href='" . $_SERVER['PHP_SELF'] . "?RemoveDN=".
 581                                 $ln_itm->src_no."'>" . _("Remove") . "</a>", "rowspan=$dn_line_cnt class='oddrow'");
 582                 }
 583                 $dn_line_cnt--;
 584         }
 585         end_row();
 586 }
 587
 588 /*Don't re-calculate freight if some of the order has already been delivered -
 589 depending on the business logic required this condition may not be required.
 590 It seems unfair to charge the customer twice for freight if the order
 591 was not fully delivered the first time ?? */
 592
 593 if (!isset($_POST['ChargeFreightCost']) || $_POST['ChargeFreightCost'] == "") {
 594         if ($_SESSION['Items']->any_already_delivered() == 1) {
 595                 $_POST['ChargeFreightCost'] = price_format(0);
 596         } else {
 597                 $_POST['ChargeFreightCost'] = price_format($_SESSION['Items']->freight_cost);
 598         }
 599
 600         if (!check_num('ChargeFreightCost')) {
 601                 $_POST['ChargeFreightCost'] = price_format(0);
 602         }
 603 }
 604
 605 $accumulate_shipping = get_company_pref('accumulate_shipping');
 606 if ($is_batch_invoice && $accumulate_shipping)
 607         set_delivery_shipping_sum(array_keys($_SESSION['Items']->src_docs));
 608
 609 $colspan = $prepaid ? 7:9;
 610 start_row();
 611 label_cell(_("Shipping Cost"), "colspan=$colspan align=right");
 612 if ($prepaid)
 613         label_cell($_POST['ChargeFreightCost'], 'align=right');
 614 else
 615         small_amount_cells(null, 'ChargeFreightCost', null);
 616 if ($is_batch_invoice) {
 617 label_cell('', 'colspan=2');
 618 }
 619
 620 end_row();
 621 $inv_items_total = $_SESSION['Items']->get_items_total_dispatch();
 622
 623 $display_sub_total = price_format($inv_items_total + input_num('ChargeFreightCost'));
 624
 625 label_row(_("Sub-total"), $display_sub_total, "colspan=$colspan align=right","align=right", $is_batch_invoice ? 2 : 0);
 626
 627 $taxes = $_SESSION['Items']->get_taxes(input_num('ChargeFreightCost'));
 628 $tax_total = display_edit_tax_items($taxes, $colspan, $_SESSION['Items']->tax_included, $is_batch_invoice ? 2 : 0);
 629
 630 $display_total = price_format(($inv_items_total + input_num('ChargeFreightCost') + $tax_total));
 631
 632 label_row(_("Invoice Total"), $display_total, "colspan=$colspan align=right","align=right", $is_batch_invoice ? 2 : 0);
 633
 634 end_table(1);
 635 div_end();
 636 div_start('options');
 637 start_table(TABLESTYLE2);
 638 if ($prepaid)
 639 {
 640
 641         label_row(_("Sales order:"), get_trans_view_str(ST_SALESORDER, $_SESSION['Items']->order_no, get_reference(ST_SALESORDER, $_SESSION['Items']->order_no)));
 642
 643         $list = array(); $allocs = 0;
 644         if (count($_SESSION['Items']->prepayments))
 645         {
 646                 foreach($_SESSION['Items']->prepayments as $pmt)
 647                 {
 648                         $list[] = get_trans_view_str($pmt['trans_type_from'], $pmt['trans_no_from'], get_reference($pmt['trans_type_from'], $pmt['trans_no_from']));
 649                         $allocs += $pmt['amt'];
 650                 }
 651         }
 652
 653         label_row(_("Payments received:"), implode(',', $list));
 654         label_row(_("Invoiced here:"), price_format($_SESSION['Items']->prep_amount), 'class=label');
 655         label_row(_("Left to be invoiced:"), price_format($_SESSION['Items']->get_trans_total()-max($_SESSION['Items']->prep_amount, $allocs)), 'class=label');
 656 }
 657
 658 textarea_row(_("Memo:"), 'Comments', null, 50, 4);
 659
 660 end_table(1);
 661 div_end();
 662 submit_center_first('Update', _("Update"),
 663   _('Refresh document page'), true);
 664 submit_center_last('process_invoice', _("Process Invoice"),
 665   _('Check entered data and save document'), 'default');
 666
 667 end_form();
 668
 669 end_page();
 670