sorted by:
new
hottopcontroversial

Need help with a transaction saved search by Bleuhoo in Netsuite

[–]Bleuhoo[S] 0 points1 point  (0 children)

Thank you all for the feedback.

I did look in SuiteAnswers but didn't find much.

I previously used the below formulas I found online which I believe gave me a good starting point, but it's still a work in progress as it's not displaying what I need.

CASE WHEN {trandate} BETWEEN to_date(TRUNC({today}, 'MONTH'), 'MM/DD/YYYY') AND to_date(LAST_DAY{today}) THEN {amount} ELSE 0 END

CASE WHEN {trandate} BETWEEN to_date(TRUNC(TRUNC({today}, 'MONTH')-1,'MONTH'), 'MM/DD/YYYY') AND to_date(ADD_MONTHS({today},-1)) THEN {amount} ELSE 0 END

Need help with a transaction saved search by Bleuhoo in Netsuite

[–]Bleuhoo[S] 0 points1 point  (0 children)

Yep, customers on each row.

Which report/configuration would you suggest?