I have Odoo Community source version installed, which shows an error when clicking on sequence. The error is listed below.
Initially I did not have such errors and had succefully set the sequence for Purchase Orders. Now I need to change the Sequence for Sales Order but I am unable to do it.
When I accessed the database thru PGAdmin 4 I was able to change the Prefix and next increment number from the ir_sequence table. It changed the prefix but I am not able to change the next increment number.
I do not want to reinstall the Odoo and redo all the changes in the database. Please let me know whether the next increment number in the sequence(sales order) can be changed using PGadmin.
https://github.com/odoo/odoo/issues/20269 This link also shows up such message received elsewhere who is using postgresl 10. I too have upgraded the database to Postgresql 10. Hope it is not causing such issue. Is it possible to downgrade if postgresql version is the issue.
Traceback (most recent call last): File "/odoon/odoon-server/odoo/http.py", line 640, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/odoon/odoon-server/odoo/http.py", line 677, in dispatch result = self._call_function(**self.params) File "/odoon/odoon-server/odoo/http.py", line 333, in _call_function return checked_call(self.db, *args, **kwargs) File "/odoon/odoon-server/odoo/service/model.py", line 101, in wrapper return f(dbname, *args, **kwargs) File "/odoon/odoon-server/odoo/http.py", line 326, in checked_call result = self.endpoint(*a, **kw) File "/odoon/odoon-server/odoo/http.py", line 935, in __call__ return self.method(*args, **kw) File "/odoon/odoon-server/odoo/http.py", line 506, in response_wrap response = f(*args, **kw) File "/odoon/odoon-server/addons/web/controllers/main.py", line 827, in search_read return self.do_search_read(model, fields, offset, limit, domain, sort) File "/odoon/odoon-server/addons/web/controllers/main.py", line 849, in do_search_read offset=offset or 0, limit=limit or False, order=sort or False) File "/odoon/odoon-server/odoo/models.py", line 4695, in search_read result = records.read(fields) File "/odoon/odoon-server/odoo/models.py", line 3021, in read values[name] = field.convert_to_read(record[name], record, use_name_get) File "/odoon/odoon-server/odoo/models.py", line 5210, in __getitem__ return self._fields[key].__get__(self, type(self)) File "/odoon/odoon-server/odoo/fields.py", line 870, in __get__ self.determine_value(record) File "/odoon/odoon-server/odoo/fields.py", line 982, in determine_value self.compute_value(recs) File "/odoon/odoon-server/odoo/fields.py", line 936, in compute_value self._compute_value(records) File "/odoon/odoon-server/odoo/fields.py", line 927, in _compute_value getattr(records, self.compute)() File "/odoon/odoon-server/odoo/addons/base/ir/ir_sequence.py", line 79, in _get_number_next_actual self._cr.execute(query) File "/odoon/odoon-server/odoo/sql_db.py", line 154, in wrapper return f(self, *args, **kwargs) File "/odoon/odoon-server/odoo/sql_db.py", line 231, in execute res = self._obj.execute(query, params) ProgrammingError: column "increment_by" does not exist LINE 1: SELECT last_value, increment_by, is_called FROM ir_sequence_... ^
Finally after lot of work around and searches I was able to solve the set my Sales quotation sequence correctly by changing the current value of ir_sequence_042.
Still the above error exits but it is now not affecting my work.