In Germany we have to show the customers the product-prices including the tax (gross). But at the end of the form near by the total price we also have to show the included tax.
In the form I solved this by using product fields with calculation for tax and total. All product-prices are shown with tax (gross). My tax field calculates the tax from the gross-prices. Because of this I can´t use the automatic total-function: the calculated tax is only for information, but the automatic will add it again, so the total ist gross-price plus tax = "double tax". To solve this I use my own total function with an calculating product field.
So far so good, it works fine. But in the Mails there are again automated total-fields in the order-table at the end, by using {all_fields}. It adds the product prices, my calculated total and my calculated tax - and so the new total price is more than double from the real correct total.
Where and how can I customize this E-Mail-table, I need to delete the automated total-calculation there?! I hope this works, because the other way by constructing the Mails manually would be much more complicated, i have many fields and conditionally-logic fields. So "all-fields" is very easy and quite perfect for me, except the automated total.