List of "Current outstanding bills" for customers

Using my Dolibarr
1

Hi, on every third party page, in the “customer” tab there is a clickable box named “Current outstanding bills” with a numeric value for the total of unpaid invoices.
Clicking this box will take you to compta/recap-compta.php?socid=1 where there is the entire list of invoices and payments for that customer in details, which is very useful.

But, how to obtain a list of all “Current outstanding bills” for all customers, all in a single page? There is a module free or paid to accomplish this?
The very best would be to have it in a column in /societe/list.php but even another specific reports page generated from a module would be good.

Suggestions? This is somewhat critical around here, and it resisted every attempt to be solved with crude php and sql abuse…

2

Hi glsdesign,
In the latest version of Dolibarr you have a minimum of 3 choises to review the unpaid customer/supplier invoices.

  1. In Billing | Payment section you have a lists with Unpaid customer invoice, same for supplier.
  2. In Billing | Payment section > Customer/Supplier invoices you have a submenu Statistics. There you can filter the status “Not Paid”
  3. In Billing | Payment section > Customer/Supplier invoices you can go to a list ot invoices. Here you can use the filter again to display the unpaid incoices.

Hope I help. :sunglasses:

1 Like
3

Thank you hORb, I have to say I know of this options, but thanks for reminding and the effort made to be helpful, it is very appreciated. They are necessary obviously, but not quite the same thing: What if you want to know the customer with the largest sum of unpaid invoices, or maybe the top ten? Seeing, for example, the largest unpaid single invoice as per your suggestions 1 and 3 can be misleading, the largest unpaid invoice is not automatically linked to the customers with the largest sum pending, possibly generated by several smaller invoices.
There are times when you need to focus on your best/worst customers with the biggest debt, so something like this is crucial.
I am almost sure some commercial module provide this key functionality, but for the life of me I cannot find it.