32766 maximum row export to excel from smartlists in Dynamics GP2013

Hi Folks

This issue was causing us some concern and we could not find any reference to it on any forum or partnersource so now we have an answer, I thought I would put it on the blog so the rest of the community was aware and maybe save some people some serious head scratching.

The issue is this, when exporting to excel from Dynamics GP 2013 smartlists it was crashing out when reaching row 32766.

All the DEX developers out there are now going “oh , Oh , 32766, that’s the maximum integer value in Dex” and you would be right. Here in lies the problem, the smartlist code in Dynamics GP2013 has been rewritten to speed it up. It used to do it line by line but it is now casting to an integer.

The folks at Microsoft Dynamics GP Technical Support have been great helping us with this (thanks folks you're all stars) and it has now been written up as a change request and sent to development.

I’ll update the blog when we get a date, however in the mean time you just need to be aware this limitation exists.

Quick Excel Tip to roll down formulas in Dynamics GP excel reports

I don’t know about you folks but it used to seriously frustrate me when you got a data set out of Dynamics GP into an excel report, created lots of funky formulas in your columns, then refreshed your data and got extra rows returned and your formulas did not copy down.


With the advent of the excel based reporting and other dynamically updating excel reports in Dynamics GP you come across this more and more.



Well there is a simple tick box in excel which will solve all your problems.

Goto the DATA tab on the tool ribbon in excel.

On the connections section next to the refresh All option you should have connections and under that properties.

Now properties may be greyed out., if it is click your cursor into one of the cells on the report which contains returned data. Properties should now be enabled.

Select properties and this should open the external Data Range Properties Window.

At the bottom of this is a tick box for “Fill down formulas in columns adjacent to data”

Tick this box.



Now when you refresh your data if extra rows are returned your formulas will automatically copy down.