Hello all

I have a great invoice table thats been working great. Unfortunately, we now have a client in EU. I 've been informed that we don't charge VAT to clients based in EU.

I 've created a field on my contacts list named COUNTRY with a drop down box UK or EU.

If the drop down box states EU is there a way that calculation field for VAT not be used or made to = 0?

Look forward to any replies! I will keep working on an answer!

regards

BFGK

Make your vat amount field a calc field and use the following calc

Case(Country="EU";0;your current vat calc)

This will set the vat amount to 0 if the field country = EU or will set it to your current vat result otherwise

HTH

phil

Thanks I used the following:

If(Wholesale Contacts::Country="UK";Total Net * 17.5/100;0)

Seems to work!!!

BFGK

Do not hard code the 17.5 in the calc itself. Store it in a filed in a preferences table since tax rates change all the time.

So the value of Preferences::Taxrate would be .175