How Do I? | Forum | Realisable

Back to forum list… Back to How Do I?...

Filter Operators (1 reply)

Colin Ash

3 years ago

Colin Ash 3 years ago

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

Colin Ash

3 years ago

Colin Ash 3 years ago

Hi, Just wanted to update on this.
I have had success by constructing the exact potential error message ahead of time and checking it in the filter as above.

Here is the constructed field script:

Dim VALUE
VALUE = "1000 - Negative inventory levels are not allowed for item " &%[Item Number]& " at location " &%Location& "."
VALUE

This does the trick but I wondered if there was a more elegant solution?

Colin

Filter Operators (1 reply)

Contact

Request Demo

Access Downloads

Username
Password

	Remember Me Lost your password? Register