Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Ax 2012 warehouse on-hand entries cleanup

Posted on by 90

Hello,

I have questions regarding Warehouse management on-hand entries cleanup.

1. How is it supposed to look? When I ran it first time it showed the standard Microsoft AX processing pop-up in the bottom-right corner, and then program stopped responding. Is this how it is supposed to be?

2. I left it running and came back the next day, but It still wasn't finished, so I closed the program, now when i try to go into on-hand entries they won't load, basically the same thing happens as if I ran the warehouse on-hand entries cleanup, is it possible i corrupted the table, by closing it, or is it good behavior and it's just running the clean-up?

3. Is it possible to check the progress of this process?

  • EmilP Profile Picture
    EmilP 90 on at
    RE: Ax 2012 warehouse on-hand entries cleanup

    Hi André, thanks for Your response I did restart the SQL and AOS services and the on hand inventory is now working as it should be. I did not check if it was still running or not, but i suppose It actually ended, because there are no blank entries when i go to on-hand inventory now. I don't know if It was some kind of bug or maybe a blocking SQL statement as You said, all I know is that it's okay now, once again thanks for Your answer!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Ax 2012 warehouse on-hand entries cleanup

    Hi EmilP,

    When you closed the client, then the SQL statement might still run in the background on the SQL server. It will cause database blocks which indeed can cause your current issue. I would suggest to see if you can find a blocking SQL statement on the SQL server and see if this is deleting on-hand entries (InventSum). If so, you can kill this process. Another option is to restart the SQL service and AOS services.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans