| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase Management (purchase)
• Inventory Management (stock) • Invoicing (account) • Discuss (mail) |
| Technical Name |
purchase_order_xlsx |
| License | AGPL-3 |
| Website | https://www.pptssolutions.com |
| Versions | 10.0 11.0 12.0 13.0 14.0 15.0 |
PURCHASE ORDER EXCEL REPORTS
In this Report you can download the both CSV and Excel reports you can use "Libra Office" only.
Step 1:
Select Purchase list records click on Action and click the "Purchase order Excel Report" button.
Step 2:
Once button clicked now you are able to see the wizard and click the "Print Excel Report"button.
Step 3:
The "Purchase Excel Report" file will appear and download it.
Step 4:
Now you can see the purchase order excel sheet.
Step 5:
In excel sheet you can see the multiple of purchase order excel reports.
Step 6:
Once button clicked now you are able to see the wizard and click the "Print Excel Report"button.
Step 7:
The"Purchase CSV Report"file will appear and download it.
Step 8:
In Excel sheet you can see the purchase csv reports
Looking for support? We are here to help you!
As an official Odoo Gold Partner, PPTS, with its 9+ years of Expertise and Experienced niche in Odoo Projects, can assist you in enhancing your business processes and work system by automating and streamlining the business functionalities through the advanced and customized latest technological solutions.
Our Odoo Services
Odoo ERP Implementation
Odoo ERP Customization
Odoo ERP Integration
Odoo ERP Migration
Odoo ERP Support
Other Services
- Artificial Intelligence
- Data Analytics
- Web Application Development
- Mobile Application Development
Feel free to contact us for any queries
Contact Us Now
Stay Connected with Us! Let's Grow Together!
Email us to: gsdsubscription@pptservices.com
Explore more about us: www.pptssolutions.com
Please log in to comment on this module
Which package do I need
Thanks for your answer, would you mind tell me which exact package do I need. I already have xlwt installed.
I got below error on download report. Please let me know how can i resolve it from Front end ? Traceback (most recent call last): File "/opt/odoo/server_v11_latest/odoo/http.py", line 651, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo/server_v11_latest/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo/server_v11_latest/odoo/http.py", line 693, in dispatch result = self._call_function(**self.params) File "/opt/odoo/server_v11_latest/odoo/http.py", line 342, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/odoo/server_v11_latest/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/opt/odoo/server_v11_latest/odoo/http.py", line 335, in checked_call result = self.endpoint(*a, **kw) File "/opt/odoo/server_v11_latest/odoo/http.py", line 937, in __call__ return self.method(*args, **kw) File "/opt/odoo/server_v11_latest/odoo/http.py", line 515, in response_wrap response = f(*args, **kw) File "/opt/odoo/server_v11_latest/odoo/addons/web/controllers/main.py", line 938, in call_button action = self._call_kw(model, method, args, {}) File "/opt/odoo/server_v11_latest/odoo/addons/web/controllers/main.py", line 926, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/server_v11_latest/odoo/api.py", line 689, in call_kw return call_kw_multi(method, model, args, kwargs) File "/opt/odoo/server_v11_latest/odoo/api.py", line 680, in call_kw_multi result = method(recs, *args, **kwargs) File "/opt/odoo/sanmarg_custom_addons/sanmarg_addons/purchase_order_xlsx/wizard/purchase_xls.py", line 47, in action_purchase_report product ['taxes_id'] = line.taxes_id.name File "/opt/odoo/server_v11_latest/odoo/fields.py", line 938, in __get__ record.ensure_one() File "/opt/odoo/server_v11_latest/odoo/models.py", line 4393, in ensure_one raise ValueError("Expected singleton: %s" % self) ValueError: Expected singleton: account.tax(48, 49)
I too got the same error. What might be the issues. "/odoo/custom/addons/purchase_order_xlsx/wizard/purchase_xls.py", line 144, in action_purchase_report workbook.save(filename) File "/usr/lib/python2.7/dist-packages/xlwt/Workbook.py", line 662, in save doc.save(filename, self.get_biff_data()) File "/usr/lib/python2.7/dist-packages/xlwt/CompoundDoc.py", line 261, in save f = open(file_name_or_filelike_obj, 'w+b') IOError: [Errno 13] Permission denied: 'Purchase Report.xls'
Okay, then please check the addons folder whether it has full permission. If it has full permission, please Email us your Odoo Log with the screen shot to the above given email address. Feel free to contact us. Thank you.
Hi Frank Miao, Please check the relevant xlsx python packages are already installed in your system, if you don't have, please install and check it.
I got error when I click PRINT EXCEL REPORT BUTTON
I got the following error when I click the PRINT EXCEL REPORT button: File "/odoo/custom/addons/purchase_order_xlsx/wizard/purchase_xls.py", line 144, in action_purchase_report workbook.save(filename) File "/usr/lib/python2.7/dist-packages/xlwt/Workbook.py", line 662, in save doc.save(filename, self.get_biff_data()) File "/usr/lib/python2.7/dist-packages/xlwt/CompoundDoc.py", line 261, in save f = open(file_name_or_filelike_obj, 'w+b') IOError: [Errno 13] Permission denied: 'Purchase Report.xls'