Difference between revisions of "Calculate GST Function"

Revision as of 09:50, 30 October 2007

You can automatically determine if GST should be calculated on an item and calculate the GST by using the following technique:

This example assumes you are adding this functionality to a UTA level and three existing custom fields total - a text box to store the amount and GST - a select one combo box to indicate if the item should include GST.

1. Create an additional custom field - Calculate GST as Special - Browser Script type field.

2. Add the following expression to that field.

function calculategst(amount,gst) {if (gst=='Yes') return parseFloat(amount*0.06).toFixed(2); else return parseFloat(0).toFixed(2);}

This function - calculategst can be called from any field, but the Calculate GST field itself will not be displayed.

3. Create a calculated field to store the calculated value.

4. Add the following expression to that field.

calculategst([Total],[GST])

This expression is called the calculategst function and passes the total and the gst values. If GST is applicable, then the value is calculated and returned (to 2 places of decimal) else 0.00 is returned.