Hello Pam Palmer
I have query for custome smartlist Bill of Materials in inventory module
Just exec on Company database and create Smartlist by using Smartlist Designer
create view ABC_BOM_Inventory_Detail
as
select
a.ITEMNMBR as 'Bill Number (Produce)',
b.ITEMDESC as 'Description (Produce)',
case b.ITEMTYPE
when 1 then 'Sales Inventory'
when 2 then 'Discontinued'
when 3 then 'Kit'
when 4 then 'Misc Charges'
when 5 then 'Services'
when 6 then 'Flat Fee'
else ''
end 'Item Type (Produce)',
case a.Bill_Status
when 1 then 'Active'
when 2 then 'Pending'
when 3 then 'Obsolete'
else ''
end [Bill Status Header],
case a.BM_Stock_Method
when 1 then 'Build If Necessary'
when 2 then 'Stock'
when 3 then 'Build'
else ''
end 'Stock Method',
a.UOFM as 'Base UofM Header',
c.ORD as 'Line Item Consume',
c.CMPTITNM as 'Component Item (Consume)',
d.ITEMDESC as 'Item Description (Consume)',
case d.ITEMTYPE
when 1 then 'Sales Inventory'
when 2 then 'Discontinued'
when 3 then 'Kit'
when 4 then 'Misc Charges'
when 5 then 'Services'
when 6 then 'Flat Fee'
else ''
end 'Item Type (Consume)',
c.UOFM as 'Base UofM (Consume)',
case c.Component_Status
when 1 then 'Active'
when 2 then 'Pending'
when 3 then 'Obsolete'
else ''
end [Component Status],
c.Design_Qty as 'Design Qty',
case c.Cost_Type
when 1 then 'Per Unit'
when 2 then 'Setup'
else ''
end 'Cost Type',
CAST(coalesce(CAST(c.Scrap_Percentage as NUMERIC(19,2))/CAST(100 as NUMERIC(19,2)),0) AS NUMERIC (19,2)) as 'Scrap %',
c.Effective_Date as 'Effective Date',
c.Obsolete_Date as 'Obsolete Date'
from BM00101 a
left join IV00101 b on a.ITEMNMBR = b.ITEMNMBR
left join BM00111 c on a.ITEMNMBR = c.ITEMNMBR
left join IV00101 d on c.CMPTITNM = d.ITEMNMBR
go
grant select on ABC_BOM_Inventory_Detail to DYNGRP
