Date Filter

sathishmadhav
sathishmadhav Member Posts: 71
edited 2008-11-14 in Navision Attain
Hi All

How do i apply "Date Filter" in Item by Location. even though date filter is visible in the Item by Location window, when you input a date it doesn't have any effect on the display of inventory. Please explain the steps.

Thanks
satish

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Inventory field which is a flowfield is not effected by date filter.

    I suggest to create a separate field, add datefilter part of flowfield calculation. Makesure there is a key that meets the filters and sumindex field. Change the form to display this new filed.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • garak
    garak Member Posts: 3,263
    as ara3n said, the inventory field is without a Date Filter in his calculation formula.
    But you can use the field "Net Change". It's the same like inventory but with Date Filter ;-)

    So in your Items by location form you must use the "Net change" field instead of the inventory.

    Regards
    Do you make it right, it works too!
  • ara3n
    ara3n Member Posts: 9,258
    Never used the field till today :)
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • garak
    garak Member Posts: 3,263
    :-$

    @sathishmadhav: and don't forgett to change the Drilldown functionality

    Regards
    Do you make it right, it works too!

Categories