Accounting mailing list archives
accounting@odoo-community.org
Browse archives
Shouldn't 'Enterprise financial reports' in localisation modules be based on tags by default ?
by
Camptocamp SA, Frédéric Clementi
Hi folks,
This is a suggestion to ease the enterprise financial report setup... which take to much time in my view (and this is too expensive for end users).
I suggest to amend all localisations modules this way :
Reports must be based on tags by default.
And each tag (on account or taxes) should match with a report lines.
I give you 2 examples to illustrate.
Example 1 on VAT report
With l10n_fr : the normal rate vat at 20% on sales has 2 taxes :
the '20%' and the '20% inclusive vat' and each of these 2 taxes has different tags.
The VAT report is based on tags.
Knowing that you can use either '20%' or the '20% inclusive vat', it will be mapped to the same VAT report lines, it would have be much easier that the 2 taxes share the same tag. The VAT report would work straight away.
Of course, you might think that it is also easy to add both tags id on the formulas of the report... Problem is: the VAT report is an XML file that you cannot update (because at next l10n_fr update, your changes will be overwritten).
(On top of this, half of formulas on this report are missing the incl.vat taxes :\ and without a proper PR on l10n_fr I cannot do a permanent correction on my customer instance...)
Example 2
Let's take l10n_ch.
The localization module pre-set a swiss P&L and Balance sheet which is great but it is based on accounts codes... meaning that if you have to amend the chart of account, you break the reports. This may happen when the end-user create a new account (keep in mind that the code is alphanumeric so you can have spaces, dots, lettrers...and your formulas may not catch-up the new code.) -> P&L is wrong and the customer think Odoo is crap !
If the P&L is based on tags, the end-user just has to put the correct tag.
Meaning that during the implementation it is much cheaper for the final customer since he can amend the chart of account himself...and if tags are correct P&L will remain correct.
(I should say that I always use this module to make the tags mandatory for P&L and B/S : https://github.com/OCA/account-financial-tools/tree/10.0/account_tag_category)
This solution came up to me as definitely the best one since I realized that user type could'not be used for the report since it is hard coded in many places.
Any opinion on this community members ?
Thanks for help to evaluate if my conclusion is good.
Frederic
Camptocamp
camptocamp
INNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSFrédéric ClementiProject Manager