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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

When You Aren't Allowed to Run Inventory Reconcile

(1) ShareShare
ReportReport
Posted on by 4,005
Hi:
 
If there are users in the live Dynamics GP company or if there are "stuck" inventory records anywhere in the company, GP will not let you run Inventory Reconcile.
 
You receive a message saying that the process cannot be run while invoices are being posted, even though they're not.
 
There's a series of T-SQL scripts that you can run to eliminate this error and be allowed to run Reconcile, after asking users to be out of GP.
 
Are these the scripts?
 
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
 
John
Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,154 Super User 2026 Season 1 on at
    Yes, those are the scripts to run to clear activity tables once users are out of GP ... Specifically, DYNAMICS..SY00800 is the table that is most likely generating the message.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 564 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 503 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 421

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans