Jump to content

Stop VAT being added on certain invoices


This topic is 6138 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6138 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.