Saturday, February 23, 2019

Create a Report that Shows First Invoices of Customers

1. Navigate to Lists > Search> Saved Searches > New> Customer.

2. Under the Criteria tab > Standard sub tab > Filter, set the following:

- Transaction Fields: Type: Invoice

3. Under the Results tab> Columns sub tab > Field, set the following:

- Name: (Summary Type: Group)

- Transaction 
 Fields: Date: (Summary Type: Minimum)

- Transaction 
 Fields: Document Number: (Summary Type: Minimum)

4. Rename the Search Title.

5. Hit Save & Run.


No comments:

Post a Comment