FrontAccounting forum — Item Description on Item & Inventory

Re: Item Description on Item & Inventory

null@example.com (apmuthu) — Thu, 23 Jul 2020 17:03:30 +0000

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

null@example.com (flpages) — Thu, 23 Jul 2020 08:38:31 +0000

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

Item Description on Item & Inventory

null@example.com (ust.crew404) — Wed, 22 Jul 2020 01:31:34 +0000

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