web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Update 1099 Informatio...
Finance | Project Operations, Human Resources, ...
Suggested answer

Update 1099 Information transactions being edited

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 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)
  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Update 1099 Information transactions being edited

    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.

    1. Have all users logout.
    2. 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

      1. No results should be returned if no one is logged in.
    3. 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
    4. Test if the issue still occurs.

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 783

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 715 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans