Hello Managers,
For update balance to customers can have a calculateing field in invoice for latest balance update.
Have a field name previous balance
And 2nd field is total recievable.
Like this:-
(Invoice total+previous balance= total recievable)