We need to export our sales for each product to a spreadsheet for forecasting and order calculation.
I would like to replicate the 'Sales By Product Details Report' with the API.
The difficulty is that we have to get the sale list and then loop through for each sale and download the invoice lines, however I have not managed to extract the invoice lines from the JSON in excel.
Does anyone know a more direct way of accessing invoice lines or how to get the invoice lines from the Sale JSON?
Old question I know but still worth answering.
I find the best way to deal with this sort of issue is to drag the data into a database and do of the workings there.
I have a Dear to Zoho analytics feed deployed to a few clients, including consolidation of multiple Dear accounts of different base currencies. The best way to get advanced reporting is to use a tool designed for the job; zoho analytics is quite powerful and very good value.