Flowfields

sabzam

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?

ara3n

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.

sabzam

Can Calcfields be used in a form?

ara3n

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.

sabzam

AAAh that's a good idea, thanks

ara3n

You are welcome.

kriki

Or also: let it calculate normally.
In the OnAfterGetRecord, you can put this:

"The Flowfield" := 0;

gdkve9

@ 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..

kriki

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.

DenSter

You could also make the field invisible for certain users

gdkve9

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

kriki

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.

DenSter

Flowfields should not be in tableboxes

kriki

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>