Hi,

Using Iman 3.2
I'm attempting to look for values in the SYS.ERROR message after a failed order import attempt into Sage300.
I need to identify records that contain "1000 - Negative inventory levels are not allowed for item *". Note wildcard.

I know that a filter can use the normal operators =, , >= etc but have no luck using 'Like' for example
%OE0500_SYS.ERROR Like "1000 - Negative inventory*"

Unexpected identifier [Like]

Is there a way to do this?

I appreciate I can check for negative inventory prior to running the order import connector and filter records out at that stage
However this will create inaccurate results as items may go out of stock during a batch run of multiple orders.

Could one option to be to construct the exact match error message ahead of time and then use the = operator
Perhaps %OE0500_SYS.ERROR = %Constructed_Field

Thanks

Colin