Trying to Zero the VAT!
Hi all, I have a field for VAT on my invoice layout which is set to calculate the VAT based on either a subtotal or a total field (depending on whether there is a discount or not). In the event an object is sold overseas or a Non VAT country I need to zero the field.
I have tried a button which inserts a calculated result (0). However the zero appears and then the previous calculation reappears when you exit the field. I have also tried script triggers on exit to set field to 0. These don't work either..