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 :
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

I have the same question (0)
  • Syrus Profile Picture
    4,156 on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans