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
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!