Dynamics GP 18.5 Workflows Take a Long Time to Submit

(1) Share

Report

Posted on by Cayman Port

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)

All responses (4)

Answers (0)

Sort by

Vahid Ghafarpour 12,262 on at

Like (1)

Report
Copy link

Link copied!

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

https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/workflow-2-0-tables-used-with-microsoft-dynamics-gp

Was this reply helpful? Yes No
Cayman Port 7 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
CU-13072009-5 13 on at

Like (0)

Report
Copy link

Link copied!

Hi, we are having same issues after migrating SQL server to a new server. Were you able to figure out the issue? Thanks.

Was this reply helpful? Yes No
olegvi 811 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Dynamics GP 18.5 Workflows Take a Long Time to Submit

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Dynamics GP 18.5 Workflows Take a Long Time to Submit

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates