Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parts with usage on BOM's
- Thread starter rvb001
- Start date
I can think of a quick sql query.
Something off the top of my head like
Select * from IMITMIDX_SQL where item_no not in (SELECT comp_item_no FROM BMPRDSTR_SQL) AND item_no not in (SELECT item_no FROM BMPRDSTR_SQL)
In theory this should tell you which parts in the item master are not either either components or master bills.
Andy Baldwin
"Testing is the most overlooked programming language on the books!"
Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.
Something off the top of my head like
Select * from IMITMIDX_SQL where item_no not in (SELECT comp_item_no FROM BMPRDSTR_SQL) AND item_no not in (SELECT item_no FROM BMPRDSTR_SQL)
In theory this should tell you which parts in the item master are not either either components or master bills.
Andy Baldwin
"Testing is the most overlooked programming language on the books!"
Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.
- Status