Hello to all. Today I’m in trouble with taxes. . It is possible that I can do mathematical calculations in the template ticket?
sorry for the post but could not find how to clear it. I found what I needed.
But I have a problem:
VAT 10% : [=F(TN(‘{TICKET TOTAL}’)*0.1)] €
TOTAL LESS VAT : [=F(TN(‘{TICKET TOTAL}’)*0.1+{TICKET TOTAL})] €
can fix it? the total less tax must subtract 10%
How about [=F(TN('{TICKET TOTAL}')*0.9)]
???
If you have 2 totals you want, one as 10% of the total then the other should be 90% no?
No, I need one 10% ,
and one total less 10%…
Which is 90% no? What’s 100% less 10%?
[=F(TN(’{TICKET TOTAL}’)-((’{TICKET TOTAL}’)*0.1))]
Not sure if that would work… I’m on my phone… but just in case 90% and 10% doesn’t equal 100%
Many different ways to do this, and it can depend on whether or not you have your system set to include Tax in prices or not.
<J00>Subtotal:|[=F(TN('{TICKET TOTAL}')-TN('{TAX TOTAL}'))]
{TAXES}
<J00>Tax Total:|{TAX TOTAL}
{SERVICES}
[TAXES]
<J00>Tax {TAX NAME} ({TAX RATE}%):| {TAX AMOUNT}
[SERVICES]
<J00>{CALCULATION NAME} ([=F(TN('{CALCULATION AMOUNT}'))]):| {CALCULATION TOTAL}
no they expected. I would just figure it into the template ticket
Why you make it so complicated? I guess you didn’t setup tax template (still not sure if your {TICKET TOTAL} already have VAT included or not)
VAT = {TICKET TOTAL} * 10%
Total less VAT (Most ppl call Sub Total) = {TICKET TOTAL}
Total (incl VAT, Most ppl call Total) = {TICKET TOTAL} + {TICKET TOTAL} * 10% = {TICKET TOTAL} * 1.10
He hasn’t done that though so this is giving him 110% of his total… that’s why I said to do 90%
The real question for him is {TICKET TOTAL} has tax or no tax.
If tax included in {TICKET TOTAL}
Total less VAT 10% = {TICKET TOTAL} / 1.1
Vat 10% = {TICKET TOTAL} - {TICKET TOTAL} / 1.1
I’m pretty sure the ticket total includes the tax that’s why he is doing the 10% from it.
Sorry on phone can’t do scripting lol
That is wrong. I’m not surprise more than 60% of ppl do the wrong thing actually I should say 80%.
This is … but i need to convert in positive, and *-1 doesnt not work.
Subtotal:|[=F(TN(’{TICKET TOTAL}’)/1.10 -TN(’{TICKET TOTAL}’))]
Did you know, if you set up tax template. You can use {PLAIN TOTAL} as total before tax and {TAX TOTAL} as tax and {TICKET TOTAL} as total incl. tax?
Seriously, if you want positive value would you put small amount first then minus bigger amount.
Subtotal:|[=F(TN('{TICKET TOTAL}') - TN('{TICKET TOTAL}')/1.10)]
Mana Thanks