Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
assign quantity based on Item name?
Hi,
I took your solution of:
case floor({custentity6}/500) when 0 then 'C' when 1 then 'B' else 'A' end
and trying to apply it somewhere else: (I'm trying to be creative) :rolleyes:
case floor {item} when "item1" OR "item2" then '1' when "item3" OR "item4" then '2' else '3' end
basically if the name of my item is "item1" (or 2) assign 1
2. does this field have to be integer or could be free-form?
3. what is floor? part of the language or can I rename it?
thanks,
Yosi
0