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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Purchase Orders Preview takes too long

(0) ShareShare
ReportReport
Posted on by 36

Hello we we have been having some performance issues running the Purchase order preview, it used to take a minute or 2 then it started taking 30 min.

today it seems it is taking longer

the only way to make it work quick was to clean the SOP10200 for non inventory Items, but today does not seem to make any difference.

any ideas

thanks

Categories:
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Microsoft Employee on at

    I'd be curious if you put (or already have) Dynamics GP on the SQL Server itself, is this PO preview faster or still taking close to 30 minutes?

    If it is faster, than that would point to some type of networking issue between the original GP machines and SQL Server.

    If not any faster, a dexsql.log recreating this performance issue is what we would generally look at next, so we can see what calls are causing it to take 30 minutes, then focus on those as to why.

    Ideally, we'd want to get the dexsql.log without all other users logged into the GP instance we're running the log from, that way we only capture information specific to the PO Preview.

    I'd start with that and go from there.

    Thanks

  • rdawood Profile Picture
    2 on at
    Was there ever a solution to this?  We are having the exact same issue.  Any help would be greatly appreciated.  

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 Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 428

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans