What VAT Was Added?

[abbaddon223]

Hi,

I'm wondering if someone can help me please?

I have a field: [Total_Paid] which contains a currency value. What I need to do is work out what VAT was added to the net amount to get the [Total_Paid] through VBA

So, if £300 was in the field [Total_Paid], I need some code that would put
£50 into the field [VAT] and;
£250 into the field [NET]

IE: £250 was the amount paid, £50 was added for VAT (at 20%), meaning £300 was paid - so it's a vat calculation but in reverse. :banghead:

In excel it would be: [Total_Paid] /(100%+20%) = £250

Any help appreciated!!

 

[pr2-eugin]

Same as that.. However Saving the values in table is questionable.. If they are unbound text boxes it would be something along the lines of..

Me.[NET] = Me.[Total_Paid] / 1.2
Me.[VAT] = Me.[Total_Paid] - Me.[NET]

 

[abbaddon223]

Bingo!! Perfect and thank you

 

[gemma-the-husky]

with VAT i would 100% store

amount pre vat
vat rate
vat amount
(maybe amount plus vat)

i would not call this redundant data, as there are particular legal requirements associated with accounting for VAT.

 

[GaryPanic]

Also VAT rates on certain items is different


Standard 20% Most goods and services
Reduced rate 5% Some goods and services, eg children’s car seats and home energy
Zero rate 0% Zero-rated goods and services, eg most food and children’s clothes


just a note - hence the reason for keeping VAT amt and % seperate
We know it goes against the norm - but the VAT man is the VAT man and his will overides common sense.
also be prepared for VAT changes in two years tiem - election time

G

-

 

[abbaddon223]

HI - thanks for all the advice - very much taken onboard!!