New Custom Fields and Chart of Account

Dear @lubos,

given the recent evolution of Custom Fields, how about give us the possibility to link them also to accounts items of Chart of Accounts?


That doesn’t sound bad.

Could you please describe your use case for COA custom fields?

They can be used for many cases: riclassification of the CoA, notes, extract data quicker

I had thought custom fields for COA was the best (or at least most achievable) method of extending Managers reporting for application and jurisdiction specific classification. An actual use case is described in some detail here Custom fields for chart of accounts - #5 by Patch

However after thinking about it further I no longer believe that approach is optimal. While it could be used by the very technically skilled users, the majority of users will find such a tool set just too hard to even start using. The underlying issue is it does not allow separation of the component of the reporting common to a group of users / business (which should be shared as a localisation) from the component specific to a particular business.

A more powerful method which does not have this limitation would be to support

As described in more detail here Ratio Analysis - #12 by Patch

Account reporting categories would be useful, but there should still be a field where users can enter the purpose of the accounts (Notes to General ledger accounts).

I make another example. In Italy we have to indirect taxes based on two different results of the P&L. One is assimilabile to the net profit and the other quite different.

With two custom fields, or a multiple choice field we can manage to have these two totals.

If we are going to have custom fields on COA instead of alternate reporting categories for COA; then it would really help if the custom field could be configured to set multiple parts / values.

To explain, when a user is assigning a COA account to an alternative reporting category that involves setting the category but also the categories position within the alternative COA structure. For example from Custom fields for chart of accounts - #5 by Patch if a user sets an account as “Rent expenses” then that implies that COA account is also part of the “Expense – ordinary” group. That second assign should be set when the custom field drop down list is defined.

A way of support that would be to have a Multi component drop down list. When the custom field drop down list is defined; the index value and other field values are defined (ie a table is filled out). Then when a user selects the index component, Manager sets the other components as well based on how the other parts of the drop down list are set up. Custom reports could then be written to search for or group by any component of Multi-component drop down list.

I suspect such a facility would find wider application in Manager.

Perhaps I should clarify; custom fields in the COA would work well for my personal requirement. I could easily use multiple custom fields on the COA to write a custom report to:

  • generate all the totals which are enter into the annual income tax return

  • Generate an audit report showing how Managers accounts are mapped to the the tax return totals.

So I perhaps I should just concern myself with my own requirements and fully support this idea. I’m sure lubos will organise something which will work for other users in time.