search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.48k stars 2.8k forks source link

Update tax.lib.php #32041

Open le-reparateur opened 18 hours ago

le-reparateur commented 18 hours ago

When expensereport for a month and for a tax rate contains more than 1 line (n lines), the tax report contains n identical lines and total are impacted with those n values. In this exemple ER2409-0045 contains 7 different payments (2 payments with 20% tva, 2 payments with 10% tva and 3 payments with 5.5% tva -> the picture). The lines are copied 7 times for the same value in the report.

Capture d'écran 2024-11-21 152725

Add GROUP BY in SELECT sql request solve the problem.

Francis

eldy commented 15 hours ago

What is the url or menu to use to reach the page with the screenshot ?

le-reparateur commented 14 hours ago

url : .../htdocs/compta/tva/quadri_detail.php Then left menu -> month report -> select a period -> select a month -> click on a rate in supplier list to obtain all lines... Capture du 2024-11-21 23-24-44