Hi,
I have an issue with how to handle Brutto (tax-included) prices in supplier invoices.
The client wants to enter the Brutto price first for each invoice line, and then have Tryton calculate the net/untaxed price and tax.
PS(I have already developed the code, where I added a field named Brutto in Lines field during create the supplier invoice to fill in the brutto and from witch the net price is updated automatially based on the brutto entred)
My question is about how the invoice Total should be calculated.
For example, suppose we have two products:
-
Product 1: Brutto = 50.00, VAT = 19% → Unit price (net) = 42.02
-
Product 2: Brutto = 80.00, VAT = 19% → Unit price (net) = 67.23
The sum of the entered Brutto amounts is:
50.00 + 80.00 = 130.00
However, if I calculate the invoice total from the rounded net amounts:
-
Untaxed = 42.02 + 67.23 = 109.25
-
Tax = 20.76
-
Total = 109.25 + 20.76 = 130.01
So there is a 0.01 difference caused by rounding.
My question is: Which calculation is considered the correct approach in Tryton/accounting?
Should the invoice Total be:
- The sum of the Brutto amounts entered on each line → 130.00
or
- Untaxed amount + Tax amount based on the rounded net amounts → 130.01
Since the client enters the Brutto price as the source value, I would like to know which approach is recommended in Tryton and how this rounding difference should normally be handled.
Thank you!