Analytic Accounts Dimensions

by PESOL , Tecnativa , Odoo Community Association (OCA)

v 10.0 v 11.0 v 12.0 Third Party 628

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	160
Technical Name	`analytic_tag_dimension`
License	AGPL-3
Website	https://github.com/OCA/account-analytic
Versions	10.0 11.0 12.0 13.0 14.0 15.0

You bought this module and need support? Click here!

Analytic Tag Dimension

This module allows to group Analytic Tags on Dimensions.

Dimensions are created as custom field, then you can group by Dimensions on:

Account/Adviser/Journal Items
Account/Reports/Business Intelligence/Analytic Entries

When you set Tags on Analytic Entries, each custom field for dimensions is updated with its Tag.

One Tag is only allowed on one Dimension, and you can not set more than one Tag from same Dimensions on Analytic Entry.

Configuration

To configure this module, you need to:

go to /Accounting/Configuration/Analytic Accounting/Analytic Accounts Dimensions to create new Analytic Dimensions.
You can create new Analytic Tags on this form, or go to /Accounting/Configuration/Analytic Accounting/Analytic Accounts Tags and set Dimension for each Tag.

Known issues / Roadmap

Analytic Entries with Tags created before installing this module are not updated with theirs Dimensions.
Set color on Analytic Dimensions, and get it on Analytic Tags.
Change implementation to create stored computed fields, instead of rewrite create and write functions.
On the function that create fields, get all the models that inherit from AbstractModel
Set dimension on invoice report
Improve fields_view_get to create filters on search view

Usage

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Credits

Images

Odoo Community Association: Icon.

Contributors

Angel Moya <angel.moya@pesol.es>
Artem Kostyuk <a.kostyuk@mobilunity.com>

Maintainer

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit https://odoo-community.org.

Please log in to comment on this module

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.

Ratings
Discuss

Dimension creation error

Gylmar Flores

on 10/16/18, 2:18 PM

Is not possible to create a new dimension, an error es displayed: Error: Odoo Server Error Traceback (most recent call last): File "/.repo_requirements/odoo/odoo/http.py", line 650, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/.repo_requirements/odoo/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/.repo_requirements/odoo/odoo/tools/pycompat.py", line 87, in reraise raise value File "/.repo_requirements/odoo/odoo/http.py", line 692, in dispatch result = self._call_function(**self.params) File "/.repo_requirements/odoo/odoo/http.py", line 342, in _call_function return checked_call(self.db, *args, **kwargs) File "/.repo_requirements/odoo/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/.repo_requirements/odoo/odoo/http.py", line 335, in checked_call result = self.endpoint(*a, **kw) File "/.repo_requirements/odoo/odoo/http.py", line 936, in __call__ return self.method(*args, **kw) File "/.repo_requirements/odoo/odoo/http.py", line 515, in response_wrap response = f(*args, **kw) File "/home/odoo/OCB-11.0/addons/web/controllers/main.py", line 934, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/OCB-11.0/addons/web/controllers/main.py", line 926, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/.repo_requirements/odoo/odoo/api.py", line 687, in call_kw return call_kw_model(method, model, args, kwargs) File "/.repo_requirements/odoo/odoo/api.py", line 672, in call_kw_model result = method(recs, *args, **kwargs) File "/home/odoo/build/OCA/account-analytic/analytic_tag_dimension/models/analytic.py", line 37, in create 'relation': 'account.analytic.tag', File "/home/odoo/OCB-11.0/addons/mail/models/ir_model.py", line 38, in write res = super(IrModel, self).write(vals) File "/.repo_requirements/odoo/odoo/addons/base/ir/ir_model.py", line 208, in write return super(IrModel, self).write(vals) File "/.repo_requirements/odoo/odoo/models.py", line 3089, in write self._write(old_vals) File "/.repo_requirements/odoo/odoo/models.py", line 3227, in _write field.write(self.with_context(rel_context), vals[name]) File "/.repo_requirements/odoo/odoo/fields.py", line 2260, in write comodel.create(act[2]) File "/.repo_requirements/odoo/odoo/addons/base/ir/ir_model.py", line 648, in create self.pool.init_models(self._cr, models, dict(self._context, update_custom_fields=True)) File "/.repo_requirements/odoo/odoo/modules/registry.py", line 311, in init_models func() File "/.repo_requirements/odoo/odoo/fields.py", line 1957, in update_db_foreign_key new = process(model._cr, model._table, self.name, comodel._table, 'id', self.ondelete or 'set null') File "/.repo_requirements/odoo/odoo/tools/sql.py", line 169, in fix_foreign_key cr.execute(query, (tablename1, columnname1)) File "/.repo_requirements/odoo/odoo/sql_db.py", line 154, in wrapper raise psycopg2.OperationalError(msg) psycopg2.OperationalError: Unable to use a closed cursor.

Issue

aesp

on 7/26/18, 6:02 PM

When I create a dimension at the menu, an throw a error and I can not save de dimension. This happen to when I create it direct with a tag. Error: Odoo Server Error Traceback (most recent call last): File "/usr/lib/python3/dist-packages/odoo/http.py", line 646, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python3/dist-packages/odoo/http.py", line 307, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise raise value File "/usr/lib/python3/dist-packages/odoo/http.py", line 683, in dispatch result = self._call_function(**self.params) File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/http.py", line 332, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python3/dist-packages/odoo/http.py", line 927, in __call__ return self.method(*args, **kw) File "/usr/lib/python3/dist-packages/odoo/http.py", line 512, in response_wrap response = f(*args, **kw) File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 920, in call_kw return self._call_kw(model, method, args, kwargs) File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 912, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python3/dist-packages/odoo/api.py", line 687, in call_kw return call_kw_model(method, model, args, kwargs) File "/usr/lib/python3/dist-packages/odoo/api.py", line 672, in call_kw_model result = method(recs, *args, **kwargs) File "/mnt/shared-addons/analytic_tag_dimension/models/analytic.py", line 37, in create 'relation': 'account.analytic.tag', File "/usr/lib/python3/dist-packages/odoo/addons/web_studio/models/studio_mixin.py", line 27, in write res = super(StudioMixin, self).write(vals) File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/ir_model.py", line 32, in write res = super(IrModel, self).write(vals) File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 208, in write return super(IrModel, self).write(vals) File "/usr/lib/python3/dist-packages/odoo/models.py", line 3011, in write self._write(old_vals) File "/usr/lib/python3/dist-packages/odoo/models.py", line 3136, in _write field.write(self.with_context(rel_context), vals[name]) File "/usr/lib/python3/dist-packages/odoo/fields.py", line 2253, in write comodel.create(act[2]) File "/usr/lib/python3/dist-packages/odoo/addons/web_studio/models/studio_mixin.py", line 18, in create res = super(StudioMixin, self).create(vals) File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 631, in create self.pool.init_models(self._cr, models, dict(self._context, update_custom_fields=True)) File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 307, in init_models func() File "/usr/lib/python3/dist-packages/odoo/models.py", line 272, in _reflect self.env['ir.model']._reflect_model(self) File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 247, in _reflect_model query_update(cr, self._table, params, ['model']) File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 54, in query_update cr.execute(query, values) File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 154, in wrapper raise psycopg2.OperationalError(msg) psycopg2.OperationalError: Unable to use a closed cursor.