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 / Customer experience | Sales, Customer Insights,... / Dynamics GP 18.5 Workf...
Customer experience | Sales, Customer Insights,...
Unanswered

Dynamics GP 18.5 Workflows Take a Long Time to Submit

(1) ShareShare
ReportReport
Posted on by Cayman Port 7
We have Dynamics GP 18.5 and have enabled workflows for POs, vendor approval, payment batches, and GL batches.  In the last few months, the workflow submit function can sometimes take 30-40 seconds to complete.  The comment window will pop-up and then when you hit submit it just sits there for a long time before finally completing.  I am wondering if one of the workflow tables is getting really big or something but I don't see any workflow related cleanup/purge functions?  Anyone have any ideas what to look for?
I have the same question (2)
  • Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 12,228 Super User 2026 Season 1 on at
    Ensure that the workflow tables are not excessively large. You can run a query on tables like WF100002, WF100003, WF30100, and WFI10002 to check for any unusually large data
     
  • Cayman Port Profile Picture
    Cayman Port 7 on at
    Thanks but what is "excessively large"?  I have the following 4 WF tables in one of our company DBs:
     
    Table            Records
    WFI10002    13494
    WFI10003    26832
    WFI10004    11251
    WFI10005    0
     
    The bigger question is what do I do to fix the problem?  How do I archive or purge the older completed workflows?
  • CU-13072009-5 Profile Picture
    CU-13072009-5 13 on at
    Hi, we are having same issues after migrating SQL server to a new server. Were you able to figure out the issue? Thanks.
  • olegvi Profile Picture
    olegvi 811 on at
    Hi, same issue here. We just upgraded to 18.7 and the workflow is slow. It takes about a minute for the approval request to go through. 
    Can this be optimized?
     
    Thank you.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 180 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 123

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans