Hey Everyone,
Working on filtering off a vendor/purchase from combination in managed purchase requests. We utilize vendor#15476 for special orders that require review, but use vendor#15476 and PurchaseFrom P002 for punchout orders that pass through with the PO creation job. The buyer wants to see all 15476 requests to review, and ignore all 15476 P002 requests as they will auto process.
Want to Exclude: 15476 P002
Want to include: 15476
I tried using (Vendor != 15476 and PurchaseFromLocation != "P002"), but this did not work. It would filter off all 15476 P002 and all 15476 without a purchase from.
Anyone have a suggestion on how to exclude only the combination of Vendor/PurchaseFrom without excluding Vendor?
Thanks,
Ben