{
global $all_items;
- $sql = "SELECT stock_id, s.description, c.description, inactive
+ $sql = "SELECT stock_id, s.description, c.description, s.inactive
FROM ".TB_PREF."stock_master s,".TB_PREF."stock_category c WHERE s.category_id=c.category_id";
return combo_input($name, $selected_id, $sql, 'stock_id', 's.description',
global $all_items;
// all sales codes
$sql = "SELECT i.item_code, i.description, c.description, count(*)>1 as kit,
- inactive
+ i.inactive
FROM
".TB_PREF."item_codes i
LEFT JOIN
{
global $all_items;
- $sql = "SELECT stock_id, s.description, c.description, inactive
+ $sql = "SELECT stock_id, s.description, c.description, s.inactive
FROM ".TB_PREF."stock_master s,".TB_PREF."stock_category c WHERE
s.category_id=c.category_id";
$cells=false, $all_option=false, $submit_on_change=false)
{
if ($skip_bank_accounts)
- $sql = "SELECT chart.account_code, chart.account_name, type.name, inactive
+ $sql = "SELECT chart.account_code, chart.account_name, type.name, chart.inactive
FROM (".TB_PREF."chart_master chart,".TB_PREF."chart_types type) "
."LEFT JOIN ".TB_PREF."bank_accounts acc "
."ON chart.account_code=acc.account_code
WHERE acc.account_code IS NULL
AND chart.account_type=type.id";
else
- $sql = "SELECT chart.account_code, chart.account_name, type.name, inactive
+ $sql = "SELECT chart.account_code, chart.account_name, type.name, chart.inactive
FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type
WHERE chart.account_type=type.id";