Skip to main content

Notifications

Supply Chain Management forum
Suggested answer

Dynamics 365 Finance & Operations Inventory Value Report too large and slow

Posted on by 6
A retail industry client has 120,000 released products, and when Inventory Value Report is generated in D365 FO, it takes a long time even when filtered to a specific time period (i.e. on average took 10 min to generate 2,300 lines) to print to the screen. We also tried tuning the parameters, batch processing and output to Excel, but the speed did not improve. Another issue is that the Excel output file takes a long time to open (i.e. roughly 10MB), so I want to know how everyone is dealing with this type of large report file as well.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Dynamics 365 Finance & Operations Inventory Value Report too large and slow
    Hi,
    When you use batch processing, you can run specific tasks as batch jobs and then schedule those batch jobs to run on a different computer (a batch server). By moving the processing of these tasks to a batch server, you can improve the report performance on the client computer. You can also apply range restrictions to limit the size of each batch. To further improve performance, don't submit one large batch. Instead submit multiple smaller batches for processing at the same time on different servers. Many tasks can be run as part of batch jobs.
    Best regards,
    Kevin
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,006 Most Valuable Professional on at
    Dynamics 365 Finance & Operations Inventory Value Report too large and slow

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans