Help with creating sales tax by county report
I've been learning about creating reports and how to use them. I believe i've followed all the information you have provided correctly but I am getting different numbers when i Group the report by county.
I believe I created almost 2 identical reports to show my issue.
sales tax by county (do not have anything grouped)sales tax by county grouping(grouped by county)
I generate the report by Payment Date from 2/01 to 2/29 and get different totals for the tax payments. I believe the "sales tax by county grouping" report is wrong but I'm not sure how to fix it. When I generate the report it has a few payments from Carver County that are supposed to be in the (non-taxable portion) but instead are in the (taxable portion). For some reason they only show up in the (taxable portion) when I group the report by county. They show up correctly when I do not group the report by county.
Any advice would be helpful and I hope my message was written clear enough.