Decipher different taxation for each entry

tim.dauti — Wed, 30 Sep 2026 09:35:14 GMT

Hello all,

we have a small topic in data check.

This regards 4 Elements:

1) Total net (Example : 80 $)

2) Total Gross (Example : 100 $)

3) Tax Ammount (Example : 20 $)

4) Tax % (Example 20%)

This works if all entries have same taxation.

But as some invoice entries might have different tax we are not able to pass the check 1-4 (Expected taxation).

Such cases will than land for customer review, Customer is askig if we can make the logic on every entry and than check the total.

Have you faced something similar?

Example of mixed taxation might be like this :

Delivery cost Net 30 $ (Tax 0%)

Food Gross 100 $ (Food Net 80 $) Tax 20%

Total cost Gross = 130

Total cost net = 110

Calculated tax = 130/110 = 18,18%

Expected Tax % = 20 %

Thank you

topic Decipher different taxation for each entry in Product Forum