You’re offline. This is a read only version of the page.
Have not seen many inquires about the following.
Is it possible for an RMA marked for receiving by another user be unlocked?
We have a former user with a firm grip in an RMA.....
Any input is appreciated.
Thx
*This post is locked for comments
After using all the suggestions below:
•SELECT * FROM DYNAMICS..ACTIVITY
•SELECT * FROM DYNAMICS..SY00800
•SELECT * FROM DYNAMICS..SY00801
•SELECT * FROM TEMPDB..DEX_LOCK
•SELECT * FROM TEMPDB..DEX_SESSION
•select * from SVC00205
•select * from SVC00640
If you get results for any of the above - run the following:
•DELETE DYNAMICS..ACTIVITY
•DELETE DYNAMICS..SY00800
•DELETE DYNAMICS..SY00801
•DELETE TEMPDB..DEX_LOCK
•DELETE TEMPDB..DEX_SESSION
•DELETE SVC00205
•DELETE SVC00640
This what solved the problem:
•select * from svc05015
•delete svc05015
Thanks to all for your help
Robert,
Dan has you going in the right direction on this. The SVC00205 table is the SVC_Service_MSTR_Line_Access table. Instead of doing a "DELETE * " on it, I would first run a select query and see exactly which RMA documents are locked.
This can happen fairly often if users close out improperly while they have an RMA open. Sometimes you can find out who has the record locked, have them open that RMA and save it, which will then remove the lock safely.
Contracts can also end up in a locked status sometimes. That table is SVC00640.
What I did was create a .sql file called " clear locked RMA or CONTRACT.sql ". That way when I need to clear a locked RMA or Contract I open the file in SSMS, Change the restriction as needed and then run the DELETE query with the correct restrictions.
---------------sql query ---------------
/*
/** For locked RMA **/
select * from
----delete
SVC00205
where SVC_Document_Number = 'RMA000000004xxx'
/** For locked Contract **/
select * from
----delete
SVC00640
where CONTNBR = '0000099999'
Dan Thank you as well.....
Ian thanks so much for your response I will go through the process above and post and update.
Thanks again.
You could also check the SVC00205 table. It holds Field Service activities. Just as you need to run the queries Ian suggested, get all users out of GP and run against the company database:
Delete * from SVC00205
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
I would first attempt the usual procedures for a stuck batch. Get all users out of GP and run the following queries in SQL. Itts always advisable to back up the DYNAMICS and Company database before you run any queries.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
If you get results for any of the above - run the following:
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
This should clear up any issues where users crashed out of GP during transaction entry / receiving etc.
Try and receive the RMA again.
Ian.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (