Discussions
Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities
You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!
You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!
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
Tagged:
0