Non po based AP invoice requiring approval
My issue is I am trying to create an approval process based on the requirement that all AP invoices entered directly as an AP invoice (as opposed to PO or GRN) on the system require approval.
What I have done to date is I have created a UDF on marketing documents U_BPCODE and created a formatted search to populate this field wiht the BP code that appears on the AP Invoice. As this formatted search does not exist on the PO or GRN, any document being copied into an AP invoice should not be populating this UDF.
From there i have then created a formatted search as follows
SELECT Distinct 'True' FROM OPCH WHERE U_BPCODE = $[4.0.0]
However this query always returns a value of TRUE even when the field U_BPCODE is left blank.