I need an SAP Business one query that will show in the below format;
The query should have a join where a sales order is made and joined to it's delivery and from delivery to Sales invoice. The query should also take into consideration where sales order is done and no delivery is done but an invoice is done on the sales order.
Please treat this as urgent. I do not want duplication but a one row output as shown above.