Small and medium business | Business Central, N...

Performance issues in generating electronic accounting with high transaction volume

(1) Share

Report

Posted on by isabtogumon

Hello everyone,

We have a client with 40,000 transactions, and when generating electronic accounting, it takes a long time. The last one I generated took 9 hours. However, the client says it doesn't generate anything. Microsoft replied that this delay is due to the transaction volume, but my boss's boss insists it should be achievable because, according to the client, other companies manage to generate electronic accounting with even higher transaction volumes. Has anyone faced a similar issue and found a solution to improve performance?

Thanks in advance.

All responses (3)

Answers (0)

Suggested answer

Jun Wang 7,681 Super User 2025 Season 1 on at

Like (0)

Report

Performance issues in generating electronic accounting with high transaction volume

if the transactions are manufacturing related, it might be caused by system working on calculate/updating/posting cost related entries. 40000 is by any means a big number and it is reasonable to expect longer than usual processing time.
Suggested answer

Valentin Castravet 27,647 Super User 2025 Season 1 on at

Like (0)

Report

Performance issues in generating electronic accounting with high transaction volume

Can you expand on what modules you're using? What are the 40,000 transactions that you're posting? For example, if you're using the inventory module there are ways to set it up that can speed it up the system. Job queues can be used to post transactions during off hours. Likewise for posting purchase/sale transactions.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

YUN ZHU 81,365 Super User 2025 Season 1 on at

Like (1)

Report

Performance issues in generating electronic accounting with high transaction volume

I personally think this is the biggest problem with BC. When the amount of data is large, the performance will obviously deteriorate. . . . If this is standard functionality and no customization has been done, there is no way to fix this, and we have no way to optimize the existing functionality unless we completely redo it.

As for other solutions, for example, if you can divide the 40,000 transactions into 10 executions, can this solve this problem?

PS:

How to work with a performance problem

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-work-perf-problem?wt.mc_id=DX-MVP-5004336

Business Central Under the Hood episode 3: How many users can Business Central handle in the cloud?

https://www.youtube.com/watch?v=snVsG69X-kw

Hope this can give you some hints.

Thanks.

ZHU

Community site session details

Performance issues in generating electronic accounting with high transaction volume

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Performance issues in generating electronic accounting with high transaction volume

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates