This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

CASE WHEN ({custbody_appliance_gross_profit}) &lt; '18' THEN ':underage:' END

it's in a custom search and its flagging every order with the emoji

<@U03HP23MK0R> Is your custom field a currency field? Mayb that is causing an issue. You might have to convert it to a number in the formula. Just guessing because the NetSuite docs show that it should work if you use the 18 without quotes

Maybe. That might work. I think that is probably where your issue is coming from.

I've never used an emoji like that. It works just like that?

yeah, emojis display whichever is the one the OS uses

Any suitetscript Wizards on here who have a client script that will automatically add an extra line and an item ( like a warranty) to a sales order based on a flag on a different item that was added?

There are a few limitations but it sounds like from what you are describing the "Create Line" action will work for your use case

now its giving an invalid expression error

this is after updating the expression to be

CASE WHEN {custbody_appliance_gross_profit} &lt; 18% THEN ':underage:' END

I think because the output is an emoji and not a %. Forumula % would want to display a %

still throws an error with CASE WHEN {custbody_appliance_gross_profit} &lt; 18% THEN '18%' END

Case when {field} &lt; “18%” then  18% else 0 end 

you can’t do `&lt; 18%`.  What is the actual value of {custbody_appliance_gross_profit}?  It’s probably either `18` (a number) or `0.18`.  It’s not likely to be a string.

and even if it were a string, doing `&lt;` is only going to get what you want if you want alphabetical order.

you probably want `CASE WHEN {custbody_appliance_gross_profit} &lt; 18 THEN ':underage:' ELSE '' END` or something like that

<@U4TPAFXEC> is right, except I think output of a percent field when used in a formula like this is a decimal. .18

Is it possible to pay a portion of a vendor bill via credit card and the rest via eft? If so, how is this accomplished?

CASE WHEN {custentity1} &gt; .17 THEN 18 ELSE 0 END

this is so weird. I have it set to formula text and the code is CASE WHEN {custbody_appliance_gross_profit}) &gt; .1799 THEN 0 ELSE ':underage:' END

even tried CASE WHEN {custbody_appliance_gross_profit}) &gt; .1799 THEN 0 ELSE 'UNDER 18' END

did CASE WHEN TO_NUMBER({custbody_appliance_gross_profit}) &lt; .18 THEN 'UNDER 18' END

I'm not an expert on this so I don't have a reason why, but it seems if you mix output types it throws an error.
Try putting '0' instead of 0

When you had the else in the formula you were outputting a number else a string. Seems like NetSuite/SQL doesn't like that

oh, that makes sense. thanks for helping me troubleshoot through the issue

has anyone ever used a flat rate packages for USPS priority  with integrated shipping label

We messed up with our tax periods (non-US subs).

It is based on calendar months but supposedly it should start with Feb. So Q1, should be Feb, Mar and Apr and so on.

Is there a way to fix it?

I'd speak to support about this. It's very likely they can help

Thanks, Jon. Fortunately, I found a way to fix it.