Dynamics GP - Limit item list to Items with BOMS only - Manufacturer, Manufacturing Item Number and Manufacturing Item Description

The inventory smartlist has the fields Manufacturer, Manufacturing Item Number and Manufacturing Item Description which are all blank. To populate these fields, you have to update the Manufacturing Item Number Maintenance screen, and mark a line as primary.

These additional fields are located in the Item Purchasing Options window if you click on the yellow gear next to the item number.

Data is stored in the IV00115

If you want to populate this table with current internal BOM listing, you can use this script. It will populate any manufacturing data for any items with boms that have no populated manufacturing data.


INSERT INTO IV00115
                      (ITEMNMBR, MANUFACTURER, MNFCTRITMNMBR, ItemDesc, PRIMARYITEM)
SELECT     BM010415.ITEMNMBR, 'Mycompany' AS comp, BM010415.ITEMNMBR AS Expr1, 'Manufactured' as Mf, 1 as p
FROM         BM010415 LEFT OUTER JOIN
                      IV00115 AS IV00115_1 ON BM010415.ITEMNMBR = IV00115_1.ITEMNMBR
WHERE     (IV00115_1.DEX_ROW_ID IS NULL)

Now create a smartlist that filters on the Mfg. Item Description = "Manufactured"
You can Now use this smartlist as a filter on the item lookup screen
You can set it as a default if you wish