Hi,
the “report by rate” should not only group the VAT rate but also the VAT-code. So it’s possible to have the same rate for different things, like we need it in CH for the supplier invoices
Look for
$sql = "SELECT fd.tva_tx AS vatrate,";
$sql .= " fd.product_type AS product_type,";
$sql .= " cc.label AS country,";
in file 'htdocs/compta/stats/byratecountry.php ’ and add mySQL & print statements.
1 Like
Hi Peter,
thanks for the note. I was probably not very specific with my question. I thought more of ‘Sale tax report by rates’ at /compta/tva/quadri_detail.php?leftmenu=tax_vat
Do you refer to (which is virtually the same system as in Germany):
Could you provide an example of an invoice?
PS: I’m not an accountant or tax advisor
not really. In CH, we have to differentiate between “Products/Services” and “Investing/Operating Expense” in the VAT Settlement Form for input tax. However, the tax rate is 7.7% for both.
If the Dolibarr report sorts not only the tax rate but also the field “llx_c_tva.code”, this requirement can be met.
See Ziffer 400 and 405 in the form: https://www.estv.admin.ch/dam/estv/de/dokumente/mwst/formulare/abrechnung-muster/muster_ssa_eff_1q2018.pdf.download.pdf/muster_ssa_eff_1q2018_d.pdf
