I'm trying to find lines on certain orders that th...
# administration
b
I'm trying to find lines on certain orders that the qty ordered is larger than available in a saved search, I have a formula numeric
{quantity} -  {item.locationquantityavailable}
is greater than 0, however it is not pulling in the lines in which qty available at location is zero. I've tried
nvl({item.locationquantityavailable},0)
but it does not work