R6 How to add Total Sales to Sales Tax Report?
Posted: Fri Dec 20, 2013 2:05 pm
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?
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?