Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList. I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3: STEP 1 - create SQL view To start […]
Read more
Tag Archives: SmartList Builder
SQL view to show security roles and tasks in Dynamics GP 10
March 12, 2009 
13 Comments
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]
Read moreAdding Extender Data to SmartLists
November 3, 2008 32 Comments
This has been a very popular question for support lately: “I have created an Extender window, how do I add data from it to my SmartLists?” Extender includes the ability to add fields to both existing SmartLists or ones created in SmartList Builder. Below is an example using GP 9.0. [Click on any of the […]
Read more Granting access to a new SmartList in Dynamics GP
October 8, 2008 62 Comments
We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists in GP 10.0 and GP 2010. Because this is so different from prior versions of Dynamics GP, we’ve created a really detailed list to go through it. This may be overkill for some, but it will hopefully cover every needed scenario. […]
Read moreMy Book
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail in GP
-
SQL view for all posted GL transactions in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for sales by item by month
-
Assign sequential numbers in SQL Server
-
SQL view for current Receivables aging detail in Dynamics GP
-
SQL view for current Payables aging detail in Dynamics GP
-
Changing part of a string in SQL Server using REPLACE
-
SQL view for sales quantities by item by site by year
-
SQL view for Fixed Allocation Accounts in Dynamics GP
-
Happy New Year – 2013
-
How to add a sparkline to a report in SSRS
-
Voiding a partially applied Payables transaction in Dynamics GP
-
Big announcement for Microsoft Dynamics GP’s Extender module
-
Victoria Yudin: Hi Rolan, There is no way to 'edit' this once pos...
-
Rolan Hinayon: Hi Victoria I am newbie here but it feels li...
-
-
Calvin: Thanks Victoria, that worked. I gave permissions t...
-
-
-
-
lynbarr: FYI, MR 2012 RU5 = 2.1.1037.15...
-
-
Carrie John: This process works great when it's a non-PO transa...
