Custom Sales Order Report

Hi, i’m trying to create a simple Custom Sales Order Report of all the Sales Orders that have no reference. I can’t get it to work. What am i doing wrong?

Currently, custom reports do not have visibility into sales orders.

There is already similar topic in ideas covering this issue.

Custom report can only access transactions that are recorded in the General Ledger - sales & purchase invoices, cash receipts and payments, journal entries, payslips, etc but not orders, quotes

You could copy the Sales Order list to Excel and manipulate the date further in Excel