Hi NetSuite Professionals! I need your help. I am trying to create a saved search to track the Customer Deposits Balance but I'm getting an error - ERROR: Invalid Expression when I use the following Formula (Text):
case when {type}=’Customer Deposit’ then {appliedtotransaction} when {type}=’Deposit Application’ then {createdfrom.salesorder} when {type}=’Sales Order’ then ‘Sales Order #’||{number} end
Help please? Thank you!