Netsuite has a default report called "Sales Reps B...
# administration
h
Netsuite has a default report called "Sales Reps By Activity" which includes standard activities such as Phone Call, Event, Task but also has Email & Notes included in it. Is there anyway to replicate this report to have it display all in one or have it as a saved search? • Currently management uses this above report for tracking sales rep activity metrics but wants better reporting so they can easily see a summary of activities by type completed on their dashboard and filter by rep if they need. • I run into the issue because emails & notes are not standard activities within NetSuite activity reports
m
It may work to create a saved search on the Customer record and then join to Activities, Messages and User Notes from the Customer record
h
Then I believe we would have to assume all Activities, Messages and User Notes were created by the customer's sales rep?
m
There are fields like Owner and Author on these records that you may be able to use to know who created them
But yes otherwise it would be an assumption that it was the sales rep
Last you could try to create a SuiteAnalytics Workbook using the 3 different tables, then use dataset joining to join on the created by. Then display a Table visualization of all the data in a SuiteAnalytics portlet for your team
👀 1
h
I think the last option is the most full proof, I may just do 2-3 separate reports for now and push for KPI's that better reflect how Netsuite functions