It seems that with the new adds to Custom Reports we are now able to reproduce Tax Summary and Tax Transactions even with further implementantions for TT to make it coherent with TS (see the attached screenshot). But there are the issues:
- I cannot show dates when I use “Group to collapse”. I understand why @lubos has excluded them by default but I think that he should add Issue Date under Transactions (as well as Type, ie Sales Invoice, Purchase Invoice etc etc if we want to subgroup them);
- Reverse Charge for Tax doesn’t show up. For Invoices subject to Reverse Charge the tax amount should be shown both on Sales and Purchase side (with coherent results also on Total Sales, Total Purchases and Tax Liability). This is coherent with TR (but it’s an issue that I’ve already pointed out) but not with TS. As said TR it is completely wrong under a fiscal point of view since it should show symmetrical amounts on both Tax on Sales and on Purchase.
- I had some difficulties to find out Tax On Purchases since in the report is called PurchaseTaxAmount while on for sales is called Tax On Sales coherently with the standard reporting.
- Last but not least, the most important and urgent one, the new custom reporting tool is missing a flag to choose if we are working under accrural base or cash base. I have same taxes that are under one or the other tax regime. Until that it will be usable only for accrural based taxes.
In the end what we are missing for a full reporting, together with accrural Vs cash base, is the possibility to have custom fields across different modules. I refer in particular to all kind of “invoices” which could and should share additional data.