Page 1 of 1

R6 How to add Total Sales to Sales Tax Report?

Posted: Fri Dec 20, 2013 2:05 pm
by AbleMods
I have full source code, so it's not a problem to change it if necessary.

A client needs the Sales Tax report by location code,showing both tax collected and total sales. On their tax forms, they have to submit both amounts for each location code, not just tax collected.

I added a decimal TotalCharges property to the TaxReportSummaryItem class. Then I tried modifying the nHibernate query in TaxReportDataSource.LoadSummaries() to sum "O.TotalCharges". But it doesn't query as expected.

Any suggestions on how to change the LoadSummaries() so it totals both tax and order total for what was taxed?

Re: R6 How to add Total Sales to Sales Tax Report?

Posted: Fri Dec 20, 2013 2:55 pm
by compunerdy
I mentioned this as well.. It needs to show the total order amount per loc code and not total tax collected as these are the numbers WA state asks for. It needs to be order totals before shipping and tax but after coupons, etc.. This year I just ended up learning how to write a SQL statement to get past this issue but I would like to see it built in..

Re: R6 How to add Total Sales to Sales Tax Report?

Posted: Sat Jan 04, 2014 10:07 am
by Katie
I created a bug report for this as well. I would sure hate to miss important issues like this, so you can always use the green Feedback button to report bugs. Just remember - if you don't get a response to an issue in the forums, then it's likely we missed it.