1 (edited by sikumbang 09/03/2019 04:41:44 am)

Topic: inventory location transfer from sales kit

i try to do inventory location transfer for kit items but the kit code is not available to be selected, is there a way to enable this?

Re: inventory location transfer from sales kit

try replace the inventory/includes/stock_transfers_ui.inc with this code (also in attachment) then check if any problem

<?php
/**********************************************************************
    Copyright (C) FrontAccounting, LLC.
    Released under the terms of the GNU General Public License, GPL,
    as published by the Free Software Foundation, either version 3
    of the License, or (at your option) any later version.
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/includes/ui/items_cart.inc");

//--------------------------------------------------------------------------------

function add_to_order(&$order, $new_item, $new_item_qty, $standard_cost)
{
    $kit = get_item_kit($new_item);

    foreach($kit as $item) {
        if ($order->find_cart_item($item['stock_id']))
            display_error(_("For Part :") . $item['stock_id'] . " " . "This item is already on this document. You can change the quantity on the existing line if necessary.");
        else
            $order->add_to_cart (count($order->line_items), $item['stock_id'], $new_item_qty * $item['quantity'], $standard_cost);
    }
   
}

//--------------------------------------------------------------------------------

function display_order_header(&$order)
{
    global $Refs;

    start_outer_table(TABLESTYLE, "width='70%'");

    table_section(1);
   
    locations_list_row(_("From Location:"), 'FromStockLocation', null, false, false, $order->fixed_asset);
    locations_list_row(_("To Location:"), 'ToStockLocation', null,false, false, $order->fixed_asset);

    table_section(2, "50%");

    date_row(_("Date:"), 'AdjDate', '', true);

    ref_row(_("Reference:"), 'ref', '', $Refs->get_next(ST_LOCTRANSFER, null, array('date'=>get_post('AdjDate'), 'location'=> get_post('FromStockLocation'))),
         false, ST_LOCTRANSFER);

    end_outer_table(1); // outer table
}

//---------------------------------------------------------------------------------

function display_transfer_items($title, &$order)
{
    global $path_to_root;

    display_heading($title);
    div_start('items_table');
    start_table(TABLESTYLE, "width='80%'");
    $th = array(_("Item Code"), _("Item Description"), _("Quantity"), _("Unit"), '');
    if (!$order->fixed_asset && count($order->line_items)) $th[] = '';
    table_header($th);
    $k = 0;  //row colour counter

    $low_stock = $order->check_qoh($_POST['FromStockLocation'], $_POST['AdjDate'], true);
    $id = find_submit('Edit');
    foreach ($order->line_items as $line_no=>$stock_item)
    {

        if ($id != $line_no)
        {
            if (in_array($stock_item->stock_id, $low_stock))
                start_row("class='stockmankobg'");    // notice low stock status
            else
                alt_table_row_color($k);

            if ($order->fixed_asset)
                label_cell($stock_item->stock_id);
            else
                view_stock_status_cell($stock_item->stock_id);
            label_cell($stock_item->item_description);
            qty_cell($stock_item->quantity, false, get_qty_dec($stock_item->stock_id));
            label_cell($stock_item->units);

             if (!$order->fixed_asset)
                edit_button_cell("Edit$line_no", _("Edit"),    _('Edit document line'));
            delete_button_cell("Delete$line_no", _("Delete"), _('Remove line from document'));
            end_row();
        }
        else
        {
            transfer_edit_item_controls($order, $line_no);
        }
    }

    if ($id == -1)
        transfer_edit_item_controls($order);

    end_table();
    if ($low_stock)
        display_note(_("Marked items have insufficient quantities in stock as on day of transfer."), 0, 1, "class='stockmankofg'");
    div_end();
}

//---------------------------------------------------------------------------------

function transfer_edit_item_controls(&$order, $line_no=-1)
{
    global $Ajax;
    start_row();

    $id = find_submit('Edit');
    if ($line_no != -1 && $line_no == $id)
    {
        $_POST['stock_id'] = $order->line_items[$id]->stock_id;
        $_POST['qty'] = qty_format($order->line_items[$id]->quantity, $order->line_items[$id]->stock_id, $dec);
        $_POST['units'] = $order->line_items[$id]->units;

        hidden('stock_id', $_POST['stock_id']);
        label_cell($_POST['stock_id']);
        label_cell($order->line_items[$id]->item_description);
        $Ajax->activate('items_table');
    }
    else
    {
        if ($order->fixed_asset)
            stock_disposable_fa_list_cells(null, 'stock_id', null, false, true, $order->line_items);
        else
            sales_items_list_cells(null,'stock_id', null, false, true, true);
            // stock_costable_items_list_cells(null, 'stock_id', null, false, true);

        if (list_updated('stock_id')) {
                $Ajax->activate('units');
                $Ajax->activate('qty');
        }

        $item_info = get_item_edit_info($_POST['stock_id']);

        $dec = $item_info['decimals'];
           $_POST['qty'] = number_format2(0, $dec);
        $_POST['units'] = $item_info["units"];
    }

    if ($order->fixed_asset) {
        hidden('qty', 1);
        qty_cell(1, false, 0);
    } else
        small_qty_cells(null, 'qty', $_POST['qty'], null, null, $dec);

    label_cell($_POST['units'], '', 'units');

    if ($id != -1)
    {
        button_cell('UpdateItem', _("Update"),
                _('Confirm changes'), ICON_UPDATE);
        button_cell('CancelItemChanges', _("Cancel"),
                _('Cancel changes'), ICON_CANCEL);
        hidden('LineNo', $line_no);
        set_focus('qty');
    }
    else
    {
        submit_cells('AddItem', _("Add Item"), "colspan=2",
            _('Add new item to document'), true);
    }

    end_row();
}


//---------------------------------------------------------------------------------

function transfer_options_controls()
{
      echo "<br>";
      start_table();

      textarea_row(_("Memo"), 'memo_', null, 50, 3);

      end_table(1);
}


//---------------------------------------------------------------------------------

Phuong

Re: inventory location transfer from sales kit

@joe: is this okay to add into the core?

Re: inventory location transfer from sales kit

tested with fixed asset transfer without problem as well
the new file can be downloaded here: download

Post's attachments

stock_transfers_ui_new.zip 2.1 kb, 1 downloads since 2019-09-03 

You don't have the permssions to download the attachments of this post.
Phuong

Re: inventory location transfer from sales kit

This has been committed to 2.4.7 stable repo. Thanks @notrinos for your solution.

/Joe

Re: inventory location transfer from sales kit

notrinos wrote:

try replace the inventory/includes/stock_transfers_ui.inc with this code (also in attachment) then check if any problem

Hey Notrinos, thanks a lot for your help it sure works! really appreciate it.