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

Good evening.  I am trying to understand why this saved search criteria formula does not work:
This works:
`CASE WHEN ({type} = 'Item Receipt' AND SUBSTR({appliedtotransaction},1,8) = 'Transfer') THEN 1  ELSE 0 END`
When I add this, it does not work, why?
`CASE WHEN ({type} = 'Item Receipt' AND SUBSTR({appliedtotransaction},1,8) = 'Transfer') THEN 1 WHEN ({type} = 'Invoice' )THEN 1 WHEN ({type} = 'Cash Sale' )THEN 1  ELSE 0 END`

Thanks!