web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Avoid Calculation of F...
Microsoft Dynamics NAV (Archived)

Avoid Calculation of Flow Filed - NAV 5.0

(0) ShareShare
ReportReport
Posted on by Marshal 440

Hi all,

i have a database with huge data and have flow filed in one of the master table , when ever i open card form it is calculating flow fields, since the data is huge it is taking long time and very slow to open the card form. is there any possibility to avoid calculating flow filed, when opening a form. 

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,235 Super User 2025 Season 2 on at
    RE: Avoid Calculation of Flow Filed - NAV 5.0

    Hello,

    Remove the field from the form and that should take care of it.

  • Agusti Carceller Profile Picture
    Agusti Carceller on at
    RE: Avoid Calculation of Flow Filed - NAV 5.0

    Hi,

    Field must be setup as "visible" = False on you page.  

    NAV only calculates visible fields.

    Regads

    Agustí

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at
    RE: Avoid Calculation of Flow Filed - NAV 5.0

    Hi Marshal,

    Is it Item List or Chart of Account? It was performance headache when we first migrated NAV from 6 to 2015 for a customer. NAV 5 and 6 manage FlowFields better than NAV from 2013 (latest NAV 2016 is still not good). There are 2 things you can try:

    - Hide unneeded FlowFields.

    - Set ValueIsFilter=true when define CalcFormula.

    If still not get better, you should think about Normal Fields.

    Besides, I don't know why Microsoft not allow us to choose suitable Key when define FlowFields CalcFormula? It will be a big difference of performance.

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.

Helpful resources

News and Announcements

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#3
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans