Is there a report (or SQL query) showing the usage of Tax Rules?
Hi,
I am aware that the diagnostics will tell me everything about a particular transaction ... but I am looking for data on a range of transactions.
For example, I have a Tax Regime with maybe 40 Tax Rules (counting each line in a Rule as a separate Rule).
I suspect that this is overkill ... and that many of these rules have never been used in practice.
Before setting up my next Tax Regime I would like to get a report of, say, all AR transactions in, say, a recent 3 month period, indicating which rules were actually used on each transaction so that I could evaluate which ones I need to replicate in the new Regime ... simply looking at the rates on the transactions is not sufficient as a non standard rate could have been driven by any of a number of rules depending on the Transaction Tax Classification or the Item Tax Classification or the Party Fiscal Classification or ... or ... or ...