Flow Field not working on 50000 series of tables in NAV2013

sharad

Hi frnz,

I am facing a problem when i made a new table in 50000 series and a new flow field in it. The flow field shows 0 always but when i added that field in existing table it works. I am using Developer License. I can't understand why this is happening.

If anybody has any idea about this then Plz Help.

geordie

Could you please post how did you design the FlowField?

Thanks

sharad

Hi ,

I made a field of integer type and field class is flow field and cal formula is -

Count("Sales Header" WHERE (Document Type=FILTER(Quote),Status=FILTER(Open)))

it is looking strange.

Kishorm

I'm guessing you're using this for a role centre cue - just make sure you have created a record in your custom table otherwise the flow field value will not calculate as you have discovered.

sharad

Kishorm wrote:

I'm guessing you're using this for a role centre cue - just make sure you have created a record in your custom table otherwise the flow field value will not calculate as you have discovered.

Hi,

to check this problem I save the table 9053 sales cue in id of 50000 with the name sales cue-1 and when i run table 9053 it shows data but when I run 50000 it shows 0 in all flow fields.

I can't understand what and where is the problem.

Kishorm

Yes because table 50000 does not have any records in it. Create a record in table 50000 and you will get values in the flow fields. You could write a simple codeunit with something like...

Table5000.INSERT;

Where Table50000 is a var of type Record 50000

Kishorm

Slight typo in the previous post but I'm sure you get the idea :-)

sharad

Kishorm wrote:

Yes because table 50000 does not have any records in it. Create a record in table 50000 and you will get values in the flow fields. You could write a simple codeunit with something like...

Table5000.INSERT;

Where Table50000 is a var of type Record 50000

Thank You

Solved.