تقرير تثبيت ال item group بناء على حركة المبيعات وفقا للcost center

ItemGroup.sql

select 
`tabSales Invoice`.branch,
  sum(case when `tabItem`.item_group = 'موكيت' then  `tabSales Invoice Item`.qty else 0 end) AS موكيت,
  sum(case when `tabItem`.item_group = 'ممرات' then  `tabSales Invoice Item`.qty else 0 end) as 'ممرات',
  sum(case when `tabItem`.item_group = 'كولا' then  `tabSales Invoice Item`.qty  else 0 end) as كولا,
  sum(case when `tabItem`.item_group = 'سجاد' then  `tabSales Invoice Item`.qty else 0 end) as 'سجاد',
  sum(case when `tabItem`.item_group = 'دواسات' then `tabSales Invoice Item`.qty else 0 end) as دواسات
  from `tabSales Invoice Item`
INNER JOIN `tabSales Invoice`
on `tabSales Invoice`.name = `tabSales Invoice Item`.parent
INNER JOIN `tabItem` 
on `tabItem`.name = `tabSales Invoice Item`.item_code
Group By
`tabSales Invoice`.branch