Show product categories on invoice

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

Show product categories on invoice

python invoice qweb custom quantity

1 Balas

5369 Tampilan

Cornelius Kraus

Hello guys,

I started Odoo development few months ago and set up my own module where I added some fields, edited views and defined actions.

Now I am facing a big challenge and do not know how to start. I should add a frontpage to the printed out invoice where you can see the invoiced positions but filtered by their category.

For example, the categories are "ESX", "EXT" and "COLOR", there should be a frontpage of the invoice where you can see how many products of which category are invoiced, so it should be like
"ESX, 37 products invoiced, 69$ total"

"EXT, 42 products invoiced, 99$ total" and so on.

Is it possible to sum the quantities of products with the same category directly in qweb or has it to be done in python? How to declare the function that computes quantities for only one product category?

I appreciate any answer.

Thanks for your help in advance

Sincerely

Nils Kraus

Cornelius Kraus

Penulis Jawaban Terbai

I got it! If anyone is also wondering how to this, I did it within my custom module.
First of all, you have to create two new fields in python code. The first in the model "sale.order.line" which gets the category of the product model. It should look like this:

x_category_on_saleorderline = fields.Many2one(related="product_id.categ_id")

Now we have the field on the sale.order.line so we can process it to the invoice by creating another related field on the model "account.move.line". This should look like following:

x_category_on_invoiceline = fields.Many2one(related='sale_line_ids.xcategory_on_saleorderline')

Now we can add the field to the invoice QWeb template and even filter it there. For example, to get the summed up quantities for one category I did it like:

<span t-esc="int(sum(line.quantity for line in lines.filtered(lambda r: r.x_category_on_invoiceline.name == '[name of category]')))"/>

Don't mind to contact me if you have any questions regarding this.

Bruno Rocha

Hello Cornelius,

One question, can this be done via Studio? (Create the related fields, I don't know if the model info is available or not)

Cornelius Kraus

Penulis

Hello Bruno, I am not sure. Sorry, I don't know much about Studio. If you are able to, just do it directly in the code behind.

houda

Hi Cornelius

i have a question should i related field to model ?

Thanks for your help in advance

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
how to pass data to exiting qweb report invoice xml qweb custom	1 Sep 23	3201
Print Invoice with 10 lines per pages Diselesaikan python invoice qweb print templates	2 Okt 19	8849
How can I calculate all discounts applied in an invoice and print the value as a separate field? Diselesaikan python invoice discount qweb report	1 Okt 15	7853
Custom qweb report from sql view showing empty qweb custom	2 Jan 20	8964
Issue with a new Product Label Template (102x102) in Odoo V17 development python qweb	0 Des 24	1074

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!