web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Limitation on add rela...

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

Suggested Answer

Limitation on add related fields in Analysis Mode

(1) Share

Report

Report

Posted on by MN-03061245-0

2

Hello everyone!

I was trying to add the "Lot No." from Item Ledger Entries in the Value Entries analysis mode. However, when I insert the column an error occurs.

Follow the steps I made:

I've already filtered to ensure that won't exceed the row limit.

Anyone can help me?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Teagen Boll 3,009 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

There seems to be a limit of 100,000 records for the current analysis views: Analyse list page and query data using data analysis - Business Central | Microsoft Learn

Im not sure if thats changed with recent updates but you may be hitting a record limit in which case you need to add filters to get under that record limit.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,334 Super User 2026 Season 1

#2

YUN ZHU 1,717 Super User 2026 Season 1

#3

AndrewThomas81 1,470

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans