Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 400 resources listed. - Rose Business Solutions Blog New
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: SmartList Builder
Links Sort by: Hits | References | Alphabetical
SmartList Builder based on SQL View not returning data
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/06/23/smartlist-builder-based-on-sql-view-not-returning-data.aspx
Posted by
Recommended byhttp://msdynamicsgp.blogspot.com/2010/06/smartlist-builder-based-on-sql-view-not.html
http://www.vaidy-dyngp.com/2010/06/smartlist-builder-view-returning.html
http://msdynamicsgp.blogspot.com/2010/06/smartlist-builder-based-on-sql-view-not.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+DynamicAccounting+%28Dynamic+Accounting%29
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/08/31/21-reasons-why-every-workstation-should-have-the-support-debugging-tool-installed.aspx
http://www.vaidy-dyngp.com/2010/06/smartlist-builder-view-returning.html
http://msdynamicsgp.blogspot.com/2010/06/smartlist-builder-based-on-sql-view-not.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+DynamicAccounting+%28Dynamic+Accounting%29
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/08/31/21-reasons-why-every-workstation-should-have-the-support-debugging-tool-installed.aspx
Feature of the Day: Drill Down Builder
http://blogs.msdn.com/gp/archive/2010/02/23/feature-of-the-day-drill-down-builder.aspx
Drill Down Builder
Module: SmartList Builder
Why this feature is cool!
You can be browsing an Excel report and drill right into the Microsoft Dynamics GP screen that is related to the data you are looking at. Drill Down builder allows you to further enhance the Microsoft Office and Microsoft Dynamics GP integration story. With the same model as the builder tools, Drill Down Builder is configurable by the end user: define the window you would like to be able to drill down to, in any module, from any product, including 3rd party Dexterity products.
The drill downs you build can be automatically embedded within Excel Report Builder Reports…
Posted by
How to use a SQL view in SmartList Builder
http://victoriayudin.com/2009/04/20/how-to-use-a-sql-view-in-smartlist-builder/
View Smartlists with SQL Tables
http://www.vaidy-dyngp.com/2010/06/view-smartlists-with-sql-tables.html
Have you ever wondered why your Smartlist, created using Smartlist Builder and a SQL Table / View (which is not part of any of…
Posted by
Smartlist Builder Security for SQL Server Views
http://dynamicsgpblogster.blogspot.com/2008/12/smartlist-builder-security-for-sql.html
GP 2010 Feature #6: Drill Down Builder Deep Dive
http://computerationdynamics.blogspot.com/2010/06/gp-2010-feature-6-drill-down-builder.html
A few weeks back we introduced the Drill Down Builder feature. As you may remember, Drill Down Builder completes the Microsoft Office and Microsoft Dynamics GP integration story. With the same model as the builder tools, Drill Down Builder is configurable and allows you to define the window you would like to be able to drill down to, in any module, from any product, including 3rd…
Posted by
The Smartlist Builder GoTo won't open my window
http://blogs.msdn.com/developingfordynamicsgp/archive/2010/03/26/The-smartlist-builder-goto-wont-open-my-window.aspx
GP 2010 Feature #2: Drill Down Builder
http://computerationdynamics.blogspot.com/2010/04/gp-2010-feature-2-drill-down-builder.html
Last time, we talked a bit on the great feature of drilling down into the GP 2010 dashboard. Well this week, we’re taking a closer look at the Drill Down Builder. This feature makes it possible to be browsing an Excel report and drill right into the Microsoft Dynamics GP screen that is related to the data you are looking at. Drill Down Builder completes the Microsoft Office and Microsoft Dynamics GP integration story. With the same model as the builder tools, Drill Down Builder is configurable and allows you to define…
Posted by
Summary SmartLists in Builder (Sales by Item for a date range, etc)
http://gpbuilders.wordpress.com/2010/06/03/summary-smartlists-in-builder-sales-by-item-for-a-date-range-etc/
One of the great features of SmartList builder is the ability to create a summary…
Posted by
If then else in Calculated Field in SmartList Builder? Try CASE
http://gpbuilders.wordpress.com/2010/05/11/if-then-else-in-calculated-field-in-smartlist-builder-try-case/
OK, so you want to use an If …then…else in a Calculated field on your SmartList… Sorry, ’If…
Posted by
Changing SQL Server views for SmartList Builder smartlists
http://dynamicsgpblogster.blogspot.com/2009/01/changing-sql-server-views-for-smartlist.html
Posted by
How to create a Go To link to the Apply Sales Document window in SmartList Builder
http://dynamicsgpblogster.blogspot.com/2008/07/how-to-create-go-to-link-to-apply-sales.html
A few days aback, my buddy Jim Harris at TurboChef was having an issue with creating a Go To in SLB that would link open credits and return documents displayed in SmartList to the Apply Sales Documents window in GP where he could effectively apply documents that had not been applied to invoices, etc.
I thought, how complicated could that be? You open SLB, you setup your SmartList fields then, setup your restrictions for RM Document Type-All equal or greater than 7, and add the Go To by matching the Customer Number field on the window to the Customer Number in the RM Open Table, the Document Type on the window with the RM Document Type-All field in the table, and the Document Number in the window withe the Document Number in the table, a few…
I thought, how complicated could that be? You open SLB, you setup your SmartList fields then, setup your restrictions for RM Document Type-All equal or greater than 7, and add the Go To by matching the Customer Number field on the window to the Customer Number in the RM Open Table, the Document Type on the window with the RM Document Type-All field in the table, and the Document Number in the window withe the Document Number in the table, a few…
Posted by
Bug: SmartLists Builder not Formatting SQL Correctly in Microsoft Dynamics GP 10
http://dynamicsgpblogster.blogspot.com/2008/07/bug-smartlists-builder-not-formatting.html
It appears that SLB cannot format the SQL query required to extract data after adding a few restrictions. Specifically, any query requiring more than one restriction will ommit the AND operator. This has been documented…
Posted by
SmartList Builder and SQL Tables/Views
http://dynamicsgpland.blogspot.com/2009/12/smartlist-builder-and-sql-tablesviews.html
I am sure many of you already are aware of this, but I ran across a bit of an issue this week with what I thought should be a simple deployment of a SmartList Builder item. Here are the steps I went through....
- Created two views in SQL based on a combination of GP and custom tables
- Granted access to the views for SmartList Builder, Tools>>SmartList Builder>>Security>>SQL Table Security
- Created my Smartlist, Tools>>Smartlist Builder>>Smartlist Builder
- Tested by Smartlist, all looked…
Posted by
Dynamics GP Security Smart lists
http://waqasb.blogspot.com/2010/04/dynamics-gp-security-smart-lists.html
Most of our clients wanted to review their Dynamics GP security setting using smart list, so we have setup some smart list’s using smart list builder. Here is the list
Sr. | Smart List Name |
1 | Batch Activity |
2 | Security… |
Posted by
Making a copy of a Builder SmartList
http://gpbuilders.wordpress.com/2010/07/21/making-a-copy-of-a-builder-smartlist/
This is so easy – you are going to say “DUH” but people seem to constantly be searching…
Posted by
Distribution Tables – adding the GL accounts to Builder Lists
http://gpbuilders.wordpress.com/2010/08/05/distribution-tables-adding-the-gl-accounts-to-builder-lists/
As Part two of my response to a question on my Suggestions Page, I thought I would discuss the…
Posted by
Adding Internet Information (Email addresses) to Lists in SmartList Builder, etc
http://gpbuilders.wordpress.com/2010/08/06/adding-internet-information-to-lists-in-smartlist-builder-etc/
There are certain tables that you really should not link directly to in the Builders. Internet…
Posted by
Matched Tables – Viewing Open & History Documents on the same SmartList in Builder (just like the default Lists!)
http://gpbuilders.wordpress.com/2010/08/09/matched-tables-viewing-open-history-documents-on-the-same-smartlist-in-builder-just-like-the-default-lists/
One of the features of the default Lists in SmartList, Excel Reports & Navigation Lists is…
Posted by
Smartlist Builder Field Comparison Value changes erroneously
http://janakirammp.blogspot.com/2009/08/smartlist-builder-field-comparison.html
A Forum member posted a query in Dynamics GP partner Forums today that when she is trying to use Field Comparison in Search Criteria for a smartlist built using Smartlist Builder throws an invalid value in the value field. I was quick to test the scenario on my system. I’m able to exactly recreate her scenario. Here in the below image, the value field is shown as “Are you sure you want to delete this order ID?”. However this was not the value that I gave in the field. My criteria was to search for records where Current Transaction amount is not equal to…
Latest links
- Microsoft Dynamics GP on Windows Azure! – Inside Microsoft Dynamics GP
- Edit List vs. Batch List Reports in GP | onza blog
- Could not e-mail status report to sender. Insufficient Memory in Dynamics GP
- How to Setup Security for a New SmartList | Dynamics University
- Dynamics GP 2013 Upgrade: Are you still using converted security roles in your GP security?
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Microsoft Dynamics CRM Partner Training Blitz Day – July 31 – Register Today!
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.