Export Product Stock in Excel

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

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.
Odoo
Error on V13
by on

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)