Currently using vew_manufacturerparts_ex to generate our BOM, which we order from. We want our Terminals to be listed in the BOM under their Parent Component, being the associated Terminal Block; in hopes of shortening our BOM sheet considerably.
Is there any comprehensive resource about the Expert Mode SQL Query?
I've done minor edits using Expert Mode, but can't use it efficiently.
I have played with editing the statement below, which affects how Electrical Assemblies are listed.
"WHERE ((bun_id = %CUR_BUNDLE_ID%) AND (bom_assemblyid=-1) AND (bom_objecttype != 9))"
If anyone has any insight on our problem, we do appreciate any answers.