Flowfield Issue

ricky76ricky76 Member Posts: 204
I wondered if anyone could help. I have a field flowfield in table A that sums up the quantity from a decimal field in table B. However i only want to include it in the flowfield records that have a date greater or equal in table A than a date held in table B.

Example 2 records in table B

010108 - 10
010208 - 15

Records in table A

010108 - Flowfield should read 25
011508 - Flowfield should read 15 (ignoring the first record as the date is greater).

Can anyone help?


  • kinekine Member Posts: 12,562
    This cannot be done through flowfield definition. You need to add Date Fitler flowfilter field which will filter the data, which are summed and set this FlowFilter to correct filter for each record when showing them in a form.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.