Join Slack
Powered by
I'm trying to find lines on certain orders that th...
# administration
b
b
01/21/2020, 8:14 PM
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
Open in Slack
Previous
Next