Discussions
Case Formula - ERROR: Invalid Expression? What am I doing wrong?
How I wished the saved search would allow you to troubleshoot your formulas!!
I am doing a text formular that says this:-
CASE when {type} = 'Deposit' then 'AR Receipts' when {type} = 'Customer Refund' then 'AR Receipts' when {type} = ‘Payment’ then ‘AR Receipts’ when {type} = ‘Transfer’ then ‘Intercompany Transfer’ ELSE 'Other' end
I am trying to come up with my own cash report showing how funds have been used! The cashflow report within NS does not handle journal entries....
Another resource that would be helpful is if someone could take excel formulars and convert them to Netsuite lingo - like if you have