2,395
Hi all, I have a user than only in 1 company (of 3 we have setup) can't post a batch from a match invoice transaction, every time he tries to post it just stays there with the windows showing a 100% progress, I've checked his permissons and everything seems fine, I repeat this only happens to this user on 1 company only.
Any ideas on why could this be happening?
Regards.
*This post is locked for comments
I will double check permissions for this user, but i'm positive they are correct, but it doesn't harm to check again, will keep you informed.
Alvaro, I had a very similar problem and it ended up being related to posting permissions.
Hi, yes, permissions are the same for all the companies, when this first happenes I checked his permissions thinking that this could be the case, but no.
Thanks
May not be the case.... but are his permissions similar to other companies. May be set him as a Power user or similar to you temporarily and see if it posts.
I have a similar script that I run about every week, so this can't be the problem, I will try SQL Profiler and let you know.
Thanks again
Hola,
If this problem only happens for the same user in the same company, it makes me think that the problem could be related to DEX_SESSION and DEX_LOCK. There is not harm to trying the script from the link I sent you.
As Mahmoud mentioned, I would also try SQL profiler.
Thanks
Try to limit down the lines of code on the profiler which could be causing the posting to get stuck in some sort of infinite loop
Looking forward to hearing from you,
Hi Mahmoud, I'm not sure about that he is printing the edit list, I will try it next time he tries to post.
- Yes this happens all the time with the same kind of transaction (match POP invoice)
- It has happend even after a PC restart. The transaction doesn't post, the batch is stucked and then I have to release it and then I post it my self.
I will do the sql profiler and post the result, unfortunatelly, this company doesn't have that many transactions.
Will keep you informed, thanks again.
Hi Jorge, thanks for your reply, I do know how to realease a stuck batch, my question is why this user can't post on this company, and only with batches created for a match invoice transaction.
Hello Alvaro
Hope you are doing just well
Initially, I would definitely look for the root cause of the problem in order to be settled and resolved completely, this requires few tools to provide you with the sufficient details about what's occurring on the back-end.
- First of all, have you tried to print the edit list report before posting to check whether there is any specific trend or error message ?
- Secondly, does this happen (all the time), or there are special cases at which posting would proceed successfully ?
-Furthermore, if it happens all the time, do you usually consider closing Dynamics GP through end task ? In this essence, what are the details related to the shipment and its enter match invoice ? Is it fully posted or there are incorrect data there in the POP module ?
- If all of the above is true, you do need to proceed and check what's happening by turning on the SQL profiler and filtering by this specific user, and provide any sufficient information for us to be able to provide valuable assistance,
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
