Ok, I've found my mistake.
analytic_distribution is a json
The right code is :
for record in records:
analytic_account_id=record.x_studio_compte_analytique.id
for line in record.order_line:
line['analytic_distribution']={str(analytic_account_id): 100.0}
Hi Emmanuel,
I’ve set up the analytic distribution with the following structure:
Project
Department
Branch
Location
Now, I want to automate the analytic distribution such that whenever a record is created and a customer is selected on the sale order, the Location (point 4) in the distribution should be automatically populated.
I’ve written logic that fetches the location-related analytic account from the customer and adds it to the sale order’s analytic distribution. However, the issue is that it's currently being added under 1. Project instead of 4. Location.
Do you have any idea how we can specifically target the 4th column (Location) in the analytic distribution?
Thanks in advance!
Best regards,
To automate analytic distribution in purchase orders, ensure you're using the correct syntax to update One2many fields. In your code, analytic_distribution should be written as a write operation on line, not dictionary-style assignment. Try this:
for record in records:
tag_ids = [record.x_studio_compte_analytique.id]
for line in record.order_line:
line.write({'analytic_distribution': [(6, 0, tag_ids)]})
Also, make sure analytic_distribution is a Many2many field. This approach correctly assigns the analytic tag to each line. Test it on sample data to confirm it updates as expected.