Finance | Project Operations, Human Resources, ...

Inventory recalculation pause and resume taking too long to finish

(1) Share

Report

Posted on by usman786

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.

I have the same question (2)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
KO-16011120-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

We are experiencing the same issue. Earlier, recalculation has been fast, while now it has run in over 24 hours. We had to reverse a closing and some other recalculations, and after that the batch job is just stuck in executing state.

Did you find a solution to your problem?

Thank you.

Was this reply helpful? Yes No