Change to HST problem

[123dstreet]

Hi All, just ran into a new problem. On July 1st, 2010 we changed over to the new HST (Harmonized Sales Tax). In my TAX Table I changed the tax rates accordingly. This has now had a ripple effect on sales orders prior to July 1st. Is there any way to make these changes happen to orders AFTER July 1st only? any help would be great thanks!!

 

[Fasopus]

Im assuming you mean the ripple effect is occuring on your calculated fields? If the fields are calculated through a query you should be able to just make two querys (One for Pre July 1st and one for Post July 1st) and then have a union query to combine them to give you all your records, or if your calculating through VBA an if satement would work wonders.

 

[SimonB1978]

Hi,

Here is a suggestion: In your TAX table, add a from and to date. When calculating you invoice total, select the tax rate for which the invoice date is in the interval. This way, it will continue to work for future rate changes

Simon B.

 

[123dstreet]

That sounds like a good idea, except the tax rate for each invoice is based on certain customer information. So when you choose a customer from the drop down list, it automatically chooses the correct tax amount for their province/state. It's to make it so the user never has to guess what tax rate should be charged.

 

[SimonB1978]

Then I'd just add another column with the province/state and look it up the same way you would do for the date.