Skip to Content
Aug 24, 2018 at 11:38 AM

SAP Business One query for Sales order,delivery and invoice all joined


Dear Experts,

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.