Flowfields and SQL

Iwan_Jauch

Hi there

I am using an ODBC SQL driver to read data out from the navision sql database, but I can't find the flowfields of customer in the customer table.

Where are flowfields stored in the navision sql?

Thanks a lot for your help.

Best regards
Iwan

Mog

afaik nowhere, flowfields are calculated at runtime...

Iwan_Jauch

Hi Mog

So I need to create the same "flowfield" in my application, excel as an example?

When I try to read the Navision Field "Balance" than I need to rebuilt the CalcFormula ?

Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Customer No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)))

Thanks for your help

Best regards
Iwan

Luc_VanDyck

Have a look at this thread: qty on hand using sift tables from sql

Flowfields are stored in separate tables on a SQL database.

Iwan_Jauch

Hi Luc

Thanks for your help.

I am a little bit disappointed about possiblities to read out the values. So when want to reuse a excel application I can't use it anymore.

So I need to built a SQL Query for every flowfield I want to read out correct?

Thanks a lot for your help.

Best regards
Iwan

kine

Yes, you can use nested selects for example for that...