X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fcustomer_invoice.php;h=9836de48fad516e4330dcd2c0eb17b8a60b08a55;hb=499e0e615d1a845c6c519754b3a213fdda0513ba;hp=f63fc523337879f169e489ec106595b29ced3562;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git
diff --git a/sales/customer_invoice.php b/sales/customer_invoice.php
index f63fc523..9836de48 100644
--- a/sales/customer_invoice.php
+++ b/sales/customer_invoice.php
@@ -1,314 +1,344 @@
.
+***********************************************************************/
+//---------------------------------------------------------------------------
+//
+// Entry/Modify Sales Invoice against single delivery
+// Entry/Modify Batch Sales Invoice against batch of deliveries
+//
$page_security = 2;
$path_to_root="..";
include_once($path_to_root . "/sales/includes/cart_class.inc");
include_once($path_to_root . "/includes/session.inc");
-
include_once($path_to_root . "/includes/data_checks.inc");
-
include_once($path_to_root . "/includes/manufacturing.inc");
include_once($path_to_root . "/sales/includes/sales_db.inc");
include_once($path_to_root . "/sales/includes/sales_ui.inc");
-
+include_once($path_to_root . "/reporting/includes/reporting.inc");
include_once($path_to_root . "/taxes/tax_calc.inc");
$js = "";
-if ($use_popup_windows)
+if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
-page(_("Issue an Invoice and Deliver Items for a Sales Order"), false, false, "", $js);
+}
+if ($use_date_picker) {
+ $js .= get_js_date_picker();
+}
-//---------------------------------------------------------------------------------------------------------------
+if (isset($_GET['ModifyInvoice'])) {
+ $_SESSION['page_title'] = sprintf(_("Modifying Sales Invoice # %d.") ,$_GET['ModifyInvoice']);
+ $help_page_title = _("Modifying Sales Invoice");
+} elseif (isset($_GET['DeliveryNumber'])) {
+ $_SESSION['page_title'] = _("Issue an Invoice for Delivery Note");
+} elseif (isset($_GET['BatchInvoice'])) {
+ $_SESSION['page_title'] = _("Issue Batch Invoice for Delivery Notes");
+}
-if (isset($_GET['AddedID']))
-{
- $invoice_no = $_GET['AddedID'];
- $trans_type = 10;
+page($_SESSION['page_title'], false, false, "", $js);
- display_notification(_("Invoice processed"), true);
- display_note(get_customer_trans_view_str($trans_type, $invoice_no, _("View this invoice")), 0, 1);
+//-----------------------------------------------------------------------------
+check_edit_conflicts();
- display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL Journal Entries for this Invoice")));
+if (isset($_GET['AddedID'])) {
- if ($_SESSION['Items']->direct_invoice)
- hyperlink_params("$path_to_root/sales/sales_order_entry.php", _("Issue Another Invoice"), "NewInvoice=Yes");
- else
- hyperlink_params("$path_to_root/sales/inquiry/sales_orders_view.php", _("Select Another Order For Invoicing"), "OutstandingOnly=1");
+ $invoice_no = $_GET['AddedID'];
+ $trans_type = 10;
- unset($_SESSION['Items']->line_items);
- unset($_SESSION['Items']);
- display_footer_exit();
-}
+ display_notification(_("Selected deliveries has been processed"), true);
-//---------------------------------------------------------------------------------------------------------------
+ display_note(get_customer_trans_view_str($trans_type, $invoice_no, _("&View This Invoice")), 0, 1);
-if (!isset($_GET['OrderNumber']) && !isset($_SESSION['ProcessingOrder']) &&
- !isset($_GET['process_invoice']))
-{
- /* This page can only be called with an order number for invoicing*/
- display_error(_("This page can only be opened if an order has been selected. Please select an order first."));
+ display_note(print_document_link($invoice_no, _("&Print This Invoice"), true, 10));
- hyperlink_no_params("$path_to_root/sales/inquiry/sales_orders_view.php", _("Select a sales order to invoice"));
+ display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL &Journal Entries for this Invoice")),1);
- end_page();
- exit;
+ hyperlink_params("$path_to_root/sales/inquiry/sales_deliveries_view.php", _("Select Another &Delivery For Invoicing"), "OutstandingOnly=1");
-}
-elseif (isset($_GET['OrderNumber']) && $_GET['OrderNumber'] > 0)
-{
+ display_footer_exit();
- if (isset($_SESSION['Items']))
- {
- unset($_SESSION['Items']->line_items);
- unset ($_SESSION['Items']);
- }
+} elseif (isset($_GET['UpdatedID'])) {
- session_register("Items");
- session_register("ProcessingOrder");
+ $invoice_no = $_GET['UpdatedID'];
- $_SESSION['ProcessingOrder'] = $_GET['OrderNumber'];
- $_SESSION['Items'] = new cart;
+ display_notification_centered(sprintf(_('Sales Invoice # %d has been updated.'),$invoice_no));
- /*read in all the selected order into the Items cart */
+ display_note(get_trans_view_str(10, $invoice_no, _("&View This Invoice")));
+ echo '
';
+ display_note(print_document_link($invoice_no, _("&Print This Invoice"), true, 10));
- if (read_sales_order($_SESSION['ProcessingOrder'], $_SESSION['Items'], true))
- {
+ hyperlink_no_params($path_to_root . "/sales/inquiry/customer_inquiry.php", _("Select A Different &Invoice to Modify"));
- if ($_SESSION['Items']->count_items() == 0)
- {
- hyperlink_params($path_to_root . "/sales/inquiry/sales_orders_view.php", _("Select a different sales order to invoice"), "OutstandingOnly=1");
- die ("
" . _("There are no ordered items with a quantity left to deliver. There is nothing left to invoice.") . "");
- }
- }
- else
- {
- hyperlink_no_params("/sales_orders_view.php", _("Select a sales order to invoice"));
- die ("
" . _("This order item could not be retrieved. Please select another order.") . "");
- }
+ display_footer_exit();
-}
-else
-{
- /* if processing, a dispatch page has been called and ${$StkItm->stock_id} would have been set from the post */
- foreach ($_SESSION['Items']->line_items as $itm)
- {
-
- if (isset($_SESSION['Items']->line_items[$itm->stock_id]) &&
- isset($_POST[$itm->stock_id]) && is_numeric($_POST[$itm->stock_id]) &&
- $_POST[$itm->stock_id] <= ($_SESSION['Items']->line_items[$itm->stock_id]->quantity -
- $_SESSION['Items']->line_items[$itm->stock_id]->qty_inv))
- {
- $_SESSION['Items']->line_items[$itm->stock_id]->qty_dispatched = $_POST[$itm->stock_id];
- }
+} elseif (isset($_GET['RemoveDN'])) {
- if (isset($_POST[$itm->stock_id . "Desc"]) && strlen($_POST[$itm->stock_id . "Desc"]) > 0)
- {
- $_SESSION['Items']->line_items[$itm->stock_id]->item_description = $_POST[$itm->stock_id . "Desc"];
+ for($line_no = 0; $line_no < count($_SESSION['Items']->line_items); $line_no++) {
+ $line = &$_SESSION['Items']->line_items[$line_no];
+ if ($line->src_no == $_GET['RemoveDN']) {
+ $line->quantity = $line->qty_done;
+ $line->qty_dispatched=0;
}
}
+ unset($line);
+
+ // Remove also src_doc delivery note
+ $sources = &$_SESSION['Items']->src_docs;
+ unset($sources[$_GET['RemoveDN']]);
}
-//---------------------------------------------------------------------------------------------------------------
+//-----------------------------------------------------------------------------
-function order_changed_error()
-{
- global $path_to_root;
- display_note(_("This order has been changed or invoiced since this delivery was started to be confirmed. Processing halted."), 1, 0);
- display_note(_("To enter and confirm this dispatch/invoice the order must be re-selected and re-read again to update the changes made by the other user."), 1, 0);
+if ( (isset($_GET['DeliveryNumber']) && ($_GET['DeliveryNumber'] > 0) )
+|| isset($_GET['BatchInvoice'])) {
- hyperlink_no_params("$path_to_root/sales/inquiry/sales_orders_view.php", _("Select a sales order for confirming deliveries and invoicing"));
+ processing_start();
- unset($_SESSION['Items']->line_items);
- unset($_SESSION['Items']);
- unset($_SESSION['ProcessingOrder']);
- exit;
-}
+ if (isset($_GET['BatchInvoice'])) {
+ $src = $_SESSION['DeliveryBatch'];
+ unset($_SESSION['DeliveryBatch']);
+ } else {
+ $src = array($_GET['DeliveryNumber']);
+ }
+ /*read in all the selected deliveries into the Items cart */
+ $dn = new Cart(13, $src, true);
-//---------------------------------------------------------------------------------------------------------------
+ if ($dn->count_items() == 0) {
+ hyperlink_params($path_to_root . "/sales/inquiry/sales_deliveries_view.php",
+ _("Select a different delivery to invoice"), "OutstandingOnly=1");
+ die ("
" . _("There are no delivered items with a quantity left to invoice. There is nothing left to invoice.") . "");
+ }
-function check_order_changed()
-{
- global $debug;
+ $dn->trans_type = 10;
+ $dn->src_docs = $dn->trans_no;
+ $dn->trans_no = 0;
+ $dn->reference = references::get_next(10);
+ $dn->due_date = get_invoice_duedate($dn->customer_id, $dn->document_date);
- /*Now need to check that the order details are the same as they were when
- they were read into the Items array.
- If they've changed then someone else may have invoiced them -
- as modified for bug pointed out by Sherif 1-7-03*/
+ $_SESSION['Items'] = $dn;
+ copy_from_cart();
- $sql = "SELECT stk_code, quantity, qty_invoiced FROM ".TB_PREF."sales_order_details WHERE
- quantity - qty_invoiced > 0
- AND order_no = " . $_SESSION['ProcessingOrder'];
+} elseif (isset($_GET['ModifyInvoice']) && $_GET['ModifyInvoice'] > 0) {
- $result = db_query($sql,"retreive sales order details");
+ if ( get_parent_trans(10, $_GET['ModifyInvoice']) == 0) { // 1.xx compatibility hack
+ echo"
" . _("There are no delivery notes for this invoice.
+ Most likely this invoice was created in Front Accounting version prior to 2.0
+ and therefore can not be modified.") . "";
+ display_footer_exit();
+ }
+ processing_start();
+ $_SESSION['Items'] = new Cart(10, $_GET['ModifyInvoice']);
- if (db_num_rows($result) != count($_SESSION['Items']->line_items))
- {
+ if ($_SESSION['Items']->count_items() == 0) {
+ echo"
" . _("All quantities on this invoice has been credited. There is nothing to modify on this invoice") . "";
+ display_footer_exit();
+ }
+ copy_from_cart();
+} elseif (!processing_active()) {
+ /* This page can only be called with a delivery for invoicing or invoice no for edit */
+ display_error(_("This page can only be opened after delivery selection. Please select delivery to invoicing first."));
- /*there should be the same number of items returned from this query as there are lines on the invoice -
- if not then someone has already invoiced or credited some lines */
- if ($debug == 1)
- {
- display_note($sql, 1, 0);
- display_note("No rows returned by sql:" . db_num_rows($result), 1, 0);
- display_note("Count of items in the session " . count($_SESSION['Items']->line_items), 1, 0);
- }
+ hyperlink_no_params("$path_to_root/sales/inquiry/sales_deliveries_view.php", _("Select Delivery to Invoice"));
- return false;
- }
+ end_page();
+ exit;
+} elseif (!check_quantities()) {
+ display_error(_("Selected quantity cannot be less than quantity credited nor more than quantity not invoiced yet."));
+}
+if (isset($_POST['Update'])) {
+ $Ajax->activate('Items');
+}
+if (isset($_POST['_InvoiceDate_changed'])) {
+ $_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->customer_id,
+ $_POST['InvoiceDate']);
+ $Ajax->activate('due_date');
+}
- while ($myrow = db_fetch($result))
- {
- $stk_itm = $myrow["stk_code"];
- if ($_SESSION['Items']->line_items[$stk_itm]->quantity != $myrow["quantity"] ||
- $_SESSION['Items']->line_items[$stk_itm]->qty_inv != $myrow["qty_invoiced"])
- {
- display_note(_("Original order for") . " " . $myrow["stk_code"] . " " .
- _("has a quantity of") . " " . $myrow["quantity"] . " " .
- _("and an invoiced quantity of") . " " . $myrow["qty_invoiced"] . " " .
- _("the session shows quantity of") . " " .
- $_SESSION['Items']->line_items[$stk_itm]->quantity . " " .
- _("and quantity invoice of") . " " .
- $_SESSION['Items']->line_items[$stk_itm]->qty_inv, 1, 0);
+//-----------------------------------------------------------------------------
+function check_quantities()
+{
+ $ok =1;
+ foreach ($_SESSION['Items']->line_items as $line_no=>$itm) {
+ if (isset($_POST['Line'.$line_no])) {
+ if($_SESSION['Items']->trans_no) {
+ $min = $itm->qty_done;
+ $max = $itm->quantity;
+ } else {
+ $min = 0;
+ $max = $itm->quantity - $itm->qty_done;
+ }
+ if (check_num('Line'.$line_no, $min, $max)) {
+ $_SESSION['Items']->line_items[$line_no]->qty_dispatched =
+ input_num('Line'.$line_no);
+ }
+ else {
+ $ok = 0;
+ }
+
+ }
- return false;
+ if (isset($_POST['Line'.$line_no.'Desc'])) {
+ $line_desc = $_POST['Line'.$line_no.'Desc'];
+ if (strlen($line_desc) > 0) {
+ $_SESSION['Items']->line_items[$line_no]->item_description = $line_desc;
+ }
}
- } /*loop through all line items of the order to ensure none have been invoiced */
+ }
+ return $ok;
+}
- return true;
+function set_delivery_shipping_sum($delivery_notes)
+{
+
+ $shipping = 0;
+
+ foreach($delivery_notes as $delivery_num)
+ {
+ $myrow = get_customer_trans($delivery_num, 13);
+ //$branch = get_branch($myrow["branch_code"]);
+ //$sales_order = get_sales_order_header($myrow["order_"]);
+
+ //$shipping += $sales_order['freight_cost'];
+ $shipping += $myrow['ov_freight'];
+ }
+ $_POST['ChargeFreightCost'] = price_format($shipping);
}
-//---------------------------------------------------------------------------------------------------------------
+function copy_to_cart()
+{
+ $cart = &$_SESSION['Items'];
+ $cart->ship_via = $_POST['ship_via'];
+ $cart->freight_cost = input_num('ChargeFreightCost');
+ $cart->document_date = $_POST['InvoiceDate'];
+ $cart->due_date = $_POST['due_date'];
+ $cart->Comments = $_POST['Comments'];
+}
+//-----------------------------------------------------------------------------
+
+function copy_from_cart()
+{
+ $cart = &$_SESSION['Items'];
+ $_POST['ship_via'] = $cart->ship_via;
+ $_POST['ChargeFreightCost'] = price_format($cart->freight_cost);
+ $_POST['InvoiceDate']= $cart->document_date;
+ $_POST['due_date'] = $cart->due_date;
+ $_POST['Comments']= $cart->Comments;
+ $_POST['cart_id'] = $cart->cart_id;
+}
+
+//-----------------------------------------------------------------------------
function check_data()
{
- if (!isset($_POST['DispatchDate']) || !is_date($_POST['DispatchDate']))
- {
+ if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
display_error(_("The entered invoice date is invalid."));
+ set_focus('InvoiceDate');
return false;
}
- if (!is_date_in_fiscalyear($_POST['DispatchDate']))
- {
+
+ if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
display_error(_("The entered invoice date is not in fiscal year."));
+ set_focus('InvoiceDate');
return false;
}
- if (!isset($_POST['due_date']) || !is_date($_POST['due_date']))
- {
+
+ if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
display_error(_("The entered invoice due date is invalid."));
+ set_focus('due_date');
return false;
}
- if (!references::is_valid($_POST['ref']))
- {
- display_error(_("You must enter a reference."));
- return false;
+ if ($_SESSION['Items']->trans_no == 0) {
+ if (!references::is_valid($_POST['ref'])) {
+ display_error(_("You must enter a reference."));
+ set_focus('ref');
+ return false;
+ }
+
+ if (!is_new_reference($_POST['ref'], 10)) {
+ display_error(_("The entered reference is already in use."));
+ set_focus('ref');
+ return false;
+ }
}
- if (!is_new_reference($_POST['ref'], 10))
- {
- display_error(_("The entered reference is already in use."));
- return false;
+ if ($_POST['ChargeFreightCost'] == "") {
+ $_POST['ChargeFreightCost'] = price_format(0);
}
- if ($_POST['ChargeFreightCost'] == "")
- $_POST['ChargeFreightCost'] = 0;
- if (!is_numeric($_POST['ChargeFreightCost']) || $_POST['ChargeFreightCost'] < 0)
- {
+
+ if (!check_num('ChargeFreightCost', 0)) {
display_error(_("The entered shipping value is not numeric."));
+ set_focus('ChargeFreightCost');
return false;
}
- if ($_SESSION['Items']->has_items_dispatch() == 0 && $_POST['ChargeFreightCost'] == 0)
- {
+ if ($_SESSION['Items']->has_items_dispatch() == 0 && input_num('ChargeFreightCost') == 0) {
display_error(_("There are no item quantities on this invoice."));
return false;
}
+ if (!check_quantities()) {
+ display_error(_("Selected quantity cannot be less than quantity credited nor more than quantity not invoiced yet."));
+ return false;
+ }
+
return true;
}
-//---------------------------------------------------------------------------------------------------------------
+//-----------------------------------------------------------------------------
+if (isset($_POST['process_invoice']) && check_data()) {
-function check_qoh()
-{
- if (!sys_prefs::allow_negative_stock())
- {
- foreach ($_SESSION['Items']->line_items as $itm)
- {
-
- if ($itm->qty_dispatched && has_stock_holding($itm->mb_flag))
- {
- $qoh = get_qoh_on_date($itm->stock_id, $_POST['Location'], $_POST['DispatchDate']);
-
- if ($itm->qty_dispatched > $qoh)
- {
- display_error(_("The invoice cannot be processed because there is an insufficient quantity for component:") .
- " " . $itm->stock_id . " - " . $itm->item_description);
- return false;
- }
- }
- }
- }
+ $newinvoice= $_SESSION['Items']->trans_no == 0;
+ copy_to_cart();
+ $invoice_no = $_SESSION['Items']->write();
- return true;
+ processing_end();
+ if ($newinvoice) {
+ meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
+ } else {
+ meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$invoice_no");
+ }
}
-//---------------------------------------------------------------------------------------------------------------
+// find delivery spans for batch invoice display
+$dspans = array();
+$lastdn = ''; $spanlen=1;
-function process_invoice($invoicing=false)
-{
- if ($invoicing)
- {
- read_sales_order($_SESSION['Items']->order_no, $_SESSION['Items'], true);
- $duedate = get_invoice_duedate($_SESSION['Items']->customer_id, $_SESSION['Items']->delivery_date);
- $invoice_no = add_sales_invoice($_SESSION['Items'],
- $_SESSION['Items']->delivery_date, $duedate, $_SESSION['Items']->order_no,
- $_SESSION['Items']->tax_group_id, $_SESSION['Items']->freight_cost,
- $_SESSION['Items']->Location, $_SESSION['Items']->ship_via,
- $_SESSION['Items']->default_sales_type, references::get_next(10),
- $_SESSION['Items']->memo_, 0);
- }
- else
- {
-
- if (!check_data())
- return;
-
- if (!check_order_changed())
- order_changed_error();
-
- if (!check_qoh())
- return;
-
- if ($_POST['bo_policy'])
- $bo_policy = 0;
- else
- $bo_policy = 1;
-
- $invoice_no = add_sales_invoice($_SESSION['Items'],
- $_POST['DispatchDate'], $_POST['due_date'], $_SESSION['ProcessingOrder'],
- $_POST['tax_group_id'], $_POST['ChargeFreightCost'], $_POST['Location'],
- $_POST['ship_via'], $_POST['sales_type_id'], $_POST['ref'],
- $_POST['InvoiceText'], $bo_policy);
- unset($_SESSION['ProcessingOrder']);
+for ($line_no = 0; $line_no < count($_SESSION['Items']->line_items); $line_no++) {
+ $line = $_SESSION['Items']->line_items[$line_no];
+ if ($line->quantity == $line->qty_done) {
+ continue;
}
-
- meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
+ if ($line->src_no == $lastdn) {
+ $spanlen++;
+ } else {
+ if ($lastdn != '') {
+ $dspans[] = $spanlen;
+ $spanlen = 1;
+ }
+ }
+ $lastdn = $line->src_no;
}
+$dspans[] = $spanlen;
-//---------------------------------------------------------------------------------------------------------------
-if (isset($_GET['process_invoice']))
- process_invoice(true);
-elseif (isset($_POST['process_invoice']))
- process_invoice();
+//-----------------------------------------------------------------------------
-//-------------------------------------------------------------------------------------------------
+$is_batch_invoice = count($_SESSION['Items']->src_docs) > 1;
-start_form(false, true);
+$is_edition = $_SESSION['Items']->trans_type == 10 && $_SESSION['Items']->trans_no != 0;
+start_form();
+hidden('cart_id');
start_table("$table_style2 width=80%", 5);
-echo ""; // outer table
-start_table("$table_style width=100%");
start_row();
label_cells(_("Customer"), $_SESSION['Items']->customer_name, "class='tableheader2'");
label_cells(_("Branch"), get_branch_name($_SESSION['Items']->Branch), "class='tableheader2'");
@@ -316,102 +346,98 @@ label_cells(_("Currency"), $_SESSION['Items']->customer_currency, "class='tableh
end_row();
start_row();
-if (!isset($_POST['ref']))
- $_POST['ref'] = references::get_next(10);
-
-ref_cells(_("Reference"), 'ref', null, "class='tableheader2'");
+if ($_SESSION['Items']->trans_no == 0) {
+ ref_cells(_("Reference"), 'ref', '', $_SESSION['Items']->reference, "class='tableheader2'");
+} else {
+ label_cells(_("Reference"), $_SESSION['Items']->reference, "class='tableheader2'");
+}
-if (!isset($_POST['tax_group_id']))
- $_POST['tax_group_id'] = $_SESSION['Items']->tax_group_id;
-label_cell(_("Tax Group"), "class='tableheader2'");
-tax_groups_list_cells(null, 'tax_group_id', $_POST['tax_group_id'], false, null, true);
+label_cells(_("Delivery Notes:"),
+get_customer_trans_view_str(systypes::cust_dispatch(), array_keys($_SESSION['Items']->src_docs)), "class='tableheader2'");
-label_cells(_("For Sales Order"), get_customer_trans_view_str(systypes::sales_order(), $_SESSION['ProcessingOrder']), "class='tableheader2'");
+label_cells(_("Sales Type"), $_SESSION['Items']->sales_type_name, "class='tableheader2'");
end_row();
start_row();
-if (!isset($_POST['sales_type_id']))
- $_POST['sales_type_id'] = $_SESSION['Items']->default_sales_type;
-label_cell(_("Sales Type"), "class='tableheader2'");
-sales_types_list_cells(null, 'sales_type_id', $_POST['sales_type_id']);
-
-if (!isset($_POST['Location']))
- $_POST['Location'] = $_SESSION['Items']->Location;
-label_cell(_("Delivery From"), "class='tableheader2'");
-locations_list_cells(null, 'Location', $_POST['Location'], false, true);
-
-if (!isset($_POST['ship_via']))
+if (!isset($_POST['ship_via'])) {
$_POST['ship_via'] = $_SESSION['Items']->ship_via;
-label_cell(_("Shipping Company"), "class='tableheader2'");
+}
+label_cell(_("Shipping Company"), "class='tableheader2'");
shippers_list_cells(null, 'ship_via', $_POST['ship_via']);
-end_row();
-
-end_table();
-echo " | ";// outer table
+if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
+ $_POST['InvoiceDate'] = Today();
+ if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
+ $_POST['InvoiceDate'] = end_fiscalyear();
+ }
+}
-start_table("$table_style width=90%");
+date_cells(_("Date"), 'InvoiceDate', '', $_POST['InvoiceDate'], 0, 0, 0, "class='tableheader2'", true);
-// set this up here cuz it's used to calc qoh
-if (!isset($_POST['DispatchDate']) || !is_date($_POST['DispatchDate']))
-{
- $_POST['DispatchDate'] = Today();
- if (!is_date_in_fiscalyear($_POST['DispatchDate']))
- $_POST['DispatchDate'] = end_fiscalyear();
+if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
+ $_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->customer_id, $_POST['InvoiceDate']);
}
-text_row(_("Date"), 'DispatchDate', $_POST['DispatchDate'], 10, 10, "class='tableheader'");
-if (!isset($_POST['due_date']) || !is_date($_POST['due_date']))
- //$_POST['due_date'] = $_POST['DispatchDate'];
- $_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->customer_id, $_POST['DispatchDate']);
+date_cells(_("Due Date"), 'due_date', '', $_POST['due_date'], 0, 0, 0, "class='tableheader2'");
-text_row(_("Due Date"), 'due_date', $_POST['due_date'], 10, 10, "class='tableheader'");
+end_row();
end_table();
-echo " |
";
-end_table(1); // outer table
+$row = get_customer_to_order($_SESSION['Items']->customer_id);
+if ($row['dissallow_invoices'] == 1)
+{
+ display_error(_("The selected customer account is currently on hold. Please contact the credit control personnel to discuss."));
+ end_form();
+ end_page();
+ exit();
+}
display_heading(_("Invoice Items"));
+div_start('Items');
start_table("$table_style width=80%");
-$th = array(_("Item Code"), _("Item Description"), _("Ordered"), _("Units"), _("Delivered"),
- _("This Delivery"), _("Price"), _("Tax Type"), _("Discount"), _("Total"));
+$th = array(_("Item Code"), _("Item Description"), _("Delivered"), _("Units"), _("Invoiced"),
+ _("This Invoice"), _("Price"), _("Tax Type"), _("Discount"), _("Total"));
+
+if ($is_batch_invoice) {
+ $th[] = _("DN");
+ $th[] = "";
+}
+
+if ($is_edition) {
+ $th[4] = _("Credited");
+}
+
table_header($th);
$k = 0;
$has_marked = false;
$show_qoh = true;
-foreach ($_SESSION['Items']->line_items as $ln_itm)
-{
-
- // if it's a non-stock item (eg. service) don't show qoh
- if (sys_prefs::allow_negative_stock() || !has_stock_holding($ln_itm->mb_flag) ||
- $ln_itm->qty_dispatched == 0)
- $show_qoh = false;
-
- if ($show_qoh)
- $qoh = get_qoh_on_date($ln_itm->stock_id, $_POST['Location'], $_POST['DispatchDate']);
-
- if ($show_qoh && ($ln_itm->qty_dispatched > $qoh))
- {
- // oops, we don't have enough of one of the component items
- start_row("class='stockmankobg'");
- $has_marked = true;
- }
- else
- alt_table_row_color($k);
+$dn_line_cnt = 0;
+foreach ($_SESSION['Items']->line_items as $line=>$ln_itm) {
+ if ($ln_itm->quantity == $ln_itm->qty_done) {
+ continue; // this line was fully invoiced
+ }
+ alt_table_row_color($k);
view_stock_status_cell($ln_itm->stock_id);
- text_cells(null, $ln_itm->stock_id . "Desc", $ln_itm->item_description, 30, 50);
- qty_cell($ln_itm->quantity);
+ text_cells(null, 'Line'.$line.'Desc', $ln_itm->item_description, 30, 50);
+ $dec = get_qty_dec($ln_itm->stock_id);
+ qty_cell($ln_itm->quantity, false, $dec);
label_cell($ln_itm->units);
- qty_cell($ln_itm->qty_inv);
-
- text_cells(null, $ln_itm->stock_id, $ln_itm->qty_dispatched, 10, 10);
-
- $display_discount_percent = number_format2($ln_itm->discount_percent*100,user_percent_dec()) . "%";
+ qty_cell($ln_itm->qty_done, false, $dec);
+
+ if ($is_batch_invoice) {
+ // for batch invoices we can only remove whole deliveries
+ echo '';
+ hidden('Line' . $line, $ln_itm->qty_dispatched );
+ echo number_format2($ln_itm->qty_dispatched, $dec).' | ';
+ } else {
+ small_qty_cells(null, 'Line'.$line, qty_format($ln_itm->qty_dispatched, $ln_itm->stock_id, $dec), null, null, $dec);
+ }
+ $display_discount_percent = percent_format($ln_itm->discount_percent*100) . " %";
$line_total = ($ln_itm->qty_dispatched * $ln_itm->price * (1 - $ln_itm->discount_percent));
@@ -420,8 +446,16 @@ foreach ($_SESSION['Items']->line_items as $ln_itm)
label_cell($display_discount_percent, "nowrap align=right");
amount_cell($line_total);
- //label_cell(get_tax_free_price_for_item($ln_itm->stock_id, $line_total, $_POST['tax_group_id']));
-
+ if ($is_batch_invoice) {
+ if ($dn_line_cnt == 0) {
+ $dn_line_cnt = $dspans[0];
+ $dspans = array_slice($dspans, 1);
+ label_cell($ln_itm->src_no, "rowspan=$dn_line_cnt class=oddrow");
+ label_cell("src_no."'>" . _("Remove") . "", "rowspan=$dn_line_cnt class=oddrow");
+ }
+ $dn_line_cnt--;
+ }
end_row();
}
@@ -430,59 +464,58 @@ depending on the business logic required this condition may not be required.
It seems unfair to charge the customer twice for freight if the order
was not fully delivered the first time ?? */
-if (!isset($_POST['ChargeFreightCost']) || $_POST['ChargeFreightCost'] == "")
-{
- if ($_SESSION['Items']->any_already_delivered() == 1)
- {
- $_POST['ChargeFreightCost'] = 0;
- }
- else
- {
- $_POST['ChargeFreightCost'] = $_SESSION['Items']->freight_cost;
- }
- if (!is_numeric($_POST['ChargeFreightCost']))
- {
- $_POST['ChargeFreightCost'] = 0;
- }
+if (!isset($_POST['ChargeFreightCost']) || $_POST['ChargeFreightCost'] == "") {
+ if ($_SESSION['Items']->any_already_delivered() == 1) {
+ $_POST['ChargeFreightCost'] = price_format(0);
+ } else {
+ $_POST['ChargeFreightCost'] = price_format($_SESSION['Items']->freight_cost);
+ }
+
+ if (!check_num('ChargeFreightCost')) {
+ $_POST['ChargeFreightCost'] = price_format(0);
+ }
}
+$accumulate_shipping = get_company_pref('accumulate_shipping');
+if ($is_batch_invoice && $accumulate_shipping)
+ set_delivery_shipping_sum(array_keys($_SESSION['Items']->src_docs));
+
start_row();
small_amount_cells(_("Shipping Cost"), 'ChargeFreightCost', null, "colspan=9 align=right");
+if ($is_batch_invoice) {
+label_cell('', 'colspan=2');
+}
+end_row();
$inv_items_total = $_SESSION['Items']->get_items_total_dispatch();
-$display_sub_total = number_format2($inv_items_total + $_POST['ChargeFreightCost'],user_price_dec());
+$display_sub_total = price_format($inv_items_total + input_num('ChargeFreightCost'));
-label_row(_("Sub-total"), $display_sub_total, "colspan=9 align=right","align=right");
+label_row(_("Sub-total"), $display_sub_total, "colspan=9 align=right","align=right", $is_batch_invoice ? 2 : 0);
-$taxes = $_SESSION['Items']->get_taxes($_POST['tax_group_id'], $_POST['ChargeFreightCost']);
-$tax_total = display_edit_tax_items($taxes, 9);
+$taxes = $_SESSION['Items']->get_taxes(input_num('ChargeFreightCost'));
+$tax_total = display_edit_tax_items($taxes, 9, $_SESSION['Items']->tax_included, $is_batch_invoice ? 2:0);
-$display_total = number_format2(($inv_items_total + $_POST['ChargeFreightCost'] + $tax_total), user_price_dec());
+$display_total = price_format(($inv_items_total + input_num('ChargeFreightCost') + $tax_total));
-label_row(_("Invoice Total"), $display_total, "colspan=9 align=right","align=right");
+label_row(_("Invoice Total"), $display_total, "colspan=9 align=right","align=right", $is_batch_invoice ? 2 : 0);
end_table(1);
-
-if ($has_marked)
- display_note(_("Marked items have insufficient quantities in stock."), 0, 1, "class='red'");
+div_end();
start_table($table_style2);
-
-policy_list_row(_("Action For Balance"), "bo_policy", null);
-
-textarea_row(_("Memo"), 'InvoiceText', null, 50, 4);
+textarea_row(_("Memo"), 'Comments', null, 50, 4);
end_table(1);
-submit_center_first('Update', _("Update"));
-submit_center_last('process_invoice', _("Process Invoice"));
+submit_center_first('Update', _("Update"),
+ _('Refresh document page'), true);
+submit_center_last('process_invoice', _("Process Invoice"),
+ _('Check entered data and save document'), true);
end_form();
-//---------------------------------------------------------------------------------------------
-
end_page();
?>