I'm trying to get our sales tax codes and sales tax items set up so that I can differentiate types of sales that are taxed differently for city business & occupation returns vs state sales tax. Tax Codes are pulled from customer settings and line items (which may not be the same,) and Sales Tax Items are used for the rates to charge on taxable items.
Currently we have tax codes of Taxable, Non-Taxable and Out of State.
I have a customer set up as Out of State (which is true for most sales to this customer,) however, for one job, he has taxable and non-taxable items on an invoice, and this job is partially in state and partially out of state. The tax item on the invoice charges the correct amount for the taxable items on that invoice.
How can I create a combination of codes and items so that when I pull a Sales Tax Revenue Summary I don't wind up with sales that were correctly charged tax classified under non-taxable or out of state sales?
It seems to be the Customer Tax Code that is most of the issue as it can't be set up at the job level. Not all jobs for a customer will have the have the same code but changing it for an invoice changes it for the customer regardless of which job the work is for.
Hopefully someone can understand this explanation of the issue well enough to provide suggestions. If so, I'd appreciate your help!