Purchase order / complete order status / exporting

Hello guys,
I´m new into Dolibarr, the company started working with it some months ago. I started as Procurement Lead.
I´m trying to create a tool for monitoring purchase order status, develop some KPI;s, etc.
My idea is to export all the Purchase orders data, but here is the problem: I can export all the info I need EXCEPT the delivery status / reception status (not delivered, partial delivered, all products received).
Do you know if the export tool can be modified to add extra values? do you find a way to get this information extracted?
My idea is, once I am able to export the database, use a BI sw to create the reporting.

Hello,

Everything is possible, dolibarr is open source :ok_hand:

With Export tool, then it will be manual update, so I’m not sure that it’s the good way.

Better to use Dolibarr REST API no ?
Or use a BI module like this : myDolidash : integrate BI Reporting to Dolibarr

1 Like

Hi!! yes!! but I’m not sure how to work with the REST API, but we have a teammate that knows more about Dolibarr.
I was wondering if just there was an add-on module or some tweaks that can be done to customize more the export tool.

As far as I know, no.

But you can have add-on like myList : personalized dynamic Lists that can create your own list and can be exported to Excel.
But you need to have strong knowledge in SQL