Gross Amount SQL Calculation

Laurence Hiscock

Hi All


Does any one know the SQL to calculate Gross Amount of a Gift.  I need to write my own [dbo].[GiftGrossAmount] but I cannot work out the links between the Gift table and Tax_Rates.


Thanks

Laurence

James Andrews

Interesting. Do we use this in the US? I just took at look at our TAX_RATES table and there are four entries in it, the most recent of which was from 1988.

Laurence Hiscock

Thanks James.  Don't think there is Gift Aid in the US, this TAX_RATES table may be a red herring the values are similar to Gift Aid but dates are wrong, the table has no purpose in the RE Help doc.  The current rate is 25% but previously it has been different rates of the years.  I need to build future proofing into the SQL in case the rate changes otherwise I could just hard code it in a CASE statement.  Alternatively if anyone know if it fixed in table that is straight lookup that would also help (thought I had got lucky with [dbo].[GIFTSPLIT] but no).  I cannot find anything on Blackbaud support which is a nuisance as Gross Gift Amount is such a standard requirement.