Filter rows

How do I filter rows in a table? On a form I want to only show that rows from the Sales Invoice table, where the Post Desciption are bills. How can I do that? I hope you will understand me!

where are you tring to do?

manually in forms/tables or at run time through coding?

If manually, select the field in table/form, press F7 and your value

If in coding,

TableVariable.Setrange(Description,‘Bill’);

Check this out

http://dynamics-ax-live.blogspot.com/2010/03/how-to-filter-records-in-form-by-code.html

Check this out

http://dynamics-ax-live.blogspot.com/2010/03/how-to-filter-records-in-form-by-code.html

Lookup the SETRANGE and SETFILTER commands.