Export Product Stock in Excel

by
Odoo 3
v 11.0 Third Party 8709
Download for 11.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
Read description for v 12.0 v 10.0 v 9.0 v 8.0
Required Apps Inventory Management (stock)
Purchase Management (purchase)
Sales (sale)
Invoicing (account)
Included Dependencies
Technical name export_stockinfo_xls
LicenseAGPL-3
Websitehttps://www.cybrosys.com
Read description for v 12.0 v 10.0 v 9.0 v 8.0
Required Apps Inventory Management (stock)
Purchase Management (purchase)
Sales (sale)
Invoicing (account)
Included Dependencies

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

  • This section is meant to ask simple questions or leave a rating.
  • This author can leave a single reply to each comment.
  • 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
It's Work Fine
by on

you should Configure Timezone in User Preference Menu to Solve Error..


Odoo
Error
by on

Hi, I am getting the error with the UTC date. Is there a solution for this? File "C:\Program Files\Odoo 11.0\server\odoo\custom_addons\report_xlsx\models\ir_report.py", line 21, in render_xlsx }).create_xlsx_report(docids, data) File "C:\Program Files\Odoo 11.0\server\odoo\custom_addons\report_xlsx\report\report_xlsx.py", line 46, in create_xlsx_report self.generate_xlsx_report(workbook, data, objs) File "C:\Program Files\Odoo 11.0\server\odoo\custom_addons\export_stockinfo_xls\report\current_stock_xls.py", line 102, in generate_xlsx_report tz = pytz.timezone(user.tz) File "C:\Program Files\Odoo 11.0\python\lib\site-packages\pytz\__init__.py", line 163, in timezone if zone.upper() == 'UTC': AttributeError: 'bool' object has no attribute 'upper'


Odoo
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. undefined
by on

Below is the error from odoo log, plz advice File "/usr/local/lib/python3.5/dist-packages/pytz/__init__.py", line 159, in timezone if zone.upper() == 'UTC': AttributeError: 'bool' object has no attribute 'upper


Odoo
Can't export
by on

I've got the following error, other excel exports work fine, any suggestion? Erreur: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. undefined


Odoo
Thanks
by on

I tested in Ubuntu 16, nice work, thanks a lot.


Odoo
Useful
by on

Thanks