//tax rates
InvoiceTaxes
ID
Active
DateAdded
DateExpires //when to stop adding this tax
DateStarts // when to start adding this tax
Matches (choice city,state,country,postal code)
Amount //percentage or fixed
CallItTaxOrVat bool
ChargeAsService bool
ChargeAsProduct bool
SpecialProductID // only charge this tax for a specific product/service
SpecialProductCat // only charge this tax for a specific product/service
Thank you for your feedback! Do you think this database layout would be sufficient for tax/vat? As the vendor of the software, I certainly would try to get this right and to assist my customers in making sure it's right, but I'd make it clear that I can't be held liable for any incidental, consequential, and etc from usage of my software outside of the cost of the software.
Perhaps I should stick this on the code board, but uh, I already got a thread here