Skip to main content
14-Alexandrite
Nov 16, 2026 4:38 PM UTC
Question

How to Report Vendor from Query Builder?

I’m using query builder to build a customized BOM report. I have the report correctly giving me the part structure with all properties, but I cannot get the part vendor to show up. The sourcing relationship breaks the report and it returns nothing when added. However, I can use the same relationship in a standalone report and it returns the vendor. 

 

 

    1 reply

    MarcoTosin
    21-Topaz II
    Nov 16, 2026 5:12 PM UTC

    You didn't specify which module you're referring to when talking about the vendor, but I assume it's SuMa.

    In that case, you might find this HUB article on SuMa reports helpful:

    https://www.ptc.com/en/support/article/CS385132

     

    And you'll probably also need to use some outer joins, which I don't see in the image you attached.

     

    How can an Outer Join be used when creating a report

     

     

    Translate
    Marco