How to get net and gross amounts per tax rate in templates?

[MeisterAdebar]

Hi,

I am currently customizing the invoice template and would like to display the amounts per tax rate.
I can already output the tax rates using [% for key, value in vats %], but I am unsure which variables to use to correctly display the net and gross amounts for each tax rate.

For example, I currently have:

<table style="border-collapse: collapse;" border="1" align="right">
<tbody><!-- ZEILE 1 -->
<tr>
<td style="font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: bold;">Steuersatz</td>
<!-- [% for key, value in vats %] -->
<td style="text-align: right; font-size: 10pt; font-family: arial, helvetica, sans-serif;">[[key]] %</td>
<!-- [% endfor %] -->
<td style="text-align: center; font-size: 10pt; font-family: arial, helvetica, sans-serif;">Rechnungsbetrag</td>
</tr>
<!-- ZEILE 2 -->
<tr>
<td style="font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: bold;">MwSt</td>
<!-- [% for key, value in vats %] -->
<td style="text-align: right; font-size: 10pt; font-family: arial, helvetica, sans-serif;">[[value.nettoFormated]]</td>
<!-- [% endfor %] --> <!-- rowspan START -->
<td style="vertical-align: middle; text-align: center; font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: bold;" rowspan="3">[[bruttoFormated]] €</td>
</tr>
<!-- ZEILE 3 -->
<tr>
<td style="font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: bold;">Nettobetrag</td>
<!-- [% for key, value in vats %] -->
<td style="text-align: right; font-size: 10pt; font-family: arial, helvetica, sans-serif;">netto?</td>
<!-- [% endfor %] --></tr>
<!-- ZEILE 4 -->
<tr>
<td style="font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: bold;">Bruttobetrag</td>
<!-- [% for key, value in vats %] -->
<td style="text-align: right; font-size: 10pt; font-family: arial, helvetica, sans-serif;">brutto?</td>
<!-- [% endfor %] --></tr>
</tbody>
</table>

Is there a predefined variable in FewoHbee for net and gross amount per tax rate? Or can i calculate it somehow?

[developeregrem]

Hi :)

so basically the vats variable looks like this:

Array ( 
  [7] => Array ( 
    [brutto] => 720 
    [netto] => 47.102803738318 
    [netSum] => 672.96 
    [nettoFormated] => 47,10 
  ) 
  [19] => Array ( 
    [brutto] => 240 
    [netto] => 38.319327731092 
    [netSum] => 201.6 
    [nettoFormated] => 38,32 
  )
 )

this can be accessed like this in your loop: value.brutto value.netto , etc

I think your netto? can be replaced with [[value.netSum|number_format(2, ',', '.')]]
and brutto? with [[value.brutto|number_format(2, ',', '.')]]

Let me know if this what you need. Otherwise, you can calculate it on your own.
Like you use [[bruttoFormated]] (total gross) already, there is a [[nettoFormated]] for the total net.
And for calculation just leave Formated and you get the raw value.

Alex

[MeisterAdebar]

Very cool, thanks for the help.

That's exactly how I envisioned it (including the formatting).

However, the calculation of [netSum] in the array is off by a few cents.

Is it because the value is being calculated with too few decimal places?

1405.77 -> 1405,61
315.84 -> 315,97

[developeregrem]

Your impression is correct. netSum is currently calculated separately and internal roundings lead to different values. But both are correct and accepted.
netSum is not used at the moment in the application, therefore I will change the calculation in the next release so amounts will be displayed without differences.

[MeisterAdebar]

... therefore I will change the calculation in the next release...

As a side note, a small change request for the next release:
Sort the template list alphabetically.