1 Topic by ust.crew404 (edited by ust.crew404 07/22/2020 01:34:35 am)

  • From: Indonesa, Java
  • Registered: 07/22/2020
  • Posts: 1

Topic: Item Description on Item & 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

  • Registered: 04/19/2020
  • Posts: 60

Re: Item Description on Item & Inventory

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

flpages's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Item Description on Item & Inventory

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

apmuthu's Website