Skip to Content
Former Member
Oct 29, 2009 at 04:11 PM

Create Query to Show Sales Order Number, Delivery and Invoice


Hi Experts

I would like to create a query based on Sales Invoices which will show me all sales invoices for BPs with a particular property (Properties 9) - I also need it to display the Delivery Order number and Sales Order numbers which the invoice was based on.

I can do the simple bit to show the Invoice Amount, Tax etc, but can't figure out how to write the SQL to join the RDR1, DLN1 and to the OINV.