News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Maximum number of purc...

Business Central forum

Suggested answer

Maximum number of purchase order lines

(0) Share

Report

Report

Posted on by Carlyman470

30

What is the maximum number of lines in one purchase order in Business Central?

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 68,242 Super User 2024 Season 2 on at

Like (0)

Report

Maximum number of purchase order lines

Hi, first, the database of BC is SQL. The following are the limitations of SQL. There is no limit as long as the capacity is not exceeded.

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16&viewFallbackFrom=sql-server-ver15%3Fwt.mc_id%3DDX-MVP-5004336

Below are the database and table limitations in BC.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-object-specifications-limitations?wt.mc_id=DX-MVP-5004336

But as far as I know, it should be 1 million rows. If it exceeds this limit, it will not be able to be queried.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online?wt.mc_id=DX-MVP-5004336

Hope this can give you some hints.

Thanks.

ZHU

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 227,996 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans