Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory recalculation pause and resume taking too long to finish

(0) ShareShare
ReportReport
Posted on by 40

Hello all,

We usually do a month end inventory close where we run the re-calculation first in batch. This process has been successful except for March. 

to begin with:

What was done

We ran the recalculation in batch mode for March . Batch job executed at 6pm and stayed in that status until 12 am, (average time to complete is approximately 4 hours),  so the decision was made to cancel the the batch, pause and resume the recalculation process from the Close and Adjustment form. This change is taking forever to complete.

Question

Any suggestions what steps to take next, so that the recalculation process completes and month end close can be done?

Extra batch helpers = 6

Number of items per bundle = 40

Items being managed = 400

Thank you in advance.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at
    RE: Inventory recalculation pause and resume taking too long to finish

    Hi Usman786,

    As you did "kill" a running batch job without knowing the impact, I don't know how to start helping here. I haven't done this before and would for sure not recommend this approach. Next time, first check the SQL activity monitor if there are long running queries and/or blocks.

    Can you share the screenshot of the inventory closing with the current status on the latest close job?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory recalculation pause and resume taking too long to finish

    Hello usman786,

    Before trying / testing something else I would suggest that you get a developer and/or the MS support involved.

    Trying to resume, stop, etc. might not help and probably make things even worse especially if things worked fine over the last couple of months.

    Best regards,

    Ludwig

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans