Flow field question

pvar

Hi,

I know flowfields are not part of the table in which you define them but I have a strange situation.

We have a flow filed in service item table and during sales order posting codeunit 5920 assigns a value from the sales header table to that flow field(I saw the code) even though the flow filed is defined as a look up to another table where there is no data, bad design I agree.

When I look at the service item card, I see the value for the flow field but if I do a CALCFEILDS in the code I get nothing because the lookup returns null.

So my question is where exactly the flow field data is physically stored that I see on the card? We have Navision 3.6 with sql server option.

Thanks for any help.

nunomaia

you make CALCFIELDS before or after getting record?
you should make CALCFIELDS for each record you get.

CALCFIELDS is done automatically you are using has a direct source expression in forms

DenSter

It's not stored in the flowfield, flowfields are calculated values that are retrieved from other tables. Entering a value in the flowfield enters a record into the table where the sumindexfield is defined for a value that makes the flowfield value true. So if the CALCSUM of the sumindexfield is 10, and you enter 15 into the flowfield, the system will add a record with the value 5 to the table with the sumindexfield. This is really tricky stuff, so you have to test it properly.

David_Cox

DenSter wrote:

It's not stored in the flowfield, flowfields are calculated values that are retrieved from other tables. Entering a value in the flowfield enters a record into the table where the sumindexfield is defined for a value that makes the flowfield value true. So if the CALCSUM of the sumindexfield is 10, and you enter 15 into the flowfield, the system will add a record with the value 5 to the table with the sumindexfield. This is really tricky stuff, so you have to test it properly.

A good example to look at is the Budget Tables, as you enter a value in the flowfield the child table records are created!

As to the tricky stuff, sure is, if you were to make the Customer balance editable and entered zero, you would have problems!