Announcements
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 635 Super User 2026 Season 1
André Arnaud de Cal... 595 Super User 2026 Season 1
Giorgio Bonacorsi 557