Has anyone had any luck using the “Purchased Before” flag in Purchase Advisor? I’m trying to build a BAQ that lists all part numbers that have been purchased, but wanting to exclude certain vendors.
Hi Kyle,
My only experience with Purchase advisor is that it is site specific on the answers to the questions. Querying RcvDtl would be the best bet to review. I was going to suggest PODtl but depending on your organisation maybe not all POs would be kept up to date.
Regards
Matt
I’ll check both tables and see which is the best fit. Real quick, are you aware if either of the tables list a field (or flag) that defines the vendor we purchased from?
Thanks for responding, Matt.
You would be able to lookup who the vendor was from the PO Number.
Thanks, Matt. I believe I have it figured out.