How can I filter a list of invoices to only show those between certain dates?

Invoices and other lists can be filtered by any field in the document. To illustrate: We'll use the example of a date range of May 1, 2016-Dec 31, 2017.

1) Start by clicking the More Actions → Settings button and choose List Options.

2) In the filter tab, find the field that you want to filter by and double click it. In this example, we will double click Invoice Date.

3) In the right-hand pane, choose a comparison operator and then type a value. In this example, we will choose greater than and enter the date one day before the beginning of the range. In this example, we will use April 30, 2016.

4) Click the line and choose copy then click More Actions then select Copy. This will copy the filter. Change the comparison to less than and enter the day after the latter end of the date range. In this example, we will enter Jan 1, 2017.

5) Click Finish Editing and Close.

6) The invoice list is now filtered.

Note: This list will stay filtered until you return to List Options screen and uncheck the filters.

                                                More Actions → Settings → List Options.

After choosing the field to filter (Invoice Date), comparison (Greater than and Less than) and the value (Date).

Copying a line : Select the line → More Actions → Copy.

• Related Articles

• How to create a Customer List using the Universal Report

  Resolution is :       1. Go to Reports → Universal Report.       2. Select Catalog and Address/Contact.       3. Click Show Settings, Grouping by "Owner"       4. Click Run Report. This will show all address/contacts from all customer cards grouped ...

• I can't see all of the sales orders (or invoices, quotes, purchase orders, etc) that should be in the list view. Where are they?

  Q : I can't see all of the sales orders (or invoices, quotes, purchase orders, etc) that should be in the list view. Where are they? A : They are still there! There probably is a filter set on the list which restricts the documents shown in the list. ...

• How to Get a Customer Address Report Grouped by City

  The universal report is a powerful tool. It has lots of options and to learn how to use it, it's best to use a real life example.  Navigation: Reports → Accounting → Universal Report In the first dropdown, choose Catalog. In the second drop down, ...

• How to create Sales Invoices?

  Sales Invoices track sales of products or services for inventory control and for tax and accounting purposes. Sales Invoices record a customer’s liability to you and record income from the transaction. The calculations made on Sales Invoices are also ...

• The AccountingSuite Command Bar

  The AccountingSuite command bar appears at the top of almost every screen in the application and contains actions that may be taken on the data showing on the screen.    For example, on the Sales Orders list view, you can use these actions to create ...