>I'm trying to implement sales tax in our invoicing system and I was wondering if anyone has any comments or suggestions on how to do it.
>
>We have a cities table that is used as a lookup for the client biliing address. It currently only has a field for CityName and a PK. I was thinking to add a state field and a SalesTax field and have the invoice determine the rate from there.
>
>-or-
>
>Should I have a SalesTaxArea table and link the cities to that.
>
>-or-
>
>Is there another better way to do it?
>Any help would be appreciated. TIA

PMFJI, but I had a question about which tax rate is applied. If you are shipping a product to one state, let's say Ohio, but sending the invoice to the company's headquarters, let's say New York, which tax rate is applied, Ohio or New York?