after few days of playing with the new reporting tools I can say that probabily you are crating a perfect tool to match all the localization needs. I think that Manager, together with custom fields for the chart of accounts that I’ve already suggested, is still missing the possibility to share custom fields through different typology of data.
I try to explain better what I am suggesting through an example.
As already exposed, in Italy, under certain conditions, we can change (anticipate) the accrural period of the VAT of the fiscal documents (ie invoices and notes) without altering the accrual period of the invoices. To do this we have created two custom fileds, one that sets the VAT period (ie, for quarters 1Q2020, 2Q2020, 3Q2020, 4Q2020) and one that set the Anticipation (Anticipated or blank).
Obviously we had to create these custom fields for all the typologies of fiscal documents (Sales Invoices, Credit Notes, Purchase Invoices, Debit Notes). The problem is that when we create the query we have eight columns: four columns of “VAT Period” and four columns of “Anticipation”. To be functional, usable, coherent and also understandable there should be only two columns that goes through all the different fiscal documents.
Any solution for this problem?
Thanks for the great work you are doing.