1. Navigate to Transactions > Management > Saved Searches > New.
2. Click the Transactions link.
3. Under the Criteria tab > Standard subtab, Add the following Filters:
- Type is Sales Order (or any other transaction)
- Date is <set the Date range>
- Account is Sales
- Document Number | Summary Type = Group
- Line ID | Summary Type = Count
6. Click Save & Run.
Example: Sales Order 1 has 4 line items
Item A - 5 Quantities
Item B - 3 Quantities
Item C - 4 Quantities
Item D - 1 Quantity
Actual Result:
Document Number Count of Line ID
Sales Order 1 4
No comments:
Post a Comment