Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to add invoice fields to the project saved search?
Hi all, I am trying to add invoice date, amount, number etc. to the project saved search, however, when I define field as Transaction : Invoice Number in the results subtab, saved search displays not only invoices and corresponding numbers, but if project is not invoiced, is displays bills' numbers, POs' numbers etc. Also, I tried with SQL CASE function in formula (text) like this: CASE WHEN {transaction.type} = 'Invoice' THEN {transaction.invoicenum} ELSE '' END, and it works, but when I try the same thing with formula (currency or date) to pull out invoice amount or date it shows error massage.