A recent question was to retrieve item sales information from Exact Online in a specific date period, including the parent company of the customer being invoiced.

This can be formulated for Exact Online using Invantive SQL as:

select sie.invoicedate , sle.item , sle.itemcode , sle.itemdescription , sle.netprice , sle.quantity , sle.unitprice , wmij.code , wmij.name , moeder.code , moeder.name from salesinvoicelines sle join salesinvoices sie on sie.invoiceid = sle.invoiceid join accounts wmij on wmij.id = sie.invoiceto join accounts moeder on moeder.id = wmij.parent where wmij.parent is not null and sie.invoicedate > '2016-01-01'

Of course you can execute this query from any Invantive product that is bundled with the advanced SQL provider for Exact Online. This includes the upcoming Invantive Data Hub; a command-line driven tool to upload and download information across the cloud.