We want to create a mandatory UDF to identify invoice order line quantites with quantity of specified inventory items are not between ranges identified per each item in user defined fields. We have created a UDF with the following formatted search to accomplish this:
SELECT ' '
( $[$38.11.NUMBER] NOT BETWEEN
$[$38.U_RWeightMin.NUMBER] AND $[$38.U_RWeightMax.NUMBER])
When we use this query, instead of blanking out the fields for items that meet the criteria, it blanks out every quantity per each line of the invoice.
Any ideas on what we are doing wrong?
Thanks for your help