Vat

[mags]

how can i create a query to add vat to a total cost field

 

[CBrighton]

Assuming VAT of 20% & field holding price being called "PriceField":

VATRate: 0.2
WithVAT: [PriceField]*(1+[VATRate])

 

[gemma-the-husky]

you ought to put the VAT rate in a table though - in case it changes in the future

 

[DCrake]

To be really padantic you should store the VAT rate in the transaction table as a value. This is one of the rare occasions where you defy normalisation. Then multiply one by the other.

Different items on an invoice can attract different rates and should rates change you cannot run reports retrospectively to calculate the vat at point of sale.

 

[Simon_MT]

I agree, for wehatever reason VAT rates are not uniform, any export is Zero Rated for VAT and within the EU Vat is not levied if the client is already registered for Sales Tax within their own country.

Simon

 

[SteveH2508]

Don't forget that there are a few items which attract VAT at 5% (e.g. domestic power and childrens car seats)