FrontAccounting forum — View_po.php

Re: View_po.php

null@example.com (Alaa) — Wed, 08 Nov 2017 12:13:29 +0000

Thanks a lot.

Re: View_po.php

null@example.com (apmuthu) — Wed, 08 Nov 2017 09:11:19 +0000

The $stock_item is an element of $purchase_order->line_items. The $purchase_order object gets populated from the function read_po() defined in purchasing/includes/db/po_db.inc. The stock_master table provides only the units field in the sql in the function read_po_items it calls therefrom. Extend it by appending long_description and use it where you want.

Alter line 210 in purchasing/includes/db/po_db.php:

    $sql = "SELECT poline.*, units

to be:

    $sql = "SELECT poline.*, units, long_description

and then use it in the view_po.php file.

View_po.php

null@example.com (Alaa) — Tue, 07 Nov 2017 20:53:02 +0000

Hello,,
in this view
purchasing/view/view_po.php
i'd like to show long_description instead of item_description .. but it seems that the long description is stored in stock_master table..

is there an easy way to replace this code line 69

label_cell($stock_item->item_description);

so it'd show the long description??

Regards.