Update 1099 Information transactions being edited

(0) Share

Report

Posted on by Richard Wheeler

75,850 Moderator

User is trying to run the process under Tools->Utilities->Purchasing->Update 1099 Information but get 'You cannot run this process while transactions are being edited' How do I clear this? Run the usual clear activity script or do certain batches need to be posted?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Hokuminaria 2,950 on at

Like (0)

Report
Hey Richard,

I think the easiest approach is to clear the activity tables for this message. This will make sure that no one is editing it.

Have all users logout.

Run the select statements below.

SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION

No results should be returned if no one is logged in.

If results returned, delete the stuck records using the deletes below.

DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION

Test if the issue still occurs.

I hope this helps!

Thank you!

Brandon Jarrett | Microsoft Support Engineer

Was this reply helpful? Yes No