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

Create Query to Show Sales Order Number, Delivery and Invoice

1648 Views

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.

Thanks

Jon