Where is the data stored for Primary Supplier in Supplier Price List? I opened up Field Help but it does not show me the DB field. I am trying to create a query with criteria against this field.
Thanks!
Where is the data stored for Primary Supplier in Supplier Price List? I opened up Field Help but it does not show me the DB field. I am trying to create a query with criteria against this field.
Thanks!
I want to do this as well. I put in a Support ticket about a year ago and was given the following response:
The application wont be able to generate either a BAQ or any type of list to separate one from/or the other (Primary or Approved) because this are External fields which do not get save to the DB, so unfortunately the system wont be able to create this, but you can go to your local consultant and check it directly with them, they might be able to adapt the application/screen to your needs.
Folks, the Primary Supplier for an SPL part is indicated by a non-zero value in the PartPlant.VendorNum field. If you create a BAQ that joins VendPart to the PartPlant table, you can filter for parts that have a primary vendor.
HTH!
John