Flowfields

sabzam
sabzam Member Posts: 1,149
edited 2007-11-14 in NAV/Navision Classic Client
Can I stop a flowfield from being calculcated when a user opens a certain form? In my case I need that when certain users open the Chart of Accounts Form the flowfield balance simply doesn't show up or at least shows a 0 amount. Can this be done?

Comments

  • ara3n
    ara3n Member Posts: 9,258
    There is a separate form that shows you the gl acount list without the amount fields. You can run that form instead.
    You could also hide the columns through code.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • sabzam
    sabzam Member Posts: 1,149
    Can Calcfields be used in a form?
  • ara3n
    ara3n Member Posts: 9,258
    navision automatically calculates the flowfields.

    One thing you can do is put some flowfilter on open form. The flowfilter will equal something like 06.06.0006. This will set all the flowfields to zero.
    I'm sure nobody posted with that date.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • sabzam
    sabzam Member Posts: 1,149
    AAAh that's a good idea, thanks
  • ara3n
    ara3n Member Posts: 9,258
    You are welcome. :)
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,121
    Or also: let it calculate normally.
    In the OnAfterGetRecord, you can put this: 
    "The Flowfield" := 0;
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • gdkve9
    gdkve9 Member Posts: 161
    @ Mr.Kriki

    Can U please tell us where can we find the "The Flowfield" variable so that as U told that can be made equal to zero on OnAfterGetRecord of the form..
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.
  • kriki
    kriki Member, Moderator Posts: 9,121
    There is no such variable. With it I meaned the flowfield you want to be 0.
    In short : for each flowfield you want to be 0, you need to do that.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • DenSter
    DenSter Member Posts: 8,307
    You could also make the field invisible for certain users
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • gdkve9
    gdkve9 Member Posts: 161
    kriki wrote:
    There is no such variable. With it I meaned the flowfield you want to be 0.
    Making all flowfilter fields equal to zero on OnAfterGetRecord is fine but I was little eager to know whether any "The Flowfield" variable is avaible which refers to all the flowfilters in a table. This was the reason for my prior post...Thanq
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.
  • kriki
    kriki Member, Moderator Posts: 9,121
    DenSter wrote:
    You could also make the field invisible for certain users
    But you need also to disable the permission to make those fields visible again if you have them in a tablebox.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • DenSter
    DenSter Member Posts: 8,307
    Flowfields should not be in tableboxes
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    DenSter wrote:
    Flowfields should not be in tableboxes
    Of course this would be the best solution for performance!
    Good you remember us this! =D> =D> =D>
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories