NetSuite Saved Search Export and Email Functionali...
# suitescript
a
NetSuite Saved Search Export and Email Functionality is really broken these days: • Export to CSV via icon click on the Saved Search = 24840 results -> Correct. • Export to Excel via icon click on the Saved Search = 24840 results -> Correct. (with the annoying .xls extension issue). • Email as Excel via Email icon button click on the Saved Search = 2206 results -> Incorrect • Email as CSV via Email icon button click on the Saved Search = 10001 results -> Incorrect The search does have run unrestricted checked.
m
the couple times i've had this same issue, it seemed to be related to the search criteria
i can't explain it well, but was able to reproduce the same incorrect email results when loading & running the search via script in both server-side script events & running code to load+run the search via browser console
the solution each time i've encountered it was to move the criteria around & simplify as best as possible using the expression parens
curious if yours is the same issue. i've dealt with it off and on for years across many client accounts and each time the same solution works. we had clients open support tickets with netsuite but have never gotten a root cause (or even a solution) from netsuite directly