176.65

v 13.0 Third Party 53
Live Preview
Required Apps Inventory (stock)
Purchase (purchase)
Invoicing (account)
Lines of code 5323
Technical Name inventory_coverage_report_ept
LicenseOPL-1
Websitehttp://www.emiprotechnologies.com
Also available in version v 10.0 v 11.0 v 12.0
You bought this module and need support? Click here!
Required Apps Inventory (stock)
Purchase (purchase)
Invoicing (account)
Lines of code 5323
Technical Name inventory_coverage_report_ept
LicenseOPL-1
Websitehttp://www.emiprotechnologies.com
Also available in version v 10.0 v 11.0 v 12.0

Inventory Coverage Report

Out of stock and Overstock these are the main headache for a business. These problems prevents business growth. To avoid such problems you must have a system to know in advance What to buy and When. It's also very important to know for next how many days your current inventory will able to fulfill your future sales demand and from which point of time it will be Out Of Stock. Inventory Coverage Report app helps you to make decision for advance purchasing, app will suggest you "What to buy and When" based on forecasted sales or past sale. This app gives you the time frame in which periods products will be out of stock and in which warehouses it's available at the same time with graphical representation.

GET INSTANT PERSONALIZED DEMO

COPY LINK http://bit.ly/icr-13-demo

or

Highlights

Forecasted Sales Report

Get the detailed forecasted sales report which helps you to analyse the future demand for products in respective warehouses.

Forecasted Sales v/s Actual Sales

Compare the forecasted sales with actual sales to wisely manage the forecasting according to the real sales.

Advance Sales Analysis Report

Get the monthly sales and average sales report for each product in each warehouse to identify the trends improving future sales by analysing monthly sales data.

Sales Forecast Rules Management

Get your forecasted rules created automatically from the past actual sales for the various periods. Additionally, import or export them as and when required.

Inventory Coverage Report

Get the Inventory Coverage Report based on Actual or Forecast Sales. In depth analysis of stock forecasting based on future sales demand and future incoming stock to notify in-stock & out-of-stock dates.

Stock Replenishment

Get the list of warehouses along with stock forecasting where the stock is availale for replenishment either fully or partially.


Recommendation of “What and When to buy”

Get the recommendation for products which needs to be replenished either from Vendor or from another warehouses.

Future Sales Data

Get the forecasted sales calculated automatically based on forecast sales rule. Additionally, you can import or export the same as and when required.

Inventory Coverage Report Configuration

Use Forecasted Sales or Actual Past Sales in calculation of Inventory Coverage

Configuring Access Rights for Users

Generate Inventory Coverage Report

Inventory Coverage Report in XLSX format

Get the Average Daily Sales Report

Manually calculate Average Daily Sales

Generate Product Recommendation report

Get Recommended Products List

Product Recommendation report

Configure Fiscal Year and Periods to generate the Inventory Coverage Report

Warehouse wise Forecasted Sales

Import Forecasted Sales From Excel file & auto-create Forecast Sales based on Rules

Warehouse wise forecasted sales rule

Import Forecast Sales Rules

Forecast Sales Analysis Report

Forecasted Sales v/s Actual Sales report

Operation Logs


Read User Guide

Yes, the app works perfectly well with Odoo Enterprise (On-premise and Odoo.SH) as well as Community. Odoo Online (Cloud) does not allow installation of third-party apps and hence this app cannot be installed on Odoo Online.

You can contact us to request a customization in the app.

If you purchase our app for Odoo Version 12 and prior, we will provide you access to all the versions up to 12 depending on their availability. Starting version 13, every version of the app will be sold separately.

We offer free support for a duration of 90 days from the date of purchase. Kindly read our support policy to know the details.

Auto Sales Forecasting will be done on the basis of Sales Forecast Rules that have been set in the configuration of this app. Sales Forecast Rules have to be defined for each period, warehouse & products.

Yes, it is possible to import or export Sales Forecasting rules as well as Sales Forecasting Data. The app lets you download a sample template from the import/export wizard and you can use this template to import Sales Forecasting Rules and Sales Forecasting Data.

While setting Sales Forecast Rules, you can select 'Product Specific Sales Ratio' if you want to define the sales ratio separately for specific products and select 'Global Ratio' if you want to define the common sales ratio for all the products. Global Ratio becomes applicable for all the products for which Specific Ratio is not defined.

It is technically possible to create a smaller period than one month, however, we do not advise you to do that as the Import/Export Sale Forecast feature will not work for a smaller period than one month.

Yes, it is mandatory to set fiscal years and periods in the configuration as it forms a basis to manage Sales Forecasting.

Yes, it is possible to see In-Stock and Out-of-Stock products together in the same report as well as in separate reports. Also, you can see if certain products are Out-of-Stock in a particular warehouse but In-Stock in another warehouse so that you can perform an Internal Transfer instead of purchasing them from the vendor.

Out of Stock Ratio helps in deciding which products will be listed in the Product Recommendation report that is generated in this app.

Yes. You can get the real-time data of Average Daily Sales report. Just navigate to Inventory / Advance Purchase Ordering / Calculate Average Daily Sale and click on Calculate button.

Product Recommendation Report contains the list of products which will be out of stock in particular warehouses and based on the report, the reorder process records will be directly created. This report helps in deciding what to buy.

Suggested Products

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

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.
?
by
tim@azoo.com.tw
on 6/8/20, 10:20 AM

?


Unavailable, no numbers reported
by
tim@azoo.com.tw
on 5/28/20, 7:01 PM Confirmed Purchase

錯誤: Odoo Server Error Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 349, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in File "/home/odoo/src/user/inventory_coverage_report_ept/models/product_average_daily_sale.py", line 160, in calculate_average_daily_sales_using_cron self._cr.execute(query) File "/home/odoo/src/odoo/odoo/sql_db.py", line 164, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/sql_db.py", line 241, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: function add_update_product_ads_data() does not exist LINE 1: select add_update_product_ads_data(); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/http.py", line 624, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/odoo/src/odoo/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/home/odoo/src/odoo/odoo/tools/pycompat.py", line 14, in reraise raise value File "/home/odoo/src/odoo/odoo/http.py", line 669, in dispatch result = self._call_function(**self.params) File "/home/odoo/src/odoo/odoo/http.py", line 350, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/odoo/src/odoo/odoo/service/model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "/home/odoo/src/odoo/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, **kw) File "/home/odoo/src/odoo/odoo/http.py", line 915, in __call__ return self.method(*args, **kw) File "/home/odoo/src/odoo/odoo/http.py", line 515, in response_wrap response = f(*args, **kw) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1326, in call_button action = self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1314, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 387, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 374, in _call_kw_multi result = method(recs, *args, **kwargs) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_cron.py", line 83, in method_direct_trigger self.with_user(cron.user_id).ir_actions_server_id.run() File "/home/odoo/src/odoo/odoo/addons/base/models/ir_actions.py", line 545, in run res = func(action, eval_context=eval_context) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_actions.py", line 430, in run_action_code_multi safe_eval(action.sudo().code.strip(), eval_context, mode="exec", nocopy=True) # nocopy allows to return 'action' File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 372, in safe_eval pycompat.reraise(ValueError, ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)), exc_info[2]) File "/home/odoo/src/odoo/odoo/tools/pycompat.py", line 13, in reraise raise value.with_traceback(tb) File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 349, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in File "/home/odoo/src/user/inventory_coverage_report_ept/models/product_average_daily_sale.py", line 160, in calculate_average_daily_sales_using_cron self._cr.execute(query) File "/home/odoo/src/odoo/odoo/sql_db.py", line 164, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/sql_db.py", line 241, in execute res = self._obj.execute(query, params) ValueError: : "function add_update_product_ads_data() does not exist LINE 1: select add_update_product_ads_data(); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. " while evaluating 'model.calculate_average_daily_sales_using_cron()'


Unavailable, no numbers reported
by
tim@azoo.com.tw
on 5/28/20, 10:12 AM Confirmed Purchase

錯誤: Odoo Server Error Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 349, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in File "/home/odoo/src/user/inventory_coverage_report_ept/models/product_average_daily_sale.py", line 160, in calculate_average_daily_sales_using_cron self._cr.execute(query) File "/home/odoo/src/odoo/odoo/sql_db.py", line 164, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/sql_db.py", line 241, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: function add_update_product_ads_data() does not exist LINE 1: select add_update_product_ads_data(); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/http.py", line 624, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/odoo/src/odoo/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/home/odoo/src/odoo/odoo/tools/pycompat.py", line 14, in reraise raise value File "/home/odoo/src/odoo/odoo/http.py", line 669, in dispatch result = self._call_function(**self.params) File "/home/odoo/src/odoo/odoo/http.py", line 350, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/odoo/src/odoo/odoo/service/model.py", line 94, in wrapper return f(dbname, *args, **kwargs) File "/home/odoo/src/odoo/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, **kw) File "/home/odoo/src/odoo/odoo/http.py", line 915, in __call__ return self.method(*args, **kw) File "/home/odoo/src/odoo/odoo/http.py", line 515, in response_wrap response = f(*args, **kw) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1326, in call_button action = self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1314, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 387, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 374, in _call_kw_multi result = method(recs, *args, **kwargs) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_cron.py", line 83, in method_direct_trigger self.with_user(cron.user_id).ir_actions_server_id.run() File "/home/odoo/src/odoo/odoo/addons/base/models/ir_actions.py", line 545, in run res = func(action, eval_context=eval_context) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_actions.py", line 430, in run_action_code_multi safe_eval(action.sudo().code.strip(), eval_context, mode="exec", nocopy=True) # nocopy allows to return 'action' File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 372, in safe_eval pycompat.reraise(ValueError, ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)), exc_info[2]) File "/home/odoo/src/odoo/odoo/tools/pycompat.py", line 13, in reraise raise value.with_traceback(tb) File "/home/odoo/src/odoo/odoo/tools/safe_eval.py", line 349, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in File "/home/odoo/src/user/inventory_coverage_report_ept/models/product_average_daily_sale.py", line 160, in calculate_average_daily_sales_using_cron self._cr.execute(query) File "/home/odoo/src/odoo/odoo/sql_db.py", line 164, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/sql_db.py", line 241, in execute res = self._obj.execute(query, params) ValueError: : "function add_update_product_ads_data() does not exist LINE 1: select add_update_product_ads_data(); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. " while evaluating 'model.calculate_average_daily_sales_using_cron()'


BAD Company! Bad module
by
Olaf Peters / Variosports GmbH
on 3/11/20, 2:54 AM

First of all - the module is worthless because it is far away from giving usefull information. I have started 2016 with Emipro and they have evolved into a real bad face company. In the beginning they had been quite good developer who taking care but very soon they have educated the new stuff with clients but charge them. I have helped them a lot to understand business better and to solve their issues in the modules (I bought a lot of modules from them) and in the end they try to squeez everything out of me. Once they know they are in a good position they will show up with their real face - money money money. They have made many promises and in the end don`t fullfiled them. I can not recomment to work with them. Espacially if you are from Europe you can not use them because they are not taking care of GDPR. Just ask them to sign the standard EU contract.

Re: BAD Company! Bad module
by
Emipro Technologies Pvt. Ltd.
on 3/12/20, 7:36 AM Author

Dear Olaf, Emipro is a reputed Odoo Gold Partner, and we are working with hundreds of customers across the globe. We are always committed to offer the best services and solutions to our customer and never ask a customer to pay unreasonably for any of our services. Most importantly, we always ensure all necessary formalities when it comes to compliance with various international laws, including Europe's GDPR and signing of non-disclosures to protect our customer's data.