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.