Skip to main content

Notifications

Announcements

No record found.

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,776 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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans