web

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

Dynamics 365 CommunityForums Small and medium business | Business Central, N... What is difference bet...

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

Suggested answer

What is difference between setautocalcfields & calcfields in business central?

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

What is difference between setautocalcfields & calcfields in business central?

and when we can used setautocalcfields or calcfields?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 90,252 Super User 2025 Season 2 on at

Like (0)

Report

What is difference between setautocalcfields & calcfields in business central?

Hi, just to add some info.

https://www.kauffmann.nl/2014/04/04/calcfields-vs-setautocalcfields/

https://www.youtube.com/watch?v=tJy7uZAm4AA

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,050 Super User 2025 Season 2 on at

Like (0)

Report

What is difference between setautocalcfields & calcfields in business central?

SetAutoCalcFields is basically CalcFields on looping.

You use SetAutoCalcFields before looping to increase the performance of your code, so the server knows that it needs to retrieve the value while calling the records.

// Using CALCFIELDS
IF Customer.FINDSET THEN
REPEAT
Customer.CALCFIELDS(Balance,"Net Change");
… // Do some additional processing.
UNTIL Customer.NEXT = 0;

// Using SETAUTOCALCFIELDS for performance
Customer.SETAUTOCALCFIELDS(Balance,"Net Change");
IF Customer.FINDSET THEN
REPEAT
… //Do some additional processing.
UNTIL Customer.NEXT = 0;

Was this reply helpful? Yes No
Suggested answer

Tech-Lucky 1,259 Super User 2025 Season 2 on at

Like (0)

Report

What is difference between setautocalcfields & calcfields in business central?

in the case of CALCFIELDS, each FlowField results in a separate query that is not good for performance if you are using this inside the loop.

The SETAUTOCALCFIELDS is one of the improvements in NAV / BC you should make use of. Any REPEAT … UNTIL loop that contains CALCFIELDS within the loop can benefit from this function. Just set a SETAUTOCALCFIELDS before the FINDSET and all FlowFields you have defined will be calculated with one SELECT command.

How does that work? Very simple: the SETAUTOCALCFIELDS automatically updates the SELECT query with JOINS for each FlowField. So one query with all your FlowFields calculated.

the conclusion is SETAUTOCALCFIELDS improves system performance.

Please verify my answer if this was helpful.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

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

#1

Sumit Singh 2,710

#2

Sohail Ahmed 2,675 Super User 2025 Season 2

#3

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans