News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Inventory recalculatio...

Finance | Project Operations, Human Resources, ...

Suggested answer

Inventory recalculation pause and resume taking too long to finish

(0) Share

Report

Report

Posted on by usman786

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

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

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans