Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Why my new field is not accumulating in Graph?

By
Hugo Pascual
on 6/30/15, 9:40 AM 300 views

I just added a new field in the Sales Order model, named "Base Amount without Tax". It's type is float, and it was added via Configuration->Database Structure->Models.

When I try to use it as a Measure in the Graph View, it's shown blank, without any value. What do I have to do so I can use this field as an accumulated measure in Graph View? 

Here is an example of the Graph View:



Base amount without Taxes
Total
Total

15,000.00
  Customer 1

5,000.00
  Customer 2

3,000.00
  Customer 3

7,000.00



Hugo, Did you make sure the field contains value for it? Also, make sure to display on sale order just for assurance. If the value is stored in DB, you should be able to see. In a better practice, its always better to use a module rather than adding a field via GUI. Thanks.

Serpent Consulting Services Pvt. Ltd.
on 7/2/15, 6:42 AM

Hi, the field has values in the DB, and I can see it in the Sales Order, but for some reason is not been showed in the Graph View.

Also, If I want to use this field as an accumulated field in a Gamification Goal Definition, I get the following error when I try to activate the Challenge related to it:

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 530, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 567, in dispatch

result = self._call_function(**self.params)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 303, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper

return f(dbname, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 796, in __call__

return self.method(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 939, in call_button

action = self._call_kw(model, method, args, {})

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 927, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/addons/gamification/models/challenge.py", line 375, in action_start

return self.write(cr, uid, ids, {'state': 'inprogress'}, context=context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/addons/gamification/models/challenge.py", line 243, in write

self._generate_goals_from_challenge(cr, uid, ids, context=context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/addons/gamification/models/challenge.py", line 472, in _generate_goals_from_challenge

goal_obj.update(cr, uid, to_update, context=context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/addons/gamification/models/goal.py", line 393, in update

new_value = res and res[0][field_name] or 0.0

KeyError: u'x_MontoBaseSinImpuesto'

Hugo Pascual
on 7/2/15, 3:25 PM

Hi, I just solved the situation. Apparently the name of the field was too long, so it presented some internal problems in ODOO. I created a new field, named x_mbase, and is working perfectly in the Graph View and in Challenges. Best regards!

Hugo Pascual
on 7/3/15, 5:06 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/30/15, 9:40 AM
Seen: 300 times
Last updated: 7/3/15, 5:06 PM