FrontAccounting forum — Item Description on Item & Inventory

Re: Item Description on Item & Inventory

2020-07-23T17:03:30Z

Wonder why the i.inactive is part of the SELECT column list when it is always 0 (ie., active) as per the WHERE clause.

Re: Item Description on Item & Inventory

2020-07-23T08:38:31Z

Hi, are you asking where is the SQL statement located?
It is in includes/ui/ui_list.inc

Item Description on Item & Inventory

2020-07-22T01:31:34Z

I have a problem, in list item description unsuitable then active the SQL and I see the query.
where location this query?
SELECT i.item_code, i.description, c.description, count(*)>1 as kit,
i.inactive, if(count(*)>1, '0', s.editable) as editable
FROM
1_stock_master s,
1_item_codes i
LEFT JOIN
1_stock_category c
ON i.category_id=c.category_id
WHERE i.stock_id=s.stock_id
AND mb_flag != 'F' AND !i.inactive AND !s.inactive AND !s.no_sale GROUP BY i.item_code ORDER BY c.description,i.item_code

I am using FA version 2.4.8