Supply chain | Supply Chain Management, Commerce

Dynamic 365 F&O slow in generate counting journal

(1) Share

Report

Posted on by KT-14050752-0

When create on-hand counting journal that select warehouse and batch number = Yes

And filter item-group and warehouse to locate item in specificed warehouse.

In the first year it take about 20-40 minute to fished create journal.

but after 3 year had pass it take about 1.30 - 2.00 hours to complete. (about 200 data lines)

The problem maybe the data(Batch number) is more bigger fromthe start.

Does anyone had a solution to reduce the create time?

I run batch job 'Inventory dimensions cleanup' and 'On-hand entries cleanup' and it still take a long time to create.

Categories:

Dynamics 365 Supply Chain Management

Data counting.JPG

I have the same question (0)

All responses (5)

Answers (0)

Jonas "Jones" Melgaard 4,894 Super User 2025 Season 2 on at

Like (1)

Report

Dynamic 365 F&O slow in generate counting journal

The InventDim clean-up routines only work if no transactions uses them.

I wonder if it's function of the amount of transactions you have generated - I.e. 40 minutes X 3 years = 120 minutes.

Can you reproduce it in a non-prod environment? I.e. an environment without live transactions.

Have you tried running it in a cloud hosted environment, and having a developer check the queries. I.e. missing indexes and execution plans

Was this reply helpful? Yes No
KT-14050752-0 13 on at

Like (0)

Report

Dynamic 365 F&O slow in generate counting journal

Thankyou Jonas for the suggestion.

I just test in UAT enviroment with lastest data backup at March 2025 and it take about 1.30 Hours.

About develop team they check the queries(InventBatch table) and found this table had a lot of data.

Some production order in my company had to crated sub batch around 5-20 batch,(EX. FP01001/X/25)

And some item must tranferd to another warehouse.

Was this reply helpful? Yes No
Suggested answer

Jonas "Jones" Melgaard 4,894 Super User 2025 Season 2 on at

Like (0)

Report

Dynamic 365 F&O slow in generate counting journal

It's though to say without knowing you data, but I don't believe it's caused by number of records in InventBatch.

We had a similar issue at one of my former employees, however in AX2012. Lot's of batches and inventory transactions without any on-hand.

There is a flight in 10.0.43 called "InventCountCreateOptimizationFlight", that might help you. See if you can get Microsoft to enable it in one of your test environments; It's not enabled by default.

After the flight, consider this in the following order:

1: Have a developer debug it in a tier-1 environment, and see if you can optimize it

2: Try to stagger the batch jobs, so they don't run at the same time or together with other long-running batch jobs.

3: Implement inventory transaction archiving

Was this reply helpful? Yes No
KT-14050752-0 13 on at

Like (0)

Report

Dynamic 365 F&O slow in generate counting journal

Dear jonas,

After consulted with the development team they told that "InventCountCreateOptimizationFlight" cannot edit, and must ticket to microsoft to let they investigate and solve this problem.

Maybe I'll try another solution such as create the new page to call the counting data by development team.

And thank you for your suggestion.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,179 Super User 2025 Season 2 on at

Like (0)

Report

Dynamic 365 F&O slow in generate counting journal

Hi KT-14050752-0,

Flight features are controlled from the Azure SQL database. Better raise a request with Microsoft and investigate the impact of flight feature on the On-hand entries cleanup.

On-Hand Entries Cleanup:

The On-hand entries cleanup is recommended by Microsoft to be done outside of business time. In one of our implementation projects, we optimised the job for 4 sites to include Site parameters and non-Open transactions. This brought down the performance of the job to 1 hour and 2 mins from 2 hours.

New inventory transaction is generated after warehouse on-hand entries clean up is run.

Question:

Looks like you are using advanced warehousing for items that use variants or dimensions above location in the reservation hierarchy? Is that correct?

Have you considered extending InventCleanupWHSInventSumService.cleanUpInventSum() by adding the following code.

_inventSum.reread();

Before invoking next cleanUpInventSum();

In addition to the cleanUpWHSInventReserve() method cleaning up WHSInventReserve table records the cleanUpInventSum records will also be deleted if you try adding the code above.

Inventory Dimensions Cleanup Job:

Consider running the Inventory dimensions clean up post running the On-hand entries clean up because sometimes, while the inventSum data is being cleared by the On-hand entries cleanup job there could be performance implications on the Inventory Dimensions cleanup job.

Check out this flight InventDimLPCleanupCheckNullFlight mentioned in the KB Article although it states Inventory dimensions with license plate clean up. Check if it is applicable in case of batch numbers too.

Hope this helps.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Dynamic 365 F&O slow in generate counting journal

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Dynamic 365 F&O slow in generate counting journal

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates