| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory Management (stock)
• Purchase Management (purchase) • Sales Management (sale_management) • Discuss (mail) • Invoicing Management (account_invoicing) |
| Community Apps Dependencies | Show |
| Lines of code | 411 |
| Technical Name |
export_stockinfo_xls |
| License | AGPL-3 |
| Website | https://www.cybrosys.com |
| Versions | 16.0 9.0 10.0 11.0 12.0 14.0 17.0 8.0 13.0 15.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory Management (stock)
• Purchase Management (purchase) • Sales Management (sale_management) • Discuss (mail) • Invoicing Management (account_invoicing) |
| Community Apps Dependencies | Show |
| Lines of code | 411 |
| Technical Name |
export_stockinfo_xls |
| License | AGPL-3 |
| Website | https://www.cybrosys.com |
| Versions | 16.0 9.0 10.0 11.0 12.0 14.0 17.0 8.0 13.0 15.0 |
Current Stock XLS
Current Stock Report for all Products in each Warehouse
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.
Our Services
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.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedError
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'
Thanks
I tested in Ubuntu 16, nice work, thanks a lot.
Useful
Thanks
It's Work Fine
you should Configure Timezone in User Preference Menu to Solve Error..
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
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
Can't export
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