Every quarter I have to send in my Florida Sales tax return. For every florida account I have, I list FLORIDA as the salesperson. I then create a COMMISSION SALES (invoices) report for salesperson FLORIDA to see how much Florida sales I did for the quarter. For the Q1 of 2005 it shows I did $745.45 in sales which definitely isn't right. In fact I have an invoice for $6857.10 for a Florida customer (FLORIDA salesperson) which was created on 1/9/05 & it does not show up in the report. The invoice was sent on 4/18/05 & closed on 4/26/05. I also did a COMMISSION SALES (invoices) for Q2, thinking the report may be based on the close date, but it doesn't even show up as a FLORIDA sales on Q2. How exactly do I include all invoices for Florida customers that were created in the first Quarter of 2005? Or perhaps there is a better way I determining my Florida sales for a month or quarter? Any help would be greatly appreciated. -David Tanguay www.interactiveonline.com
yes I use Product Sales Report to find my total sales for the quarter, but how do I find my total Florida sales for the quarter? There is no way to use the Product Sales Reports to show only for a particualr salesperson. Please advise.
Wouldn't it easier to use the Region (instead of salesperson), since that's what it is, then base the report on region?