v 13.0 Third Party 10078
Download for 13.0 series Deploy on Odoo.sh
Required Apps Inventory (stock)
Purchase (purchase)
Invoicing (account)
Technical Name export_stockinfo_xls
LicenseAGPL-3
Websitehttps://www.cybrosys.com
Also available in version v 11.0 v 12.0 v 9.0 v 10.0 v 8.0 v 13.0
You bought this module and need support? Click here!
Required Apps Inventory (stock)
Purchase (purchase)
Invoicing (account)
Technical Name export_stockinfo_xls
LicenseAGPL-3
Websitehttps://www.cybrosys.com
Also available in version v 11.0 v 12.0 v 9.0 v 10.0 v 8.0 v 13.0

Current Stock XLS

Current Stock Report for all Products in each Warehouse

Cybrosys Technologies
cybrosys technologies

Overview

This module helps to print Current Stock Report for all Products in each Warehouse with XLS.

Installation

To install this module, you need also the report_xlsx module.

You need to set the Timezone in odoo.

Features

Select category for products

Get your stock valuation details

Negative stock will be highlighted in "red" cells.

Screenshots

Go to Inventory -> Reports -> Current stock in Excel.
Now a wizard will appear on your screen. Please enter the warehouses which you want to take the report.
You can also select category for products(It is Optional).
Then Click "Export Product with Stock Info" button. Then You will get the corresponding report in XLS.


Per warehouse you can get Available Qty, Virtual Qty, Incoming Qty, Outgoing Qty, Net On Hand Qty, Total Sold & Total Purchased Qty.
You can get your stock valuation details too. In below screen-shot you can see stock details of 2 warehouse exported in single spreadsheet.


Negative stock will be highlighted in "red" cells.


cybrosys technologies

Our Industries

Trading

Easily procure and sell your products.

Manufacturing

Plan, track and schedule your operations.

Restaurant

Run your bar or restaurant methodical.

POS

Easy configuring and convivial selling.

E-commerce & Website

Mobile friendly, awe-inspiring product pages.

Hotel Management

An all-inclusive hotel management application.

Education

A Collaborative platform for educational management.

Service Management

Keep track of services and invoice accordingly.

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.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
I get error on click "Export Product with Stock Info" button
by
Luis Rodriguez
on 2/13/20, 11:43 AM

Error: Odoo Server Error Traceback (most recent call last): File "/home/luis/addons/export_stockinfo_xls/controllers/main.py", line 46, in get_report_xlsx report_obj.get_xlsx_report(options, response) File "/home/luis/addons/export_stockinfo_xls/models/wizard.py", line 166, in get_xlsx_report tz = pytz.timezone(user.tz) File "/opt/bitnami/python/lib/python3.7/site-packages/pytz-2016.7-py3.7.egg/pytz/__init__.py", line 163, in timezone if zone.upper() == 'UTC': AttributeError: 'bool' object has no attribute 'upper'


Error on V13
by
Usman Farzand
on 11/28/19, 4:50 AM

Odoo Server Error Traceback (most recent call last): File "/opt/odoo13/odoo/odoo/http.py", line 619, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo13/odoo/odoo/http.py", line 309, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo13/odoo/odoo/tools/pycompat.py", line 14, in reraise raise value File "/opt/odoo13/odoo/odoo/http.py", line 664, in dispatch result = self._call_function(**self.params) File "/opt/odoo13/odoo/odoo/http.py", line 345, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/odoo13/odoo/odoo/service/model.py", line 93, in wrapper return f(dbname, *args, **kwargs) File "/opt/odoo13/odoo/odoo/http.py", line 338, in checked_call result = self.endpoint(*a, **kw) File "/opt/odoo13/odoo/odoo/http.py", line 909, in __call__ return self.method(*args, **kw) File "/opt/odoo13/odoo/odoo/http.py", line 510, in response_wrap response = f(*args, **kw) File "/opt/odoo13/odoo/addons/web/controllers/main.py", line 1323, in call_button action = self._call_kw(model, method, args, kwargs) File "/opt/odoo13/odoo/addons/web/controllers/main.py", line 1311, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo13/odoo/odoo/api.py", line 395, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/opt/odoo13/odoo/odoo/api.py", line 382, in _call_kw_multi result = method(recs, *args, **kwargs) File "/opt/odoo13/odoo-custom-addons/export_stockinfo_xls/models/wizard.py", line 62, in export_xls 'warehouse': self.warehouse.id, File "/opt/odoo13/odoo/odoo/fields.py", line 3457, in __get__ raise ValueError("Expected singleton: %s" % record) ValueError: Expected singleton: stock.warehouse(1, 2, 4)