Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Project tax invoice pr...
Finance forum
Suggested answer

Project tax invoice proposal 'stuck' in Submitted status

Posted on by 5

We have Dynamics 365 Finance and Operations v10.0.39. We use workflows to gain approval for project tax invoice proposals.

Several of those workflows have become unrecoverable, with the following message: "Stopped (unrecoverable): Cannot select a record in SysWorkflowTable (SysWorkflowTable). Correlation ID: {00000000-0000-0000-0000-000000000000}, {00000000-0000-0000-0000-000000000000}.Deadlock, where one or more users have simultaneously locked the whole table or part of it."

This issue has only recently started, and only affects a small sample of our project tax invoice proposals.

We have then cancelled the workflow, but the result is the invoice proposal is not able to be edited or deleted - it is completely stuck with the status Submitted (see screenshots).

  

The transaction lines attached to these proposals are now also stuck and we are not able to invoice our Customers, so this has a cash flow impact.

Any help would be much appreciated! 

Categories:
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Project tax invoice proposal 'stuck' in Submitted status
    Hi, I have not met such error before. I think you can report to Microsoft for further investigation.
    And I have searched some helpful links regarding the same question:

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans