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.
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.
Was this reply helpful?YesNo
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.