Identifying where SmartList Column Data comes from


David Meego - Click for blog homepageThis 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?”

Continue reading

Microsoft Dynamics GP 2013 SmartList Export to Excel shows currency values with 5 decimal places


David Meego - Click for blog homepageThis 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.

Continue reading

Why does SmartList not return all of the expected data for large queries?


David Meego - Click for blog homepageThis 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.

Continue reading

Microsoft Office Click-to-Run and Microsoft Dynamics GP


David Meego - Click for blog homepageThis 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.

Continue reading