Sales by Customer Detail report (screenshot 1) is for both income and COGS for inventory items (screenshot 2). That’s why the report is showing positive and negative numbers.
To show one line per item in essence for income only, you will need to customize the report.
Click the customize button > Go to Lists section > Distribution Account > select “All Income Account” (see screenshot 3) > Run Report
New customized report will show just one line per item invoiced (see screenshot 4).
|If you found our answers useful then please contribute few bucks to support this forum. Thank you!