Date Filter

sathishmadhav

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

ara3n

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.

garak

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

ara3n

Never used the field till today

garak

:-$

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

Regards