Tax and Non Tax

[Greg]

I'm creating a quote sheet and i would like to calculate tax to some
of the items. I have labor items that are not taxed and i have parts
items that are. what is the best way to mark the taxed and non taxed
items so all items are not being taxed? if you need more info please
repost what you need

Many thanks in advance.
Greg

 

[Pavel Romashkin]

I think it would be reasonable to have a table of tax categories, or tax
rates. You would relate the PK of this table to the FK in the Items
table so that each item has its own tax rate from the Rates table. For
Labor items, you would choose Zero rate. You could also have different
tax rates like, say, you might want for grocery and non-grocery items.
It involves another layer of rates if you have in-state and out-of-state sales.

Pavel