Hello colleagues, Could you please clarify how I c...
# general
o
Hello colleagues, Could you please clarify how I can find a "Base amount" field for the invoice in the European bandle? The filed means the sum of money to which a particular tax type and its percent should be applied. And it is possible that there is more than one base amount value for a single invoice. Examples: Example 1: The invoice has only one line item and one base amount: Price = 50 Quantity = 1 Tax Code = S Tax rate = 20% Then calculations -> Subtotal = Base amount= 50 (in this case subtotal equals base amount), Tax = 5, Total = 55 Example 2: The invoice has 5 line items with different tax codes and rates and 3 base amounts (attached). Calculations: • 2 lines with VAT tax code S of 17% → 50€ and 160€ • 2 lines with VAT tax code S of 10 % → 15, 33€ and 199€ • 1 line with E: 380€ The result of Base Amount should be: 1. Base of S (17%) = 50+160 = 210€ VAT = 210*17% = 35,7€ 2. Base of S (10%) = 15,33 + 199 = 214,33€ VAT = 214,33*10% = 21,43€ 3. Base of E (0%) = 380€ VAT = 0% So, 210, 214,33, and 380 should be shown somewhere as base amounts. Totals based on it: • Subtotal = 210+214,33+380 = 804,33€ (in this case subtotal is not equal base amount) • Tax = 35,7+21,43+0 = 57,13€ • Total = 804,33+57,13 = 861,46€ I've reviewed financial fields that exist but do not see something called "Base amount". Maybe it's called differently? Please help to find it.
a
@battk Hello Battk, Could you please help with this question?
b
too long
but amount is probably what you are looking for
or potentially gross amount
taking a closer look, it looks like you are looking for amounts grouped by tax code, which isnt something a record tracks
you would have to make your own saved search to do that
o
Hello @battk Thank you for the reply. Yes, base amount is a part of an amount grouped by tax code. Ok, I thought maybe there is a specific field representing this value. But I see that I need to calculate it manually.