Hi Mark,

Thanks for help. One question, is the tax area assigned to the customer automatically? Do you do that by matching the customer city against the TaxArea city?


>I use a sales tax table. My customer table has a FK field with the TaxArea [PK] value from my TaxArea table. In my TaxArea table I have the following fields:
>
>TaxArea I
>City C(40)
>TaxRate N(9,6)
>ExemptRate N(9,6)
>StateRate N(9,6)
>
>The Exempt Rate field seems superfluous because in all cases [except 1] I have encountered that rate is 0%. In Louisiana all tax exempt sales are still taxed at 4%. If you need more breakdown, you could include a CityRate, MetroRate, CountyRate, etc. All depends on your level of detail needs.
>
>In my Invoices table I do have to duplicate these rates for all invoices in case the current TaxRates change [and they always do]. That way I always have a history with the invoice of what the sales tax rate was at the time of the old invoices.