I am trying to create a dataset to show all the items used on our top level assemblies. I have tried using Bill of Materials, Bill of Materials Revision, and Bill of Materials Revision Component and have not been able to make the joins. How would one go about creating this?
I was able to do this to some extent before we turned on Advanced BOM.
It seems like there is a join missing on the Assembly record in the data.