SQL : How to join Sales Invoices to Delivery Notes?

ERPNext Reports
1

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?

2

Hi,

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

Thanks,

Divyesh Mangroliya

3

OH!

It’s per item!!!

Got it. Thanks.

1 Like