I'm trying to create a search to find line items on Sales Orders where the Committed Quantity divided by the Casepack Quantity (this is a custom field we have setup on the item record) is not a Whole Number. So in other words, Netsuite is committing a number that is not an even casepack quantity. For example the casepack is 4 pieces and NS committed 3 pieces or 5 pieces.
Here is what I have tried using the MOD function in the search criteria of a transaction search using a numeric formula field
Is Greater then 0
REMAINDER({quantitycommitted}, {item.custitem_casepackqty})
I have also tried the MOD function using
Is less then 1
MOD({quantitycommitted}, {item.custitem_casepackqty})
In both cases I'm getting this error
Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.
Search: Transaction Search
Formula: REMAINDER({quantitycommitted}, {item.custitem_casepackqty})
Any suggestions?