I'd like to create my own report form and I've been trying to find the field that would properly display the subtotal, taxes and total of the purchase order using the "Subtotal & Total" widget available in Odoo Studio. However I am unable to find a corresponding field that would show the correct value of the selected Purchase Order. As almost every option just goes furhter down the rabbit hole.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
3464
Views
You just create a new report on Purchase Order using Odoo studio and then drag the "Subtotal & Total" field and select doc (Purchase Order) only. Screenshot on link below.
https://www.awesomescreenshot.com/image/21831882?key=4e4ccfabe1dfe844446379be02cb028d
I did it in the Purchase report with no problem at all ..
But I need to do it in Sales/Quotation Report .. in here I am facing problem ..
I made a Screenshot please check what I am doing wrong?
https://watch.screencastify.com/v/0sbUfwHfXCfxJCVbH1Kn
I made the same thing with Quotation report "Blank" and I drag and drop the Subtotal $ Total into the page same as you made .. but an error comes:
Error when compiling AST
<pre>'sale.order' object has no attribute 'amount_by_group' Traceback (most recent call last): File "/home/odoo/src/odoo/15.0/odoo/addons/base/models/qweb.py", line 219, in render_template yield from compiled_fn(self, values, log) File "<template_4335>", line 119, in template_4335 AttributeError: 'sale.order' object has no attribute 'amount_by_group' Error when render the template AttributeError: 'sale.order' object has no attribute 'amount_by_group' Template: studio_customization.studio_report_docume_c1b89cd0-6d5d-4c3c-9b52-285734812c30_document Path: /t/div/div/div[2]/table/t[4] Node: <t t-set="total_amount_by_groups" t-value="doc.amount_by_group" data-oe-id="4335" data-oe-xpath="/t/div/div/div[2]/table/t[4]"/> </pre>
Thanks .. waiting for your reply.
the issue is with amount_by_group - if you have sales orders with sections it will cause this issue. Investigating more ....
If you get any answer please help me..