Bỏ qua để đến Nội dung
Câu hỏi này đã bị gắn cờ
one2manyreportinginvoicingOdoo13.0
2 Trả lời
5546 Lượt xem
Ảnh đại diện
Suhaib Ahmed Khateeb

I have created a custom report for invoice summary, i can easily fetch the header part of the invoice line invoice date, partner name etc.. But when it comes to invoice lines I am unable to fetch the data.

Please check this code out

for invoice in invoice_objs:
    invoice_date = invoice.invoice_date.strftime('%Y-%m-%d') /correct
    worksheet.write(row, 0, invoice_date)   /correct
    worksheet.write(row, 1, invoice.name)    /correct
    worksheet.write(row, 2, invoice.partner_id.name)        
    for product_id in account.move.line:
         worksheet.write(row, 3, invoice_line_ids.product_id.name) 


I am getting error in the last 3 lines of the code

can anyone suggest how to fetch data from a one2many field in odoo13

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Ibrahim Boudmir
Câu trả lời hay nhất

Hi Suhaib, 

For your question, did you try: 

worksheet.write(row, 3,  ', '.join(invoice.invoice_line_ids.mapped('product_id.name'))

of course, you don't need iteration on products when you use this code.

P.S: 
I think you code is incorrect: Because your second iteration will erase the first inserted data. ( you're always pointing at row, unless, hopefully, you tell me row is incremted and not shown here ^^ ) 



------------- UPDATE ---------------
Since you want to put each product in each line in case you have multiple products in sale order, please consider the following: 

In Odoo, you can export a sale order with Order lines/product Column and you can check the result in generated Xls. You will notice that in this case, odoo creates a new empty line and only adds name of article => This is how we import O2M fields in odoo. 

if len(invoice.invoice_line_ids) > 1:
    worksheet.write(row,3, invoice.invoice_line_ids[0].product_id.name)
    for product_id in invoice.invoice_line_ids[1:]:
        row +=1
        worksheet.write(row, 3, product_id.name)

------------- END of UPDATE ---------------
Hope this helps. 
You can write me back if not for further analysis.

Regads.

Ảnh đại diện
Huỷ bỏ
Suhaib Ahmed Khateeb
Tác giả

Yes Ibrahim row is incremented I used row+=1

Suhaib Ahmed Khateeb
Tác giả

Thanks Ibrahim it worked but partially, the products showing are in same line like you can see the second line under invoice description "betrillix,sample" those are two different products but showing in same line, how can I do them in two different lines?

Invoice Date Invoice Number Customer Invoice Description
2022-01-17 INV/2022/0001 Administrator Betrillix
2022-01-05 INV/2022/0003 My Company Betrillix, Sample
2022-01-03 INV/2022/0002 Administrator Betrillix

Ibrahim Boudmir

Well, i thought you wanted to add them in one cell.
So, what you need actually is the standard export of a O2M field based on product name only.
I ll update my answer.

Suhaib Ahmed Khateeb
Tác giả

Thanks Ibrahim but its coming like this
Invoice Date Invoice Number Customer Invoice Description
2022-01-17 INV/2022/0001 Administrator
2022-01-05 INV/2022/0003 My Company Betrillix
Sample
2022-01-03 INV/2022/0004 My Company
2022-01-03 INV/2022/0002 Administrator

Only the line with multiple products are visible not the single ones

Ibrahim Boudmir

i can't imagine the result of code. I need to see python code and excel file. if you send me these at my email, i probably can help better:
ibrahim.boudmir@gmail.com

Suhaib Ahmed Khateeb
Tác giả

Have mailed you
Thanks

Ibrahim Boudmir

if Ok for you, you can check my answer as the right answer.
Thanks

Suhaib Ahmed Khateeb
Done

On Mon, 24 Jan 2022, 10:30 pm Ibrahim Boudmir, <ibrahim.boudmir@gmail.com> wrote:

if Ok for you, you can check my answer as the right answer.
Thanks

Envoyé par Odoo S.A. utilisant Odoo.

Ảnh đại diện
Rahiya Basheer
Câu trả lời hay nhất

i have the same issues

def generate_xlsx_report(self, workbook, data, partners):
    bold = workbook.add_format({'bold': True, 'align': 'center'})
    format_1 = workbook.add_format({'bold': True, 'align': 'center', 'bg_color': 'cyan'})

    for obj in partners:
        sheet = workbook.add_worksheet(obj.customer_id.name)
        row = 3
        col = 3
        sheet.set_column('D:D', 12)
        sheet.set_column('E:E', 22)
        row += 1
        sheet.merge_range(row, col, row, col+1, 'Product Details', format_1)
        row += 1
        sheet.write(row, col, 'Customer', bold)
        sheet.write(row, col+1, obj.customer_id.name)
        row += 1
        sheet.write(row, col, 'Vendor', bold)
        sheet.write(row, col + 1, obj.vendor_id.name)
        row += 1
        sheet.write(row, col, 'Product', bold)
        sheet.write(row, col+1, ', '.join(obj.products_ids.mapped('name.name')))
        row += 1

i used the second last line to print the products. but actually that is not what i am expected. i need to print it like a table.


Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
Compute field in excel report Đã xử lý
reporting invoicing Odoo13.0
Ảnh đại diện
Ảnh đại diện
Ảnh đại diện
2
thg 1 22
3065
Addition of two fields in excel report
reporting invoicing Odoo13.0
Ảnh đại diện
0
thg 1 22
18
If Condition in excel report Đã xử lý
reporting invoicing Odoo13.0
Ảnh đại diện
Ảnh đại diện
1
thg 1 22
3236
Payment Method in Invoice Summary Report
pdf reporting invoicing Odoo13.0
Ảnh đại diện
0
thg 2 22
3259
Expected Singleton Error for excel report
reporting invoicing excel Odoo13.0
Ảnh đại diện
1
thg 2 22
61