Notifications
Announcements
No record found.
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?
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
No Errors in both Edit List and even while posting but still unable to POST some particular Invoices
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.
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,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader