We are using the Payment Instruments feature (as this is the recommended configuration from our Payment Card Gateway provider).
When processing a Sales Order with a Sales transaction, NetSuite will create a Payment transaction if the card is processed succesfully.
If the card authorisation fails, then a 'Payment Hold' is placed on the Sales Order. This shows as a banner across the top of the Sales Order.
From checking Saved Search results, the 'Payment Hold' field is not completed in this case. The 'Payment Event Result' field shows 'HOLD' for any transaction on Payment Hold (and shows 'ACCEPT' for successful card payments).
The Order that is on 'Payment Hold' is prevented from appearing on the Print Picking Ticket list by default (which is good).
However, my Sales Order Approval workflow is approving the order (we have a number of rules that 'auto-approve' an Order if it meets certain criteria). Essentially, all I need to do is reference this 'Payment Event Result' field in my workflow to only auto-approve orders where this is blank or Accept.
My problem is I can't seem to reference this Payment Event Result field in the Workflow Criteria screen?
Why is this field available to Searches, but not Workflow Criteria??
Can I access this by converting the criteria to a Custom Formula and using {paymenteventresult} ?
Will I be able to just use: {paymenteventresult}!='HOLD'
or will the potential 'null' values cause an issue? Will I have to use NVL or similar?
Any help with the formula format would be greatly appreciated. Or is there a better way to prevent these Payment Hold orders from being approved?