Show total price before tax

hi all, i have problem with the bill print, in the invoice just show the tax and total price + tax, but not shown the price before tax…

Dont know if there is a tag for ‘NET’ price or not as dont use the tax system in samba however you can use a formula to take the tax from total to give a net rate…

You can use something like this:

<J00>Subtotal:|[=F(TN('{TICKET TOTAL}')-TN('{TAX TOTAL}'))]
<J00>Tax Total:|{TAX TOTAL}

Without changing the subject completely, if you were not using the samba tax settings and wanted to show VAT breakdown would the following work?

Net: [=F(TN(’{TICKET TOTAL}’) / 1.2 ]
Tax: [=F(TN(’{TICKET TOTAL}’) / 6 ]

Yes, but missing bracket:

Net: [=F(TN('{TICKET TOTAL}') / 1.2)]
Tax: [=F(TN('{TICKET TOTAL}') / 6)]
1 Like

Is there likely to be any rounding issues doing this way? only going to be 1p if there are I guess.
Will TN format it to 0.00 or do I need to specify formatting?

to round to 2 decimal places add this to your expression ,'0.00'

for example;

[=F(TN('{TICKET TOTAL}'),'0.00' )/ 6]

Would you not need to put the formatting outside of the calculation as its the deciding by six if where the additional decimal places would come from.
Would a second TN function be required outside of the =F ?

1 Like

Sorry my bad it should be

[=F(TN('{TICKET TOTAL}')/ 6),'0.00']

that works for me

1 Like

although for me to display 2 instead of 2.00 i have to use the first example i posted but i put ,‘0’ instead of ,‘0.00’ if i try and put ,‘0’ at the end it doesnt work and still show 2.00

thanks for everybody, nice answer