1,065
One of my user's is receiving this error below when she goes into GP - Tool - Routines - Purchasing - Print 1099.
" You can't complete this process while 1099's are being printed or calculated"
Thanks for you help !
*This post is locked for comments
Thanks koep, that's what I thought but I couldn't confirm no one should be printing the 1099's accept for one user and she's the one not able to print
This is likely the result of a stuck activity record in the Dynamics Activity or Dynamics Dex_Lock table where another user was using the Print 1099 window. I would have all users log out and see if this resolves the error. Otherwise continue with the steps below to clear the record through SQL:
1. Please make sure that you have a restorable back up.
2. Have all users log out of Great Plains.
3. Launch SQL Query Analyzer and run the following statements:
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
4. Verify if the issue persists.
Hope this was helpful,
Kelsey Koep
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
