We just released a PHP SDK which would enable you to easily load their data to generate custom reports.

https://github.com/invoiceninja/sdk-php

We're also working on a marketplace which would enable you to share/sell your report with other users.

@scottalanmiller We have a REST API and a PHP SDK, more info here...

https://www.invoiceninja.com/api-documentation/

Hi, my name's Hillel. I'm the lead developer of Invoice Ninja.

You can see more of the things I build on my personal site: https://hillelcoren.com/

@garak0410 You may also want to look into using our Zapier integration.

https://zapier.com/zapbook/invoice-ninja/microsoft-dynamics/

@scottalanmiller Although the app is quite complicated the database schema is pretty straightforward, from reading your earlier notes you may be best off writing custom reports against the database. Note: this would only be possible using the self host version of the app.

If you have any questions I'm happy to help.

@Romo That's awesome!!!

There are close to 100 migrations which explains why it takes so long, we're looking into enable use of a single SQL file when first installing to improve the performance.

To keep things simple but flexible I'd suggest the following:

• Use the self host version of our app with our automated Softaculous installer:
  https://www.softaculous.com/apps/ecommerce/Invoice_Ninja

• Create reports using a graphical tool, there are some good options listed here:
  https://www.quora.com/What-would-be-the-best-report-generator-tool-for-mySQL-DB-that-is-web-based-and-open-source

While you can create reports using our API it'd most likely be easier using the database.

@garak0410 Have you tried running sudo apt install docker-compose

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

ERROR: In file './docker-compose.yml' service 'version' doesn't have any configuration options

From searching online this error can sometimes be resolved by upgrading your version of docker-compose.

https://github.com/docker/compose/issues/4053

You can check which version you're using by running:

docker-compose version

@Romo That's awesome!!!

There are close to 100 migrations which explains why it takes so long, we're looking into enable use of a single SQL file when first installing to improve the performance.

@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:

ERROR: In file './docker-compose.yml' service 'version' doesn't have any configuration options

From searching online this error can sometimes be resolved by upgrading your version of docker-compose.

https://github.com/docker/compose/issues/4053

You can check which version you're using by running:

docker-compose version

@garak0410 Have you tried running sudo apt install docker-compose

@garak0410 What errors did you see, I'm happy to try help fix it.

To keep things simple but flexible I'd suggest the following:

• Use the self host version of our app with our automated Softaculous installer:
  https://www.softaculous.com/apps/ecommerce/Invoice_Ninja

• Create reports using a graphical tool, there are some good options listed here:
  https://www.quora.com/What-would-be-the-best-report-generator-tool-for-mySQL-DB-that-is-web-based-and-open-source

While you can create reports using our API it'd most likely be easier using the database.

@scottalanmiller We have a REST API and a PHP SDK, more info here...

https://www.invoiceninja.com/api-documentation/

@scottalanmiller Although the app is quite complicated the database schema is pretty straightforward, from reading your earlier notes you may be best off writing custom reports against the database. Note: this would only be possible using the self host version of the app.

If you have any questions I'm happy to help.

@garak0410 You may also want to look into using our Zapier integration.

https://zapier.com/zapbook/invoice-ninja/microsoft-dynamics/

@garak0410 Sorry to hear our app didn't work for you.

If you let us know what was missing we'll try to help.

@scottalanmiller Thanks!