News and Announcements icon

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

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 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
Suggested answer

TeddyH 12,868 Super User 2024 Season 1 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;
Suggested answer

Tech-Lucky 796 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans