Hi NetSuite Professionals! I need your help. I am ...
# general
h
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!
t
Does this work? You have an extra || at the end rather than an 'else'. case when {type}='Customer Deposit' then {appliedtotransaction} when {type}='Deposit Application' then {‌createdfrom.salesorder} when {type}='Sales Order' then 'Sales Order #' else {number} end
h
Thanks Tim but it still didn't work.