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):
0