1,970
We are on GP 2010. I'm trying to transfer an order to invoice and I receive the error message: You can't transfer documents to a batch that's being transferred by a coworker. I've run check links and continue to get the message. Also, I've tried changing the batch id and that doesn't seem to work either. No one else is in GP so I know that no one else is transferring the batch. Does anyone know how to fix this?
Thank you!
*This post is locked for comments
[quote user="Sharon Burley"]
I found that if i turned off our sales tax calculation software, AvaTax, I was able to transfer the order to invoice after running check links. I'm not sure why AvaTax was causing an issue but after I transferred the document, I turned it back on and calculated the tax afterwards without any problem. mobdro
[/quote]
Thanks for suggestion...
This message appeared trying to transfer Quote to Sales order. To work around it we changed the batch the Quote was in to a new batch. This worked allowing the transfer.
Unfortunately there was no time on this occasion to investigate it further, I expect clearing activity from the various activity tables would also have worked.
I found that if i turned off our sales tax calculation software, AvaTax, I was able to transfer the order to invoice after running check links. I'm not sure why AvaTax was causing an issue but after I transferred the document, I turned it back on and calculated the tax afterwards without any problem.
thanks so much for the response. i checked SY00500 and the batch status is 0, however i went ahead and ran both scripts and then tried again and GP now unchecks the include totals and deposits box. any other suggestions? This order has a deposit on it and I was getting the problem with the include totals and deposits unchecking itself yesterday and that's why I ran the check links initially. It seems I either get an error that a coworker is transferring to the same batch or the totals and deposits box unchecks itself. What is also strange is that I'm able to run check links and transfer without error in our test company. I'm not sure what is different in our production company that would cause this. Any other ideas?
Thanks!!
Sharon
Hi,
If you look in the SY00500, what is the status of the batches? Also, when there is nobody (not even you) in Dynamics, run the following:
First BACK UP YOUR DATABASES and then
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
Then use this script to update the status of a particular batch:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='your batch ID'
Kind regards,
Leslie
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
