Microsoft Dynamics GP (Archived)

How can an RMA marked for receiving by another user be unlocked?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Dan Liebl 7,320 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ian thanks so much for your response I will go through the process above and post and update.

Thanks again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dan Thank you as well.....

Was this reply helpful? Yes No
davidf. on at

Like (0)

Report

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'

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No