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 January 1, 2024- May 31, 2024.

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

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 panel, 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 December 31, 2023.

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 June 1, 2024.

5) Click Finish Editing and Close.

6) The invoice list is now filtered.

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

More Actions → Settings → Configure List.

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

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

• 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 is probably 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, ...

• Creating 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 CustomBooks™ Command Bar

  The CustomBooks™ 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 a new ...