29.77

v 10.0 v 11.0 v 12.0 Third Party
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
LicenseAGPL-3
Websitehttps://www.pptssolutions.com
Versions 10.0 11.0 12.0 13.0 14.0 15.0
You bought this module and need support? Click here!
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
LicenseAGPL-3
Websitehttps://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: ocasupport@pptservices.com

Explore more about us: www.pptssolutions.com

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 or have a question related to your purchase, please use the support page.
Which package do I need
by
Frank Miao
on 5/17/18, 1:46 AM

Thanks for your answer, would you mind tell me which exact package do I need. I already have xlwt installed.


by
Deepshikha
on 9/13/19, 3:04 AM

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)


by
utshav ghimire
on 7/10/19, 2:23 AM

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'


by
Suresh
on 5/18/18, 1:14 AM Author

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.


by
Suresh
on 5/16/18, 9:01 AM Author

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
by
Frank Miao
on 5/3/18, 11:53 AM

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'