You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

When trying to add action check on invoice refnum, but it's not working

Summary:

I have used below queries to add an action check to restrict if one invoice refnum is not present, but it is not working.
Can you please help me on this?

SELECT INV.INVOICE_GID FROM INVOICE INV WHERE INV.INVOICE_GID=? AND NOT EXISTS (SELECT 1 FROM INVOICE_REFNUM INVR WHERE INVR.INVOICE_GID=INV.INVOICE_GID AND
INVR.INVOICE_REFNUM_QUAL_GID != 'DOMAIN_NAME.ORDER_NUMBER')

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!