Parts that are not in the supplier price list

Hi all,

Is there a way to see all parts that are in the system but not in the supplier price list?

If this is done via a BAQ could i have some guidence on this

Many Thanks

I think you can accomplish this with a BAQ from the Part and VendPBrk tables. They are automatically joined on part number, so just add a subquery criteria to show only records where VendorPBrk.PartNum ISNULL. Make sure to change the join to left outer (arrow points from part to vendpbrk).
Good luck!