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?
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 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
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.
No Errors in both Edit List and even while posting but still unable to POST some particular Invoices
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156