I have a task to create quarterly reports for our companies that show some basic information in a graph such as sales per quarter, profit / loss compared to last year, open sales and open costs.
I though about scheduling a cron job for AWS Lambda for every quarter to fetch all the companies from exact, generate a pdf report and send it to the companies. Problem is that I can't seem to find the correct API endpoints for any of these things.
My question is, if it's possible to get all that kind of data using exact api so I can display it correctly in a graph in a report? I know that exact crunches the numbers from all of the invoices and provides them in a graph, but even if I manage to get all of the data from Exact api, will it be correct by default or I will need to manually add / subtract different invoices, calculate VAT etc.
First time user of exact, sorry if the question is too vague.