Hi all, in a nut shell.. i need to be able to do the following example in an invoice which will not calculate the VAT/Tax in a field: example below of £31.00 should be exempt in part of the Invoice.

MOT Charges £16.71

VAT/Tax £02.92 (Field calculates tax

of £16.71 @ 0.175

Subtotal £19.63

MOT £31.00 ( Omit tax

calculation here

Total £50.63

-------------------------------------------------

So i need to omit the MOT field of £31.00 from being calculated with VAT or Tax?

Does anyone know how to get around this or know a script/or calculation theory.

Many Thanks Forum. Liam.

It could be in several ways, this is one of them....

The reason for Choose( is to exploit the undefined state when the pointervalue is less than 0 to avoid dangling zeros!

--sd

Invoice.zip

Hi there, many thanks for the solution your a genius... however in the solution you sent me could the VAT/Tax field be included to show the VAT amount, and below that a subtotal field as in the following to show only the MOT Charges and VAT added together?

MOT Charges £16.71 ( Field 1 )

VAT/Tax £02.92 (Field calculates tax ( Field 2 )

of £16.71 @ 0.175

Subtotal £19.63 ( Field 3 )

MOT £31.00 ( Omit tax ( Field 4 )

calculation here

Total £50.63 ( Field 5 )

Could you show me such a solution?

Many Thanks

Kodeman.

See if this is enough? One thing though, is that the Vat rate ought to be stored in a way the user can access it, in case of change!

--sd

InoviceVatShow.zip

Many thanks, your are great help...cheers...

> See if this is enough?

> One thing though, is

> that the Vat rate ought

> to be stored in a way the

> user can access it, in case of change!

Hear hear! Fortunately all our systems were designed to cope with the latest change in the UK VAT rate to 15%, announced today with only a week's notice - but many won't be.

We can of course assist anyone whose system can't handle it...

James