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

Hello all, I am looking to create a saved search Inventory items sold count for  30 days, 60 days ,90 days, 120 days +. Is there any formula that can help to get the count for the required days only. I tried one formula for 30 days 'case when {trandate} &gt;= ({today}-30) then {quantity} else 0 end' and it seems to work well. But did not found how it will work for 120+ days . Any help will be appreciated. Thanks!

Try SA 67998, i think it will be a good start

Transaction Saved Search &gt; Item Quantity On Hand and Quantity *Sold* as of specific period

Thank you , I am looking something to have different columns for Quantity sold in 30 days, Quanitity sold in 60 days

do you want 30, 60, 90, 120+ or month will do?

• Select *Date*
    ◦ _Summary Type_: Select *Group*
    ◦ _Function_: Select *Month*


I often do a similar one comparing posting periods. Something like CASE WHEN {postingperiod} = TO_CHAR(ADD_MONTH({today},-2),’Mon-YYYY’) THEN {quantity} ELSE 0 END

This one gives the quantity from 2 months ago. You can add additional columns for your other periods. 