SQL : How to join Sales Invoices to Delivery Notes?

Is there a correlation (join?) table that records the “Connections” between Sales Orders, Delivery Notes, Sales Invoices, etc?

If so, what is it’s name?

If not, how can I query a list of Sales Invoices that do not have Delivery Notes?


Following SQL query will give you the list of Invoices without Delivery Notes:

select DISTINCT parent from `tabSales Invoice Item`
WHERE delivery_note is null


Divyesh Mangroliya


It’s per item!!!

Got it. Thanks.

1 Like