Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Quantity Available 'In Stock' Formula Field Not Working
I can't seem to get the {quantityavailable} field working on a custom transaction column field. Even by itself, with no case statements, it doesn't show anything when the standard Available column is showing a value. I am trying to get the custom column to say 'IN STOCK' if the Qty Available is greater than 0 and OUT OF STOCK if not.
I have tried:
case when {quantityavailable}<=0 then 'OUT OF STOCK' else 'IN STOCK' end
case when {location}=1 and {quantityavailable}<=0 then 'OUT OF STOCK' else 'IN STOCK' end
case when NVL({quantityavailable},0)<=0 then 'OUT OF STOCK' else 'IN STOCK' end