We have been asked to produce a current vendor list and a current customer list. What is the best way to do this.

Define current?

Most likley you could just use F6, add the last invoice date to the grid, and the search on that date. The results can be exported to Excel.

How do you add the field to the f6 list?


I figured out that you double click on the field heading to ge t to the fields edit- was more intuitive to right click -Problem solved.
thanks

Adding columns to the F6 smartfinder grid is the same as any other grid (including finders).

Here is a short video on how to edit columns on grids.