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.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Performance issues in generating electronic accounting with high transaction volume

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Performance issues in generating electronic accounting with high transaction volume

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates