Solved

Question Smartlist Builder Microsoft Dynamics GP

Posted on 2012-03-28
7
722 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now