|
Group: Forum Members
Last Active: Tue 2 Feb 2021
Posts: 77,
Visits: 334
|
Hi,
I have a website that would like to run report to see how much tax was collected over a fiscal period? Is there such a feature? Does anyone have a query to get this info?
Thanks
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
I have not seen such a report, but you could run a custom query from Admin > Configuration > Database Admin > Run Query.
Something like:
select sum(IR_Quantity * IR_TaxPerItem)
FROM tblKartrisInvoiceRows kir INNER JOIN tblKartrisOrders ko
on ko.O_ID = kir.IR_OrderNumberID
WHERE ko.O_Date BETWEEN '2016-01-01' AND '2017-01-01'
would give you a result, but I am not sure if you would need to do a currency conversion on this.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|