Invoice Calculation Question

[kodeman]

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.

[Søren Dyhr]

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

[kodeman]

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.

[Søren Dyhr]

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

[kodeman]

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

[jamesducker]

> 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