FrontAccounting forum — Display quantity on hand on purchase order

Re: Display quantity on hand on purchase order

2021-05-31T04:28:13Z

Yes dude I have got your email and replied you back.

Re: Display quantity on hand on purchase order

2021-05-31T01:56:42Z

kvvaradha wrote:

this will work for you. you need to open your po_ui.inc

and paste you need to update this code inside display_po_items

     $th = array(_("Item Code"), _("Item Description"), _("Qty in Hand"),_("Quantity"), _("Received"),
           _("Unit"), _("Required Delivery Date"), $order->tax_included ? _("Price after Tax") : _("Price before Tax"), _("Line Total"), "");

    if ($order->trans_type != ST_PURCHORDER)
        array_remove($th, 6);
    if ($new)
        array_remove($th, 4);

and then you need to update this code

 $dec2 = $_POST['qty_hand'] = 0;

and few more lines to be updated.

$_POST['qty_hand'] = get_qoh_on_date($_POST['stock_id']);
        if (list_updated('stock_id')) {

                $Ajax->activate('price');
                $Ajax->activate('units');
                $Ajax->activate('qty');
                $Ajax->activate('req_del_date');
                $Ajax->activate('line_total');
                $Ajax->activate('items_table');
        }

and then you need to add the display function to see them in results.

}
    label_cell(price_format($_POST['qty_hand']));
    if ($order->fixed_asset) {

if you update this code you can see them in po, grn, direct invoices pages with quantity in hand

Please reply me, I have also contacted you by forum email.

Re: Display quantity on hand on purchase order

2021-05-28T01:07:49Z

I am weak in language, I would be grateful if you could tell me the line number of po_ui.inc, in which these codes have to be updated or added .

Re: Display quantity on hand on purchase order

2020-11-07T07:52:34Z

I got above to work, now what's missing is to make quantity on hand appear on the printed copy.

What file am I meant to update?

Thanks

Re: Display quantity on hand on purchase order

2020-11-05T12:10:26Z

this will work for you. you need to open your po_ui.inc

and paste you need to update this code inside display_po_items

     $th = array(_("Item Code"), _("Item Description"), _("Qty in Hand"),_("Quantity"), _("Received"),
           _("Unit"), _("Required Delivery Date"), $order->tax_included ? _("Price after Tax") : _("Price before Tax"), _("Line Total"), "");

    if ($order->trans_type != ST_PURCHORDER)
        array_remove($th, 6);
    if ($new)
        array_remove($th, 4);

and then you need to update this code

 $dec2 = $_POST['qty_hand'] = 0;

and few more lines to be updated.

$_POST['qty_hand'] = get_qoh_on_date($_POST['stock_id']);
        if (list_updated('stock_id')) {

                $Ajax->activate('price');
                $Ajax->activate('units');
                $Ajax->activate('qty');
                $Ajax->activate('req_del_date');
                $Ajax->activate('line_total');
                $Ajax->activate('items_table');
        }

and then you need to add the display function to see them in results.

}
    label_cell(price_format($_POST['qty_hand']));
    if ($order->fixed_asset) {

if you update this code you can see them in po, grn, direct invoices pages with quantity in hand

Display quantity on hand on purchase order

2020-11-04T13:35:30Z

Hello team,

How can the subject be arrived at?

It is a control for our firm to avoid overstocking.

Thanks in advance