auto filter

Business Central/NAV User Forum
1

in nav5 how will i set auto filter for example in entry type is purchase what will i do or what will be the code?

many thanks

2

hi victor,

can you be more specific? Are you talking about choosing a type from a list? and how to set it? then use “option” datatype!

or use table/form view…

3

Hi Victor

As shona said give us more.any way if you are using your table in form then there is an property called SourceTableView,

If you using your table in report then there is a property called DataItemTableView. these two properties will used to filter the records.For more info reffer the picture

if you click the assist edit butto of those properties a screen will be open

1018.AutoFilter.bmp (218 KB)

Thanks

Jerome marshal.J

4

in report stock movement or stock card… i want to automatically filter that only entry type positive and negative will show…

thanks