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 / 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 56

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 56 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 56 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 Microsoft Employee 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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 613

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 292 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans