Approval Process to require Approval for non-Euro Purchase Orders
I am trying to create an Approval Process whereby any PO that is raised in a Currency other than the EURO will cross my desk.
I am having difficulty creating the SQL query necessary to isolate these Orders. Anyone able to help me?
The query given by Istvan should work:
If $[OPOR.DocCur\] != 'EUR'
Save it under one of you user query folder with any name such as POApproval. Then assign it through alert menu. Do not run it. It is not runnable under query generator.