Hello all

We recently became VAT registered in UK.

However, some of our invoices do not have VAT added before a certain invoice number

i.e all invoices before 117 do not have VAT added. All

those after 117 do!

Is there some way to stop VAT being added before 117 in calculation of formulae???

Look forward to any replies.

regards

BFGK

Assuming that you have a vat calc working already, make the vat field a calc field, result number and insert the following calc.

Case(Invoicenumber<=117;"";your vat calc)

This will make the vat field a blank if the invoice number is 117 or smaller but otherwise will apply your vat calc.

HTH

Phil

There is just one thing here Phil, strictly speaking should it be an autoenter, since the invoice is a historic document. If say Gordon manages to either lower or raisen the vat %.... during the next few month.

This means that all previous issued invoices, should undergo a scripted replace, with your calc, and then should the new autoenter be instated.

--sd