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

I'm trying to add a CASE WHEN for Transaction type, on a TRANS LINE ITEM formula, but nothing is recognised
I've tried these
```CASE WHEN {transaction.type} = 'Sales Order'  
CASE WHEN {type} = 'Sales Order'```
Any ideas?

<@UAPHBR6TS> Sorry, typo in my post. It did have the =

<@UAPHBR6TS> ah ha , seems to work with

``` WHEN {baserecordtype} = 'workorder'  THEN```
but not when I have a nested Case under that condition

if you want to have multiple cases as the same condition then the syntax is `CASE WHEN {type} = x OR {transaction.type} = x`

I need to check the LINEITEM.SOURCE.  That field only appears on the WorkOrder, not Sales Order.

So I get an error on the SalesORder

<@U7XBU8Y3B>
I have this:

```CASE  WHEN {baserecordtype} = 'salesorder'  THEN
 (CASE

	WHEN	{quantitybackordered} = 0     THEN  '&lt;div style="color:black;background-color:#71DE28;padding:5px;text-align:center;"&gt;' || {quantitybackordered}
WHEN	{quantitybackordered} &gt; 0 THEN	 '&lt;div style="color:black;background-color:#F8450F;padding:5px;text-align:center;"&gt;' || {quantitybackordered}
ELSE ''

END)


WHEN {baserecordtype} = 'workorder'  THEN
 (CASE
	WHEN	{quantitybackordered} = 0     THEN  '&lt;div style="color:black;background-color:#71DE28;padding:5px;text-align:center;"&gt;' || {quantitybackordered}
WHEN	{quantitybackordered} &gt; 0 THEN	 '&lt;div style="color:black;background-color:#F8450F;padding:5px;text-align:center;"&gt;' || {quantitybackordered}
WHEN    {itemsource} = 'Phantom'then 'Phantom'

ELSE ''
END)

ELSE 'NOTHING'

END```


But on the Sales Order it errors saying it cannot find the ITEMSOURCE field - but it should'nt be looking for it as it is not in the case statement for 'salesorder'

{baserecordtype} = 'Sales Order' works, as when i have this, it works.  Just seems to break when nested.

```CASE   WHEN {baserecordtype} = 'salesorder' THEN 'SALES ORDER'
 WHEN {baserecordtype} = 'workorder' THEN 'Work Order'
ELSE  'Not work order or SO'
End```
