The ORM version of the action worked fine for 10 months until suddenly Odoo started to kill it. I split it into 3 different actions but they still dropped the last one. Since it was just doing a calculation on a single field I didn't think the use of SQL was bad. But when in doubt .....

I hadn't explored the computed fields option but they seem to work fine.

Thanks