Supplier invoices pending payment ...

Before of all, sorry for my poor english!!!

I would like propose a new function (or perhaps, a new idea) for Dolibarr. I think it would be something simple and at least for us, it would be of GREAT HELP. I trust that more people too.

In menu FINANCIAL> SUPPLIER INVOICES> PENDING
would be amazing to be able to generate any type of PDF with the maturities of the week, 15 days, or month.
In case the PDF is complicated, also would be worth a filter in GRID own invoices.
I see that in the current DEMO SITE, as ye have Combo Set to filter dates on invoices (suppliers), but we where more need those filters is EXPIRATION.
(we have supplier payments on cash, 30 days and 60 days and is perhaps a little uncomfortable or list the payments to be made in the coming days)

I tried EXPORT (UTILITIES)> SUPPLIER INVOICES AND PAYMENTS, and just the field EXPIRATION INVOICE not exist on the list. With what I can not make the list of earrings for this week, even in the excel.

Here I leave my idea. I hope it’s well received.

Thank you for your attention.

Best regards

IP2000

Hello,

Which Dolibarr version are you using ?

Do you need this field only for supplier invoice ?

If I can manage to make something I’ll send you the php file to substitute in your installation.

Rgds.

Hi,

I won’t get fast solution for PDF generation !

But I think it should be fine to add this field in the export lists, let me know which version you’re using so I could double check and send the right file(s)… at least you’ll be able to export to Excel.

Rgds.

Hi,

Assuming you’re on a 3.3.2 please get the attachment, unzip it and replace this single file in your Dolibarr installation folder …\core\modules\modFournisseur.class.php

In EXPORT (UTILITIES)> SUPPLIER INVOICES AND PAYMENTS you’ll get a new field “Payment due before” in the export list.

Wish it helps.

Rgds.

modFournisseur.zip (3.84 KB)

Hi Humphrey

I apologize for taking so long to answer

Woooowwwww, amazing;-)

I use the 3.3.1, but there is no problem. I will update to 3.3.2

Today I’ll try and give you an answer.

Thank you very much!!!

Best Regards

Hi,

No problem to use the file for both 3.3.1 or 3.3.2

So you can try without upgrade.

Anyway will be better to upgrade by one of these days as 3.3.2 gets many bug fixes.

After the upgrade, you’ll have to substitute the file again.

Rgds.

hi humphrey,

Thank you very, very much!

Works perfectly :woohoo: . I can export to excel and i have the outstanding payments of this week controlled in a much easier way.

Versions higher than 3.3.2, the module will work?

Thank you again
Best Regards

Hello,

Not sure it works with higher version but you can try and restore the original file if it doesn’t work.

Anyway higher versions are not stable so I do advice you not to use them in “production” environment…

Rgds.

You should check a new functionnality on 3.4 and soon on 3.5 with outstanding_limit, wich could work with your tool, no ?

Hope you read french, or you can check on github develop and search “outstanding” or Defrance pull’s requests :wink:

http://www.patas-monkey.com/index.php/fr/actualites

(désolé je fais ta pub Defrance)