I have a client that wishes to have the ability to query Simply Accounting and report on data that is not readily available from the app itself.
I've looked through the API and developer forums, but I'm wondering if anyone knows of either an open-source or commercial tool that will allow me to create queries based on an existing simply db.
I've found some commercial systems that do this, but the problem is that I need to integrate them into a larger project, and the commercially available querying tools (that I've seen anyway) don't provide anyway for me to automate the queries they can produce.
The data that I need from Simply is relatively simple (I think). I basically just need to look up all the accounts in the database, and then for each account to report on the balance of the account at the end of each month.
Any tips or insights are greatly appreciated.
