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

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) / GP Desktop Client take...
Microsoft Dynamics GP (Archived)

GP Desktop Client take really long time to generate report

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

We have our GP Server in Microsoft cloud. When we use GP Desktop Client to run the report, it takes really long time to generate a simple report (30 minutes for 162 page report). When we run the same report in GP Terminal Server, it takes 2-3 minutes. We have verified that firewall settings are correct and network packets are not getting lost.

We are using GP2016. Any help which we can get will be greatly appreciated.

Thanks,

*This post is locked for comments

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

    HI,

    Are you saying that your run a full local GP client connected towards a GP server that is hosted in the cloud ? Uhm... what's the speed of your internet connexion ?

    That would be like wanting to have a remote user from home thru the 10Mbps line trying to work with GP in your office... very likely to get him/her pissed off quickly. This is not a recommended configuration.. In order to run GP smoothly in a server/client configuration, your network needs to provide at least 100Mbps thruput.. better 1Gbps. Anything bellow that should only be running thru a TS or Web client.

  • Community Member Profile Picture
    Community Member on at

    Hello,

    We have 200 Mbps and it has been verified that bandwidth is not the issue. Packets are also not getting dropped between corporate office and Azure. We have 100 Mbps thruput  but reporting really lags.

    Thanks,

    Akshay

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Not trying to put words in Beat's mouth here - but what I think he was driving at is that every time the desktop system accesses the server that takes some time, with a report as I recall everything has to 'return' to client before it continues.

    One suggestion might be to put a 'process server' out there to off load the work from the client and thereby free it up to continue working on daily tasks.

    Let us know if anything changes.

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

    Agree with Bill,

    The Process server would take all the load and then you could deliver the report to the end-user..  Try that or if it doesn't help you'll to run a network analyzer and/or SQL trace to find out why it takes so much time to generate the report..

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans