Hi, when using a flow filter on a report is this ignored when the report runs? I ask in relation to the inventory valuation report. If you bring in the bin filter field and put a value in it then it is ignored by the report. Is this correct?
If you enter a Location Filter of RED for example on the Item Card, then the Inventory value will be filterd by the RED location.
This works because the FlowField for Inventory includes the Location Filter in its CalcFormula.
So, if you had an Item report which included the Inventory field and you supplied a Location Filter of RED then the report would show the Inventory value filterd by the RED location.
Comments
For example, the Location Filter on the Item...
If you enter a Location Filter of RED for example on the Item Card, then the Inventory value will be filterd by the RED location.
This works because the FlowField for Inventory includes the Location Filter in its CalcFormula.
So, if you had an Item report which included the Inventory field and you supplied a Location Filter of RED then the report would show the Inventory value filterd by the RED location.
www.NextEqualZero.com
A technical eye on Dynamics NAV