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 SUMIF(B2:B5, "John", C2:C5) how do you do this in Netsuite saved search... or IF(A2>B2,"Over Budget","OK") and so on... to me this is how us accountants think and we are trying to write saved searches to avoid having to subsquent manipulation within Excel!
All guidance is appreciated.
Lisa