Paul Hill wrote:
Hi Peter,

If we take 200 and add 14%:
200 Net + 14 % = 228 Gross.

To calculate the vat amount from 228 :
228 * 14 / 114 = 28

14 / 114 = 0.1228070175438596

It's not normally how I would calculate VAT but it's correct.

Normally I use:
net = ROUND(gross / (1 + (VatRate / 100)), 2)

Paul
Sorry "gross" didn't register with me as I've never had to calculate the vat from that figure.
So 28 is 14% of 200 but only 12.28% of 228
In SOP calculations you have to start off the net figure, then apply any discounts including potential settlement discounts then apply the VAT % to that. The net figure, discounts and the VAT amount are stored in the SOP data so can use them separately.
Peter




_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to