Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
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
  • 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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans