1 Topic by ust.crew404

(2 replies, posted in Items and Inventory)

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

Go to forum: Items and Inventory