Skip to Content
Menu
This question has been flagged
2 Replies
1932 Views

Dear Odoo Community

I kindly need your urgent help. I currently have >150 Landed Costs in Draft Stage for which all cost lines use the Split Method "Equal". 

Can someone please advise how to write an expression in an automated/server action to update all cost lines to "By Current Cost"? That would save me a lot of time otherwise I would have to go in one by one and change it. 


Many thanks!


Manuel

Avatar
Discard
Best Answer

Hello Manuel,

I have written a scheduled action which should achieve what you are after.

# get all in draft stage and have the split_method equal
all_items = env["stock.landed.cost.lines"].search(["&", ("cost_id.state", "=", "draft"), ("split_method", "=", "equal")])

for item in all_items:
    item["split_method"] = "by_current_cost_price"

I would suggest trying this on some test data first, as I have only tested this briefly. 

Thanks, 

Avatar
Discard
Author Best Answer

@Jack Dane


Perfect! Works like a charm! Thanks so much for your super fast and spot on help.

Avatar
Discard
Related Posts Replies Views Activity
1
Oct 24
133
0
Mar 15
2530
0
Jun 24
196
1
Jun 24
312
3
Jun 23
1294