I get records in record.department_id.id. These records have record.price_subtotal. I need to add record.price_subtotal if they have the same record.department_id.id. How do I do this with the .get() method And output it to the xml

At the moment the records CPA =50 and CPA =500. and I need one record 'CPA' and total_amount_interim = 100

if not reconciliation_act_id:
    self.env["alfaleads.accounts.receivable"].create({"reconciliation_act_id": self.id})

    for record in self.reconciliation_act_line_ids:
        if record.department_id.id:
            vals = {
                "department_id": record.department_id.id,
                "total_amount_interim": record.price_subtotal,
                "account_receivable_id": self.accounts_receivable_id.id,
            }
            self.env["alfaleads.accounts.interim.total"].create(vals)
else:
    for record in self.reconciliation_act_line_ids:
        if record.department_id.id:
            reconciliation_act_id.write({'alfaleads_accounts_department_total_ids': [(0, 0, {
                            "department_id": record.department_id.id,
                            "total_amount_interim": record.price_subtotal,
                            "account_receivable_id": self.accounts_receivable_id.id})]})

Hi StCrownClown,

Step 1: You create a function when click on the save button  

https://www.odoo.com/forum/help-1/question/how-to-recall-some-certain-function-when-click-save-button-in-creating-form-105059#answer-105183

Step 2: Create a loop of one2many field inside the function

Step 3: Seperate the list of unique and duplicate sale order line ids to the variable

ids= []
duplicate_ids = []
for line_id in self.order_line:
    if line_id.product_id.id in ids:
        duplicate_ids.append(line_id.id)
    else:
        ids.append(line_id.id)

Now you can get the all sale order line unique ids in ids and all duplicate ids in duplicate_ids.

Step 4: You add the Qty of duplicate_ids to the corresponding line in ids.

self.env['sale.order.line'].search([('id', '=', id_in_ids)]).write({'product_uom_qty': qty_new_value,})

Step 5:

     Delete sale order lines in duplicate_ids

for duplicate_id in duplicate_ids:
     self.env['sale.order.line'].search([('id', '=', id_in_ids)]).unlink()

Note : My code is not tested, I wrote it for help

All the best !

any idea ?

:)