List of Sales Order where Invoices were Already Paid but no Item Fulfillment was made yet

1. Navigate to Transactions> Saved Searches>New
2. Pull up Transaction search.
3. On the Criteria tab, add the following:

Billing Transaction Fields ….> Type= Invoice

Type = is Sales Order

Applying Transaction: Type = is any of Cash Sale, Invoice, Item Fulfillment

Tax Line = is False

Shipping Line = is False

Status = is Sales Order: Pending Fulfillment

Billing Transaction: Date Closed = is not empty

4. On the Results tab, click on Remove All and have all the following fields.

Date ——– Group

Type ——– Group

Main Line Name —— Group

Number ——- Group

Billing Transaction: Date —– Group ——— Invoice Date

Fulfilling/ Receiving Transaction: Date —- Group —- Fulfillment Date

Billing Transaction: Date Closed —— Group —— Payment Date

5. put a name on the Search.

6. Hit Save and run.