Sales Report by invoice not applicable

1

sales Report by invoice not applicable

2

Got it. If the built‑in sales reports don’t give you “sales by invoice,” use Advanced Queries on the Sales Invoices tab to produce exactly that and print it like a report.

Quick steps to make a Sales by Invoice report

  • Go to Sales Invoices.
  • Click Advanced Queries > New Advanced Query.
  • Select columns: Issue date, Reference, Customer, Amount, Balance due, Status. Reorder as you like.
  • Where:
    • Issue date is on or after [start date]
    • Issue date is on or before [end date]
    • (Optional) Status is Paid/Unpaid/Overdue
  • Order by Issue date (ascending) and/or Reference.
  • Leave Group by blank if you want one row per invoice.
  • Create, then click Print at the bottom to get a printable report.