web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smartlist Report Expor...
Microsoft Dynamics GP (Archived)

Smartlist Report Export to Excel Limit

(0) ShareShare
ReportReport
Posted on by Community Member

I was trying to export to excel a Smartlist Report with about 100K rows and 15 columns but GP is not doing anything. It seems to work with 10K records.

Our excel version is 2010. Our MS Dynamics GP 2013 has version 12.00.1801. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Never mind, I already found the solution for this issue. I just had to change the limit in the Excel Options.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Emerald,

    I was wondering why you couldn't create an Excel report that would pull the data directly out of GP.. ? especially if this is going to be a repeated action, you're going to find it borring to wait for SmartList to export 100k records... not the speediest way of doing it.

    The same process directly out of Excel to refresh 100k lines takes less than 30 seconds.. Depending on you GP version, you could use Excel report builder to create one of those refreshable reports.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans