Since the Sales by Customer report has a different total amount when compared with the Sales amount the Income Statement, users may opt to create a Saved Search to match the amounts.
Solution
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Select Customer
- Click Criteria
- Click Standard
- Filter:
- Transaction Fields...Type: is any of Invoice, Cash Refunds, Cash Sales and Credit Memo
- Transaction Fields...Account: is Sales
- Click Results
- Click Columns
- Field:
- Name | Summary Type = Group
- Transaction Fields...Amount | Summary Type = Sum
- Mark the Show Totals checkbox
- Click Available Filters
- Filter:
- Transaction Fields... Date
- Mark the Show in Filter Region checkbox
- Enter Search Title
- Hit Save & Run