Hi guys,
I've been trying to get this form to work for a few days, a pretty simple invoice for an architect I'm working for.
I''m trying to take a Sub Total from a series of Expense fields, which is all working fine.
Then I try and get 15% of this value for the VAT. I can get this to work but when I go back and amend the Expense fields, the VAT field doesn't update. The same can be said for the Invoice Total and Amount Due, they don't seem to update. The only way to get it to work is to manually go in and clear all the fields, but even that sometimes doesn't pick up the changes.
So, for the VAT fields and the other fields leading from that I've been using a script I found on here:
event.value = 0.15 * this.getField("Total exc VAT").value;
For Invoice Total
event.value =
1 *this.getField("Total exc VAT").value +
1 *this.getField("VAT at 15").value;
To have a play go here: www.manvsmachine.co.uk/paul_archer/Quote_03.pdf
Cheers,
Rob.
