populate flow field value in another flow field

amit
amit Member Posts: 7
edited 2003-12-09 in Navision Attain
HI ,
how to populate the value of a flow field in another flow field.

I have made a flow field which will sum up some values, now in other table i have to populate that value of flow field in a field that is also a flow field


plzz solve my problem
Amit ( MCA)
Navision Technical Consultant
India

Comments

  • eromein
    eromein Member Posts: 589
    sry, no can do!

    It's not possible to flow on flowfields. To be able to flow on a field it has to be a sumindex field in the "current" (an active) key. You can not enter flowfield in the sumindex of a key.

    To do so, you should do something more intelligent. Here is a sample:

    "Inventory" is a flow fiels that flows on the "Remaining Quantity" field in the "Item ledger entries" table.

    If you want to have a flowfield that sums all inventory of an item group (it's just a sample, doesn't have to make sence) you will have to flow to the "Item ledger entries" table again but with different filters.

    So don't try to sum flowfields, but get you data from the source. Make a new flowfield that flows (gets) the same value then a sum of all the (in my sample, item) flowfield.

    another sample.

    customer saldo flows the amount from the cust. ledger entries with a customer filter. If you would like the have a sum of all customer saldo's make a new flowfield that sums the amount from the cust. ledger entries without a customer filter.


    If you don't get it, please post a sample of what you want to develop.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."

Categories