>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?
Chris McCandless
Red Sky Software