Skip to Content

Sales Hourly Report

by
Odoo

$ 17.12

v 14.0 Third Party 9
Versions 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Sales (sale_management)
• Discuss (mail)
• Invoicing (account)
Lines of code 97
Technical Name sale_hourly_report
Versions 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0

Sales Hourly Report

Get the sales report by hours

Few Words About The Sales Hourly Report:

This module gives you the an option to get hourly sales order reports, which means which orders are placed in a particular hour.

Work Flow: How the "Sales Hourly Report" works
Here in the Sale pivot report option you get the extra option for row or column:
  • i.e. Order in Hour
Set Column:
  • Select Order Date as column and select day a interval for date
Set Row:
  • Select Order in Hour as row
Report: Pivot View

If You Need Any Help Please Contact

Email Id: erpmstra@gmail.com

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 or have a question related to your purchase, please use the support page.
There are no ratings yet!
Hi , your module does not work with margin measures when it is install, here the error code : Error: Odoo Server Error Traceback (most recent call last): File "M:\Odoo\server\odoo\addons\base\models\ir_http.py", line 237, in _dispatch result = request.dispatch() File "M:\Odoo\server\odoo\http.py", line 684, in dispatch result = self._call_function(**self.params) File "M:\Odoo\server\odoo\http.py", line 360, in _call_function return checked_call(self.db, *args, **kwargs) File "M:\Odoo\server\odoo\service\model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "M:\Odoo\server\odoo\http.py", line 348, in checked_call result = self.endpoint(*a, **kw) File "M:\Odoo\server\odoo\http.py", line 913, in __call__ return self.method(*args, **kw) File "M:\Odoo\server\odoo\http.py", line 532, in response_wrap response = f(*args, **kw) File "M:\Odoo\server\odoo\addons\web\controllers\main.py", line 1389, in call_kw return self._call_kw(model, method, args, kwargs) File "M:\Odoo\server\odoo\addons\web\controllers\main.py", line 1381, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "M:\Odoo\server\odoo\api.py", line 392, in call_kw result = _call_kw_model(method, model, args, kwargs) File "M:\Odoo\server\odoo\api.py", line 365, in _call_kw_model result = method(recs, *args, **kwargs) File "M:\Odoo\server\odoo\models.py", line 2248, in read_group result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy) File "M:\Odoo\server\odoo\models.py", line 2375, in _read_group_raw self._cr.execute(query, where_clause_params) File "<decorator-gen-3>", line 2, in execute File "M:\Odoo\server\odoo\sql_db.py", line 101, in check return f(self, *args, **kwargs) File "M:\Odoo\server\odoo\sql_db.py", line 298, in execute res = self._obj.execute(query, params) Exception The above exception was the direct cause of the following exception: Traceback (most recent call last): File "M:\Odoo\server\odoo\http.py", line 640, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "M:\Odoo\server\odoo\http.py", line 316, in _handle_exception raise exception.with_traceback(None) from new_cause psycopg2.errors.UndefinedColumn: column sale_report.margin does not exist LINE 2: ...report"."price_subtotal") AS "price_subtotal",sum("sale_repo... ^
by
drissa
on 8/25/24, 9:03 AM


Re: Hi , your module does not work with margin measures when it is install, here the error code : Error: Odoo Server Error Traceback (most recent call last): File "M:\Odoo\server\odoo\addons\base\models\ir_http.py", line 237, in _dispatch result = request.dispatch() File "M:\Odoo\server\odoo\http.py", line 684, in dispatch result = self._call_function(**self.params) File "M:\Odoo\server\odoo\http.py", line 360, in _call_function return checked_call(self.db, *args, **kwargs) File "M:\Odoo\server\odoo\service\model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "M:\Odoo\server\odoo\http.py", line 348, in checked_call result = self.endpoint(*a, **kw) File "M:\Odoo\server\odoo\http.py", line 913, in __call__ return self.method(*args, **kw) File "M:\Odoo\server\odoo\http.py", line 532, in response_wrap response = f(*args, **kw) File "M:\Odoo\server\odoo\addons\web\controllers\main.py", line 1389, in call_kw return self._call_kw(model, method, args, kwargs) File "M:\Odoo\server\odoo\addons\web\controllers\main.py", line 1381, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "M:\Odoo\server\odoo\api.py", line 392, in call_kw result = _call_kw_model(method, model, args, kwargs) File "M:\Odoo\server\odoo\api.py", line 365, in _call_kw_model result = method(recs, *args, **kwargs) File "M:\Odoo\server\odoo\models.py", line 2248, in read_group result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy) File "M:\Odoo\server\odoo\models.py", line 2375, in _read_group_raw self._cr.execute(query, where_clause_params) File "<decorator-gen-3>", line 2, in execute File "M:\Odoo\server\odoo\sql_db.py", line 101, in check return f(self, *args, **kwargs) File "M:\Odoo\server\odoo\sql_db.py", line 298, in execute res = self._obj.execute(query, params) Exception The above exception was the direct cause of the following exception: Traceback (most recent call last): File "M:\Odoo\server\odoo\http.py", line 640, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "M:\Odoo\server\odoo\http.py", line 316, in _handle_exception raise exception.with_traceback(None) from new_cause psycopg2.errors.UndefinedColumn: column sale_report.margin does not exist LINE 2: ...report"."price_subtotal") AS "price_subtotal",sum("sale_repo... ^
by
ErpMstra Softwar
on 8/26/24, 2:53 AM Author

Hi,

Please contact me by my email id erpmstra@gmail.com for proper discussion.

Thanks

SO2022/2826326 , DOES NOT WORK
by
drissa
on 5/8/23, 2:15 PM

Please I just bought your module, and i can not install i got this error message ; i have odoo 14 community


Error:
Odoo Server Error

Traceback (most recent call last):
  File "M:\Server_Odoo\server\odoo\addons\base\models\ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "M:\Server_Odoo\server\odoo\http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "M:\Server_Odoo\server\odoo\http.py", line 360, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "M:\Server_Odoo\server\odoo\service\model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "M:\Server_Odoo\server\odoo\http.py", line 348, in checked_call
    result = self.endpoint(*a, **kw)
  File "M:\Server_Odoo\server\odoo\http.py", line 913, in __call__
    return self.method(*args, **kw)
  File "M:\Server_Odoo\server\odoo\http.py", line 532, in response_wrap
    response = f(*args, **kw)
  File "M:\Server_Odoo\server\odoo\addons\web\controllers\main.py", line 1393, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "M:\Server_Odoo\server\odoo\addons\web\controllers\main.py", line 1381, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "M:\Server_Odoo\server\odoo\api.py", line 396, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "M:\Server_Odoo\server\odoo\api.py", line 383, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "", line 2, in button_immediate_install
  File "M:\Server_Odoo\server\odoo\addons\base\models\ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "M:\Server_Odoo\server\odoo\addons\base\models\ir_module.py", line 475, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "M:\Server_Odoo\server\odoo\addons\base\models\ir_module.py", line 593, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "M:\Server_Odoo\server\odoo\modules\registry.py", line 89, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "M:\Server_Odoo\server\odoo\modules\loading.py", line 460, in load_modules
    loaded_modules, update_module, models_to_check)
  File "M:\Server_Odoo\server\odoo\modules\loading.py", line 348, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "M:\Server_Odoo\server\odoo\modules\loading.py", line 198, in load_module_graph
    registry.init_models(cr, model_names, {'module': package.name}, new_install)
  File "M:\Server_Odoo\server\odoo\modules\registry.py", line 420, in init_models
    env['base'].flush()
  File "M:\Server_Odoo\server\odoo\models.py", line 5432, in flush
    self.recompute()
  File "M:\Server_Odoo\server\odoo\models.py", line 5891, in recompute
    process(field)
  File "M:\Server_Odoo\server\odoo\models.py", line 5875, in process
    field.recompute(recs)
  File "M:\Server_Odoo\server\odoo\fields.py", line 1153, in recompute
    self.compute_value(recs)
  File "M:\Server_Odoo\server\odoo\fields.py", line 1175, in compute_value
    records._compute_field_value(self)
  File "M:\Server_Odoo\server\odoo\addons\sale\models\sale.py", line 514, in _compute_field_value
    super()._compute_field_value(field)
  File "M:\Server_Odoo\server\odoo\addons\mail\models\mail_thread.py", line 410, in _compute_field_value
    return super()._compute_field_value(field)
  File "M:\Server_Odoo\server\odoo\models.py", line 4057, in _compute_field_value
    getattr(self, field.compute)()
  File "c:\users\chahu\appdata\local\openerp s.a\odoo\addons\14.0\sale_hourly_report\models\models.py", line 43, in compute_order_date_time
    user_time_zone = pytz.timezone(self.env.user.partner_id.tz)
  File "M:\Server_Odoo\python\lib\site-packages\pytz\__init__.py", line 163, in timezone
    if zone.upper() == 'UTC':
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "M:\Server_Odoo\server\odoo\http.py", line 640, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "M:\Server_Odoo\server\odoo\http.py", line 316, in _handle_exception
    raise exception.with_traceback(None) from new_cause
AttributeError: 'bool' object has no attribute 'upper'

RépondreTransférer