Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Performance issues when creating/editing Purchase Orders in GP 2010

(0) ShareShare
ReportReport
Posted on by

Good Morning,

I am wondering if anyone could provide some advice into an issue one of my clients is experiencing with regards to Purchase Order Processing in GP 2010.  When an order is raised that consists of numerous lines (the reported case we have is 119 lines) there is a noticeable decrease in performance as each line is created where it is taking time for each field to become available to enter information into.  The same performance issue has also been noticed when editing individual lines. 

From what I understand, GP is recalculating the whole order as each line is being edited, am I correct in thinking this?

The client themselves have offices around the country, each with their own separate GP company stored on the same SQL server.  Some offices are fine however most have this issue.  I initially thought that this may have something to do with the database size however after checking the size for one of the offices it is showing as 2.3GB which is one of the smallest compared to some of the other offices.

I have been unable to find any information online with regards to this issue specific to GP.

Can anyone provide any advice or has anyone experienced this before?

Many Thanks

Kevin 

*This post is locked for comments

  • Syrus Profile Picture
    4,156 on at
    RE: Performance issues when creating/editing Purchase Orders in GP 2010

    119 lines, amazing. also if it is a remote office connecting to SQL DB then the connectivity quality, size of the internet/vpn tunnel and then how SQL is being handled like prioritizing the application to have dedicated bandwidth etc.

    Also, the sizes and growth of SQL mdf, ldf files and memory management, Disk space and some fine tuning practices to analyze and load balance of Server and Applications

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans