How do I find State of customer?

[OrcaSoul]

Is there a way to get a list from the database of the States where customers live and match them to sales?

I need to pull out the customers who do not reside in Washington State - the sales tax rules have tightened up and they tell me I need to prove they don't live in WA or I need to pay the sales tax...

And yes, I am going to look into adding a sales tax module that will collect the local sales tax...

[RescoCCC]

All you have to do is keep hard copies of the order generated by Zen Cart. In addition, the orders are stored in admin so, if need be, you can print them out.

[OrcaSoul]

All you have to do is keep hard copies of the order generated by Zen Cart. In addition, the orders are stored in admin so, if need be, you can print them out.

OK, what you are saying means going to each order individually and copying information?

What I need is some way to code a search that will scan the DB and put it all in a list...Isn't that the purpose of keeping a database?

I'm thinking this would be a MySQL query - but I don't know how to set that up.

[RescoCCC]

What I need is some way to code a search that will scan the DB and put it all in a list...

Why? The only time you would ever need the info is if the Dept of Revenue were auditing you. It isn't something you need to provide as part of your excise tax report.

[OrcaSoul]

Why? The only time you would ever need the info is if the Dept of Revenue were auditing you. It isn't something you need to provide as part of your excise tax report.

No, I need it now when I file my taxes with the DOR - otherwise I need to pay sales tax for every order that I can't prove was not out of State.

I just got a "ruling" to this effect in an e-mail from them.

[RescoCCC]

No, I need it now when I file my taxes with the DOR - otherwise I need to pay sales tax for every order that I can't prove was not out of State.

I just got a "ruling" to this effect in an e-mail from them.

You don't need a report. All you need to do is enter the total for out of state sales in section 18 under Interstate & Foreign Sales and then enter that amount under Column 2 deductions on the retailing line, and subtract it from the total to get the amount for the taxable amount column.

This assumes, of course, that you've been keeping some sort of books/accounting as you go along.