Report shows data in NS, but emails with this: There is no data available for the date/period selected.

Hello NetSuite Professionals Community.

We have a report whose output has been mailed to team members for a couple of years with expected results. Starting Jan 1, instead of report results, we receive:

There is no data available for the date/period selected.

If I access the report within NetSuite,  it is working fine.

Thank you in advance for any help you can provide.

Rookie Asked on January 9, 2023 in Reports.
Add Comment
2 Answer(s)

Check the report criteria and the report schedule itself. Sometimes you can setup different criteria in the schedule and so running the report in NetSuite doesn’t show you what it will look like when it goes out as scheduled, especially if you’ve changed the report subsequent to setting the report schedule.  My other thought is if you are setting some criteria in the filter footer of your report. The report filters are “sticky” meaning those values are saved and input automatically the next time you run the report (but just for you), so for instance if the report itself says to run for the current year, but in the filter area you’ve selected last year, the report schedule is going to run with the current year, even though every time you run it it shows last year.  As a test you could log out and clear your cache, or use a different browser you haven’t logged into NetSuite from and see if the report runs differently than you’ve been seeing it previously.

I have seen cases where the schedules get corrupted and you just have to recreate them all, but given that this happened crossing the year, I’m guessing you have some criteria on your report or the schedule that is pointing to the wrong period.

Intermediate Answered on January 12, 2023.
Add Comment

Hi.. thank you.

It was the schedule, and we had to recreate it to get it working again.

Rookie Answered on January 12, 2023.

No problem! Glad you got it working again! Feel free to accept my answer for future people with the same issue, and for those sweet sweet internet points 😉

on January 17, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor