Tax change calculation help appreciated

[duckman]

Our tax rate (Canadian G.S.T.) changed on July 1st. I had a calculation for the 7% tax that is now reduced to 6%. When I change the calculation to 6% the previous invoices change as well.

We sell events and so the calculation change for the GST field needs to be determined by whether the event took place before or after July 1st, 2006. There is a field for the event date in the same record.

Can anyone suggest the GST field calculation to do this?

Thanks in advance.

[Genx]

Should've used globals and lookups in the first place... But seeing as you had none...,

Well, come to think of it, you haven't really made very clear what it is you want done. Do you want all your fields changed, do your fields already include gst, are you simply attempting to isolate the gst portion - or the portion excluding gst or the total amount including or excluding gst?

Either way, you will most like be using a simple case or if statement.

Case(Events::EventDate <= 01/06/2006 ; ExcGst * 0.06 + ExcGst ;

Events::EventDate > 01/06/2006 ; ExcGst * 0.07 + ExcGst)

Three things about the above:

1) It is using DD/MM/YYYY for the format,

2) It is calculating total cost inc gst from an exc gst field

3) It uses FM7+ syntax, you should use comma's not semi colons.

4) It relies on the fields being re-indexed or else stored calculations.

Hope this helped, if it didn't feel free to yell for help... or at me ,

Welcome to the forums :

[Lee Smith]

Hi [color:red]Genx,

I have not tested your calculation, but the poster is using v6, so I have modified it to be more v6 friendly.

Case(EventDate <= 01/06/2006 , ExcGst * 0.06 + ExcGst ,

EventDate > 01/06/2006 , ExcGst * 0.07 + ExcGst)

Hi [color:red]duckman, and welcome to the Forum.

HTH

Lee

[Squeaky Data]

Welcome to the forum,

I have had a lot of calls this week about the GST change so it seems that you are not alone.

Lee's calculation should work but as Genx notes you should look at doing this with globals and lookups rather than relying on your event dates.

Using globals and lookups will make it simpler down the road when the proposed drop to 5% GST occurs and when they raise it back up to pay for all their new spending.

Steve

[Genx]

You see, everyone tells me gst will never change, and i just say, yes well, i have a global field where the value can be changed! .. Then again, this is australia, we are a bit slow when it comes to politics :