Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Batch Posting fails

(0) ShareShare
ReportReport
Posted on by

   I don't see any Error in Sales Invoices but still I am unable to Post it. Does Any one knows what does it happen?

Categories:
  • Angela Eckman Ebensteiner Profile Picture
    1,216 on at
    RE: Batch Posting fails

    Hi Richard,

    I agree with you.  I think there might be something stuck in the tables.  And if there isn't, then it would be best for one of us at Microsoft to help investigate it.  We could start by looking at the actual SO invoice data in the backend to see if there is an issue with the actual data.  If nothing shows up, then we could look at creating dexsql.logs and sql traces to investigate.  

    Thanks,

    Angela Ebensteiner

    Microsoft

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Batch Posting fails

    Have you tried the tips in the KB about batch stuck in posting?

    The first thing to try is to make sure these table are empty when no one is jn GP:

    DYNAMICS..ACTIVITY

    DYNAMICS..SY00800

    DYNAMICS..SY00801

    TEMPDB..DEX_LOCK

    TEMPDB_DEX_SESSION.

    If this fails to resolve the issue try stopping/starting the SQL services or rebooting the server. There may be some phantom locks on tables. If the problem persists open a support case with Microsoft.

  • Community Member Profile Picture
    on at
    RE: Batch Posting fails

    No Errors in both Edit List and even while posting but still unable to POST some particular Invoices

  • Suggested answer
    Angela Eckman Ebensteiner Profile Picture
    1,216 on at
    RE: Batch Posting fails

    Hi,

    When you say you don't see any errors, are you saying you don't see any errors on the Edit list or during the actual posting process?   If you haven't tried to print the edit list, try that first.  Typically, if there is an issue with one of the transactions or the batch, the edit list shows what it is.  

    Thank you for using Microsoft Dynamics Communities,

    Angela Ebensteiner

    Sr Technical Advisor

    Microsoft

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans