Smartlist Builder Troubleshooting Suggestions

[Scott S.]

I've created a view that shows vendor purchases and I used a "union all" to
select the specific companies I want included in the view. The view is in the
dynamics database. I've configured the Smartlist Builder security to enable
the view to be selected, as well as the underlying tables. I've also granted
the necessary GP security so the users can see the Smartlist Builder.

If the SA account runs the Smartlist they get the proper results. If the
user runs the same Smartlist, they get 0 results and I cannot figure out why.

Any suggestions on how to determine why the user cannot see any records, but
the SA account can? (I tried making the user a PowerUser as a test, but that
didn't work.)

Thanks

[Mariano Gomez]

Have you granted permissions to the DYNGRP role in SQL Server?

GRANT SELECT ON dbo.SomeView TO DYNGRP;

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[Scott S.]

Yes, I just double checked and the DYNGRP has select permissions on my view

[Mariano Gomez]

Now, this may sound like a dumb question, but does the user or users have
access in GP to all the companies unioned by the SQL server view?

[Scott S.]

No problem with the question. I thought of this myself. I have to double
check, but I believe that the user has the identical access in every GP
company. If they did not have access to one company, would that cause the
smartlist to not return any results at all?

I will dial into their system today and confirm that the test user has
rights in all the companies included in the view.