This Dynamics GP script will show how many customers are under each salesperson. A gr

[Monzer Osama]

This Dynamics GP script will show how many customers are under each salesperson. A great tool to tell who your most active salespersons are!

SELECT S.SLPRSNID, S.SLPRSNFN, S.SPRSNSLN, COUNT(C.CUSTNMBR)
FROM RM00301 S
INNER JOIN dbo.RM00101 C ON C.SLPRSNID = S.SLPRSNID
GROUP BY S.SLPRSNID, S.SLPRSNFN, S.SPRSNSLN 
ORDER BY S.SLPRSNFN, S.SPRSNSLN