Solutions:
Check these solutions from our community and artificial intelligence:
The trigger will automatically update the customer's balance field whenever a new purchase is made, which is the desired outcome. The approach is sound and the trigger is executed only when needed, so this is a good solution.