IIF Statement to distinguish VAT Rates

[Stemdriller]

I need to distinguish VAT rates for invoices, and I believe this will be done via the IIF statement.

If the invoice date is before 01/12/2008 then rate is 17.5% after down to 15%. I would then be able to calculate the VAT amount on invoices.

Any help would be appreciated.

 

[namliam]

What if the VAT changes back to 16 and then to 17 and 20 in the future??

You had beter IMHO make a fuction to do a lookup on a table or something to get your VAT rates instead of an IIF.... much more maintenance free.

 

[Stemdriller]

This is only for invoices from now back to September 2008.

 

[namliam]

Something like...

IIF ([Your invoice date] < #12/01/2008#, 17.5%, 15%)

Should do if you want to force it... still... its good for now only...

you may need to replace , by ;

 

[gemma-the-husky]

but VAT is going back up again in Dec09

you really would be better with a look up table, than relying on case statements - you never know - at some point you may even have some zero rated supplies that you cant handle with your iif statement.

you may also have special case vat rate treatment for late presented invoices, which varies from a strict 15%/17.5% regime.

 

[Stemdriller]

Of course, I always forget the #.

Thanks Namliam

Gemma, I know what you mean, but on this occasion all the data gets imported from our ERP system and is only looking at about a 6 month period.

 

[neileg]

Yes but if you have an invoice that is dated after 31 December but relates to a supply dated before 1 December, the VAT rate is not 15% but 17.5%. Even if your SQL works, your logic is flawed.