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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / workflow error in pend...
Finance | Project Operations, Human Resources, ...
Suggested Answer

workflow error in pending vendor invoice

(0) ShareShare
ReportReport
Posted on by @rp@n 30

hi All,

I am getting below error while doing workflow Pending vendor invoice workflow

Stopped (error): INSERT INTO tempdb."DBO".t101281_281FB11880864105A716B017FCA50EBC (ISFINAL,TYPEENUMNAME,TYPEENUMVALUE,STATUS,SOURCEDOCUMENTHEADER,PARENTSOURCEDOCUMENTLINE,SOURCERELATIONTYPE,EXCHANGERATEDATE,SOURCEDOCUMENTLINE,ACCOUNTINGDATE,RECVERSION,PARTITION) SELECT T1

Here 10281 is table id for SourceDocumentLineTmpJournalize

I have done the DB Sync, but still getting this error

1016.A1.jpg

5810.A2.jpg

Why this error is coming?

Please let me know how will resolve this issue ?

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    What has been modified in regards to the pending vendor invoice and/or the workflow?

    Best regards,

    Ludwig

  • @rp@n Profile Picture
    @rp@n 30 on at

    Ludwig,This is happened for few invoices only.

    If suppose something modification done then it will impact for all invoices.

    am i right?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Well, it depends on what kind of modification has been done.

    Can you kind of classify the invoices that cause the problem? Are they linked to the same vendor, vendor group, etc.?

  • @rp@n Profile Picture
    @rp@n 30 on at

    Ludwig,

    I am not sure about customization happend or not.

    But I can check those invoices whether having same vendor or vendor group .

    Let you know.

    Is this issue related to vendor or vendor group?

    Kindly let me know how to resolve this?

  • Suggested answer
    TracyXing Profile Picture
    TracyXing on at

    Have you tried to resume the workflow when this error happen?  Could you please try resume to check if issue persist.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans