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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (