| Required Apps |
•
Inventory (stock)
• Purchase (purchase) • Invoicing (account) |
| Lines of code | 317 |
| Technical Name |
export_stockinfo_xls |
| License | AGPL-3 |
| Website | https://www.cybrosys.com |
| Also available in version | v 11.0 v 14.0 v 12.0 v 16.0 v 8.0 v 9.0 v 10.0 v 15.0 |
Current Stock XLS
Current Stock Report for all Products in each Warehouse
Key Highlights
- Select category for products
- Get your stock valuation details
- Negative stock will be highlighted in "red" cells.
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.
Current Stock XLS
- 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.
Suggested Products
Our Service
Odoo Customization
Odoo Implementation
Odoo Integration
Odoo Support
Hire Odoo Developers
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.
Need Any Help?
If you have anything to share with us based on your use of this module, please let us know. We are ready to offer our support.
Email us
odoo@cybrosys.com
Contact Us
www.cybrosys.com
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThere are no ratings yet!
Hi,
Any update related to adding the product variants to the excel report?
Thank you
Can we add Product Image
Hi,
The excel report generated one is good. Can we add Product Image?? Can we add couple of things like Date filter?? Details of PO & SO etc...
Regards,
Suneel
Hi,
Thank you for the efforts and for providing this module for free.
I have tested it and it is usefull, it might be awesome to have it list the product variants too.
Have a nice day.
Re:
Thanks for your suggestion. We will try to Include in next update
Can we add Location in this report please?
Hello. Is it tested and works in Odoo 13 Enterprise? Thank you.
I get error on click "Export Product with Stock Info" button
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
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)