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. ...

• Customizing Columns in the Companies (Customer/Vendor) List View

  In CustomBooks™, you can customize the columns in the Companies List View to display the information most relevant to you. By default, the Companies List View shows columns such as Code, Company Name, Type (Customer, Vendor, or C/V), Consignee, ...

• Creating Sales Invoices

  Overview Sales Invoices are essential for documenting sales transactions, ensuring timely payment from customers, and maintaining accurate financial records. The calculations made on Sales Invoices are also used to calculate Cost of Goods Sold ...

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