The Advanced Find feature in
A view is simply a grid that shows all the records as rows and each field that you choose to be a part of the view is represented by columns identified across the top. Two key parts of Views are the filter criteria and the columns. Advanced Find allows you to search using multiple search criteria. For example, you can search for a certain City and its Annual Revenue Amount.
Now let’s say you can’t remember the exact city that this Account resides in, but you know it’s one of three cities. You can add what is called an “or” clause. Let's say you are searching for Companies that have an Annual Revenue over $500,000 and a City that is either Fargo, West Fargo, or Harwood.
Once you have the filter criteria selected, you can add additional columns. Along with adding any columns from Accounts, you can add columns (fields) from related items, such as Contact. To add a column , click Edit Columns > Add Columns. It defaults with Account as the Record Type, as that is the record type we are searching for. But from that Record Type drop down, choose any related record type, and from there, any columns from the related record type.
Once you have created an Advanced Find that you like, click Save As and this view will be available for you to see at any time. You can share the view with other users or teams. In order to save a view, while in the Advanced Find window, click on Saved Views in the ribbon. This will bring up a list of all of your personal views that you have saved. Highlight the view you would like to share and click the Share icon in the ribbon.
Since 1989, DFC Consultants has been providing accounting software solutions, training and support in our offices in Fargo, Bismarck and Dickinson, North Dakota. Our passion is to assist clients in meeting their goals with professional services and powerful business solutions.
By Andrea Lange,