Solved

Question Smartlist Builder Microsoft Dynamics GP

Posted on 2012-03-28
7
732 Views
Last Modified: 2012-04-02
We started using Smartlist Builder and looks great.

We would like to know if we can use external databases or tables besided GP creates.

Thank you
0
Comment
Question by:rayluvs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 37780051
Hi,

SmartList Builder allows you to query non-GP databases and tables.  Go to Tools -> SmartList Builder -> Security -> SQL Table Security and select the tables and views.

So if you have custom tables in your GP database, it's easy to include them in a custom smart list.

I prefer to create views first, and then attach to those in SmartList Builder, but you can select multiple tables and do joins within SLB.  Just make sure to use GRANT statements to give DYNGRP access to the view (e.g. GRANT SELECT ON <view> TO DYNGRP).

It appears that SLB only displays the databases in the GP SQL instance.  I haven't tried connecting to a different SQL Server or instance.

Let me know if you have any additional questions.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:rayluvs
ID: 37780076
Thank you very much.  

So if we were to add another table from another database, not being the GP database working on, the best way is using a View where it would join these tables from another database and then use this View in Smartlist Builder.

Am I correct?
0
 

Author Comment

by:rayluvs
ID: 37780082
Hi, just noticed that the Query created in Smartlist Builder doesn't appear in the regular Smartlist so we can run them.

Si this also within "Tools -> SmartList Builder -> Security" so it can be used by users to display them?
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:rayluvs
ID: 37780349
Discard the last entry.  I opened up my other GP version 10 and the Queries created do show in Smarlist.  There must be  something wrong with the version 9 we are working in.  Will verify and if help needed regards this issue, will place another question.
0
 
LVL 18

Assisted Solution

by:Steve Endow
Steve Endow earned 500 total points
ID: 37783018
Hi,

Regarding your question about other databases, yes, creating a view to join in the other databases or external data sources should work.  Just make sure to test with non-sa users to ensure that there are no permission issues with the view accessing the non-GP data.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:rayluvs
ID: 37796368
Thank you very much!
0
 

Author Comment

by:rayluvs
ID: 37796404
Will proceed to close.

please revise the question regarding missing queue in smartlist
http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Dynamics/Q_27658583.html

Thanx
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question