Sales Tax Confusion!

Not sure if this is the answer to your question, but you may be able to query via administrator ( couldn't find a report that allows you to filter by item sales tax - what a surprise)

items that are set to "none" in the tax field in item properties are flagged with a tax id of zero.....to view these use select * from item where taxid = 0

if you're limiting who can change the tax code on a sale (or if you're 100% sure that the tax code of items are not changed manually on receipts) you can also use select * from transactionentry where taxable = 0

if this last query shows you the items you were interested in (items that did not charge sales tax on a transaction) then you can use this to get a total select sum(price*quantity)AS TOTAL_VALUE from transactionentry where taxable = 0

I was going to add a few more but find myself walking out the door, please advise if this is what you were looking for....

H> I want to know the value of items that i have sold with 0 Sales tax (not the

Thanks Convoluted - the first query is more along the lines of what i need, but its awkward having to use administrator to get it - I'm sure i should be able to add item sales tax id to one of the sales reports??

Thanks for your help!