In Touch with Dynamics GP

This blog is intended to be a useful resource for Microsoft Dynamics GP users and professionals in the UK and the wider Microsoft Dynamics GP community as a whole.

Wednesday, 8 May 2013

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.
Posted by at
Labels: , ,

8 comments:

  1. Unknown11 September 2013 at 22:38

    Andy, thanks for the consise summary on this issue. Do you happen to know if they corrected on the recent rollout of SP2?

    ReplyDelete
    Replies
    1. Anonymous19 December 2013 at 14:26

      Hi,

      Anyone know if it has been fixed?

      Thanks

      Delete
  2. jeanmarieb22 December 2013 at 19:08

    I test it with the gp2013SP2 and i was able to export more than 70,000 line in excel

    ReplyDelete
  3. Unknown17 January 2014 at 21:47

    Confirmed to be fixed in SP2. It's in the SP2 fix list available on partnersource/customersource

    ReplyDelete
  4. Andy Hall20 January 2014 at 09:14

    Thanks for the update Lance

    ReplyDelete
  5. computerteach7 May 2014 at 13:59

    Thanks for sharing your experience with us.This will really help the community to be awared and maybe save some people from serious head scratching.The issue is, when exporting to Microsoft excel from Dynamics GP 2013 smartlists it was crashing out when reaching row 32766.

    ReplyDelete
  6. juanjuergens10 June 2017 at 08:53

    This comment has been removed by a blog administrator.

    ReplyDelete
  7. Charlie26 August 2023 at 08:18

    Exporting data to Excel from a specific source often comes with limitations on the maximum number of rows. How Play PUBG Familiarize yourself with these limitations to avoid incomplete data transfers. Prioritize data relevance and use filtering techniques to optimize export while staying within Excel's row limits for seamless analysis.

    ReplyDelete

Subscribe to: Post Comments (Atom)