Saved search formula criteria for quantity billed not equal to quantity fulfilled

AI generated answer (using internal Slack threads):

To create a saved search formula criteria where the quantity billed is not equal to the quantity fulfilled, you can use a formula (numeric) in your criteria. The formula would be

{quantitybilled} - {quantityshiprecv} != 0

. This formula will return true for records where the quantity billed is not equal to the quantity fulfilled/received. If you want to exclude all results that display a $0 value in a column that displays the amount fulfilled but unbilled, you can use a case statement in your saved search criteria. The formula would be

case when nvl(ABS((nvl({quantitybilled},0) - nvl({quantityshiprecv},0)) * {rate}),0) > 0 then 1 else 0 end

. This formula will return 1 for records where the absolute value of the difference between the quantity billed and the quantity fulfilled/received multiplied by the rate is greater than 0, and 0 otherwise. If you want to return any invoice that contains a line item where the quantity*rate does not equal the amount, you can use a formula (Numeric) in your criteria. You would replace the

{rate}

field with whatever the rate field is in your environment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******