This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
A customer ran across an interesting issue with Excel Based Budgeting after they upgraded to GP 2013.
Smartlist
Identifying where SmartList Column Data comes from
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?”
Microsoft Dynamics GP 2013 SmartList Export to Excel shows currency values with 5 decimal places
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This topic has been in my drafts list for ages after it was mentioned in this partner forum thread: Decimal places in GP2013 – SmartList to Excel. However, I did not want to write it up until I could offer some solutions for it at the same time.
Why does SmartList not return all of the expected data for large queries?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Here is another support issue that you might come across.
I just closed a case where a SmartList was returning less than the expected number of records. If a SQL Statement was executed via the SQL Server Management Studio, it returned more records than were shown in the SmartList.
SmartList not working properly, Search window does not display correctly
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Yesterday, I had a support case come in where the customer was complaining that SmartList was not working properly and that the Search window was not being displayed correctly.
Changing the Phone Number Format
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
One of the most common customisations outside of North America is changing the Phone Number Format. The North American default format of (XXX) XXX-XXXX Ext. XXXX is not always suitable for other countries.
Microsoft Office Click-to-Run and Microsoft Dynamics GP
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I recently had a support case where the customer was receiving the error “Unable to start Microsoft Excel.” from Microsoft Dynamics GP when trying to export from SmartList to Microsoft Office Excel.
SmartList Builder based on SQL View not returning data
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have yet another interesting case to discuss with you. The partner had created a set of views into the SQL data with the final view being displayed as a SmartList after being added using SmartList Builder. This post is not going to cover how to use SmartList or SmartList Builder, but instead focus on the problem we were seeing.
Smartlist: Exports slowly to Excel – Part 2
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
This is the 4th post in a series of Smartlist posts in the last weeks. In these articles, I’ve given answers and solutions to common questions about Smartlist that are typically of the “Why doesn’t Smartlist..?” variety.
Last week, the question we were looking at was:
Smartlist: Exports slowly to Excel – Part 1
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
In the last few weeks (here and here), I’ve enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups. These questions are typically of the “Why doesn’t Smartlist..?” variety.
In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.
Smartlist: Splitter control in Smartlist window doesn’t work
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
Last week, I enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups. These questions are typically of the “Why doesn’t Smartlist..?” variety.
In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.
Smartlist: Only the data area should grow
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
I’ve seen several questions over the years on Smartlist of the “Why doesn’t it?” variety such as:
Winthrop Development Consultants Blog 