Hey W8WCA,

Thank you for reaching back out and rebuilding and updating your database. You're not doing anything wrong. The report was designed to show the full details of a certain amount of sales order. When running the full detail report, I advise adding a debit and credit column or account column for clarification purposes. I do recommend using the Summary Detail Report instead of having to customize the filters to All.

You can refer to this article that goes into how to more details on customizing reports.

If you have any questions, please let me know. I will be happy to help!