Flowfield based on a flowfield

jhanvincent14
jhanvincent14 Member Posts: 214
edited 2017-09-19 in NAV Three Tier
Hello, Good day, I have created a TableOne and one of the field(decimal) is a flowfield base on TableTwo's field(decimal) and that's also is a flowfield based on TableThree's decimal field.

Now, my problem is, If I run the TableOne, I keep getting this error (see picture attached). Actual amount field is in TableTwo that is based on TableThree's Amount field. and if I run the TableTwo, it is perfectly running. Now, If I run TableOne, this error is keep on showing and it closes the page.

Hope you can help me. thank you in advance..

Best Answer

Answers

  • guidorobben
    guidorobben Member Posts: 157
    Build a query. With a query you can sum a flowfield.
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    guidorobben wrote: »
    Build a query. With a query you can sum a flowfield.

    A page cannot be based on a query.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • guidorobben
    guidorobben Member Posts: 157
    Slawek_Guzek wrote: »
    guidorobben wrote: »
    Build a query. With a query you can sum a flowfield.

    A page cannot be based on a query.

    True. Run it by code. MS does this also.
  • Juhl
    Juhl Member Posts: 724
    Make a table and a page, as temporary. Fill the table from the query in OnOpen.
    So it is possible.

    If you only need some data/sum then skip the page, and fill the table in the query.
    Follow me on my blog juhl.blog
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Sure. In very the same way it is possible to build a page based on Excel spreadsheet.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • RockWithNAV
    RockWithNAV Member Posts: 1,195
    Still thinking how come you got this business process in particular, and why to do lookup of a flow field for another flow field, you can apply the the same calcformula for both the columns.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    To All who gave comments, thank you, I appreciated it :)
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    edited 2017-09-29
    Slawek_Guzek wrote: »
    Hi,

    Unfortunately it is impossible to have a Flowfield summing up values in another Flowfield.

    You need to redefine your Table1 flowfieldto sum up Amount filed directly from Table3

    Slawek

    Thank you, this works. God speed @Slawek_Guzek

Categories