Paul, I had to deal with this for Canada a while back, so I'll put in my $0.02 (about, what, $0.05 Cdn these days? ;-)
What I did - defined a couple of tax fields, consisting of a description and a tax rate, and then also defined a few other parameters for those fields. The first was an order, detailing in which order the taxes should be applied. The second was a boolean - compounded, or not. Yes meant that the tax applied to the total plus the previous tax(es), no meant it was just based on the original total, pre-tax. You may want to add an 'active' field - ie, is this tax charged? In my case, I just assumed that a blank tax name meant it was not applicable. Then, with the aid of a lookup table to set the values appopriately for each province, I was set. I'd assume that you'd be able to extend this to handle other countries. Good luck - I hope this helped. Dirk > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 10:03 AM > To: CF-Talk > Subject: OT: Calculating Taxes (at least not CFMX topic :) > > > I tried to ask this one awhile back without a response... > hopefully someone > will have an answer for me (or at least direct me in the > right direction). > > We are trying to cover our international market allowing companies in > Australia, Canada, Europe ect.. to use our shopping cart > system. We have > been trying to figure out the best most "generic" way to > setup our taxing > structures. > > For the United States, it is pretty simple, does the product > offer taxing or > not? and if so, what state and what is the tax rate for that > state (not > perfect but currently it works for most companies). So > State_tax X Total > Cart = Tax Charge > > Now if the retailer is in Australia or Canada we get into > HST/GST/PST type > taxes ...how do you compute those various types of taxes ... > Then there is > the VAT? Is it similar to US tax? > > My last question would be what is a flat tax, I have seen > that around, but > is it just what it says, ...example: $10.00 flat tax no > matter how much your > cart total is? Or is the flat tax added on to the other taxes? > > Many questions and if anyone has any knowledge that they would like to > share, by all means ..Share and I appreciate it! > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
