Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Batch Posting fails

Posted on by Microsoft Employee

   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:
  • 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
    Richard Wheeler 75,730 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
    Community Member Microsoft Employee 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
    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans