Announcements
No record found.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,965 Super User 2026 Season 1
YUN ZHU 1,125 Super User 2026 Season 1
Dhiren Nagar 961 Super User 2026 Season 1