Greetings Captain Rost,
With your Tech Source guidance, I am on my way to creating an easy to navigate database for my wife to use. In her office practice she serves clients with beauty services and products. With her website she offers beauty products for sale with shipping and has clients throughout the United States. I am the “Office Manager” keeping track of all the transactions, inventory, sales tax, supplies, repairs, etc.
I am in need of your guidance with correctly addressing the sales tax issue on the Order form our 4 types of Orders:
1)Office (taxable products, non-taxable service and non-taxable shipping)
2)California Web Sales (taxable products, non-taxable shipping)
3)Out of State Web Sales, (non-taxable products, non-taxable shipping)
4)Resale (non-taxable products)
Product Table includes Product, Services and Shipping with Yes/No Taxable box with Yes as default.
California sales tax rates change quite often after election cycles, current tax is 8.875 percent (.08875).
My sub total includes both taxable and non-taxable products/service.
I’ve drove myself crazy trying to figure out how to code this to work properly!
What simple solution am I missing to accomplish this task?
Respectfully,
Philip