Forum Stats

  • 3,686,721 Users
  • 61,100 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:
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!

Displaying item quantity in transaction returns an error in saved search results

edited Jan 10, 2022 5:16PM in Ask A Guru 5 comments


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!


This Week's Leaders

This Month's Leaders

All Time Leaders