Hi Everyone, I would like to know if it's possible to create a saved search in NetSuite that retrieves the same data as you can see in the attach screenshot, but based on a selected date range. Alternatively, is there any existing standard report or saved search in NetSuite that provides similar information?

The AR Aging reports is just that.

Yes, you’re correct. However, in the aging report, we only get the remaining or due amount. I'm trying to find out how we can include additional columns based on the selected date period.

Saved searches in NetSuite can be powerful, but getting dynamic, date-driven views like the one in your screenshot can sometimes be tricky—especially when you're trying to mimic a report-style layout with totals or multiple joins. This is actually one of the common cases where SuiteReport really shines. It lets you connect live NetSuite data directly into Excel, apply custom date ranges, and ask questions in plain English like: "Show me total sales by customer between Jan 1 and Mar 31." You get real-time answers without writing a saved search, and everything stays secure and role-based. Happy to share a demo or walk you through how others are handling similar reporting needs! https://suitereport.ai/

I suggest using the Saved Search. We can use the formula for this.