I have created a Quick Search for Incoming Intercompany PO Suggestions that, among other things, allows the user to filter by Company ID of the incoming ICPO. However, I would like to filter out any that have been flagged as REJECTED.
The only place I can find this data is in IMOrderHed.Reject which, to my knowledge, cannot be accessed through a BAQ.
I am able to create an external connection to the SQL database but that won’t work for a Quick Search (I believe).
Any suggestions?
Thanks!