Breakdown per VAT when printing an Invoice pdf.

Hello,

I need some advice from Suitecrm “expert” to point me in the right direction…

I need to print the totals grouped per VAT code into the invoice pdf

For example, let’s say I have 10 items in one invoice (both products and services) where 4 items have 20% VAT and 6 items have 10% VAT, I would print into the invoice pdf, the breakdown as follows:

(Dropdown Label VAT 20%) (sum of total amount with 20% VAT) (sum of VAT 20%) (sum of total amount + sum of VAT 20%)
(Dropdown Label VAT 10%) (sum of total amount with 10% VAT) (sum of VAT 10%) (sum of total amount + sum of VAT 10%)

I was thinking to create 3 custom fields (the 3 totals) into the invoices module, populate them via a logic hook (upgrade safe) and place these fields into a customized pdf invoice.

I’m not a php expert but I could try to modify a logic hook example if some of you have something that could be adapted to the purpose.

Of course, welcome anyone who has a better idea to achieve the same result :slight_smile:

Thank you.

Pj