News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Closing Inventory Year...

Dynamics 365 general forum

Closing Inventory Year msg - Cannot complete this process while invoices are being posted.

(0) Share

Report

Report

Posted on by DEBBIE WRIGHT

20

Using Microsoft Small Business Financials

Inventory

Utilities

Close Inventory Year

Message: You cannot complete this process while invoices are being posted.

We cannot find any invoices that have not posted. What should we do?

361.575.6886 Debbie

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Closing Inventory Year msg - Cannot complete this process while invoices are being posted.

Hi Debbie,

Here is a good link regarding you issue. jpdavey.blogspot.com/.../clearing-locked-dynamics-gp-batches.html

- Make a backup first of the DYNAMICS and company databases

- You can run the above mentioned script but the important part is

-- MAKE SURE EVERYONE IS OUT OF THE SYSTEM before you run this:

DELETE FROM DYNAMICS..SY00800

DELETE FROM DYNAMICS..SY00801

DELETE FROM DYNAMICS..ACTIVITY

DELETE FROM tempdb..DEX_LOCK

DELETE FROM tempdb..DEX_SESSION

--- View the contents of the above tables

SELECT * FROM DYNAMICS..Activity

SELECT * FROM tempdb..DEX_SESSION

SELECT * FROM tempdb..DEX_LOCK

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

Thomas

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans