This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

*Amount* = CASE WHEN {type} = 'Journal' THEN {creditamount} ELSE NULL END

*Act. this Mo.* = CASE WHEN {itemnumber.custitemnumbersky_it_activation_date} BETWEEN to_date(TRUNC(TRUNC({today}, 'MONTH')-1,'MONTH'), 'MM/DD/YYYY') AND to_date(LAST_DAY(TRUNC({today}, 'MONTH')-1)) THEN 1 ELSE 0 END

*Act. last Mo.* = CASE WHEN {itemnumber.custitemnumbersky_it_activation_date} BETWEEN to_date(TRUNC(TRUNC({today}, 'MONTH')-1,'MONTH'), 'MM/DD/YYYY') AND to_date(LAST_DAY(TRUNC({today}, 'MONTH')-1)) THEN 1 ELSE 0 END