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!
Displaying item quantity in transaction returns an error in saved search results
Hi,
I'm creating a saved search to display some items and everything is working well.
I added the following text formula in results:
CASE WHEN {quantityonorder} > 0 THEN {transaction.item} ELSE ' ' END
this displaying the item id in the transaction correctly.
When I add the same formula to display the quantity, it returns an error: The following is the formula:
CASE WHEN {quantityonorder} > 0 THEN {transaction.quantity} ELSE ' ' END
But when I use {transaction.quantity} only as a formula, it returns the correct quantity, but for all items. and I want to display it only for items on order