AP Payment Entry - Existent group is locked by another user

Epicor ERP 10
1

Hi,
We have an AP Payment Entry which we cannot access as it is locked by another user. Even when I asked that user to open it, she cannot access it as it gives the same message.

Any suggestions how to clear this other than restarting the App Pool??

Thanks.

1 Like
2

Restarting the App Pool probably wouldn’t sort it, as it’s stored in a DB field:

select *
from erp.APChkGrp
Where GroupID = ‘YOUR_AFFECTED_GROUP’

You should be able to create an updateable BAQ to amend the ActiveUserID field to ‘’

2 Likes
3

Thanks Mark. We seem to get this issue every month or so. Any idea why??

4

Is it because the user is crashing out of Epicor whilst they have the AP Payment Entry screen open? I don’t normally have the locked issue with AP Payment Groups, but do sometimes with AP Invoice Entry groups - path of least resistance is to get the same user to open the group - it should check the ActiveUserID on the group against the user attempting to open it, and realise it’s the same user.

5

Hey Guys,
You can also call this method on the APInvGrp BO to unlock the group:
image

Works great!

We have this issue occasionally too. I’m thinking I should call this method on a form close event in a customization to see if it alleviates this issue

2 Likes
6

@jgehling - that’s a great idea!! We too have this problem regularly.

7

This did the trick for AR

SELECT        Erp.InvcGrp.*
FROM            Erp.InvcGrp
WHERE ActiveUserID = 'AFFECTED USER'
UPDATE Erp.InvcGrp Set ActiveUserID = '' WHERE ActiveUserID = 'AFFECTED USER'