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!
Sales Order Saved Search to show last months Invoice Amounts
CASE WHEN {applyingtransaction.trandate} between trunc(add_months({today}, -1), 'month') AND last_day(add_months({today}, -1)) THEN sum({applyingtransaction.amount}) ELSE 0 END
I have this great saved search that shows Sales Order, Project Last invoice date, last invoice amount, total invoice amount and now management want to add last month invoice amount and 2 month ago invoice amount. I tried the above Case When statement and it didn't work. I stated with a 1 else 0 and that is showing other counts other than 1 and 0 (like 3 and 4). I tried to research this and they are not the number of applied transactions.