Hi! for the customized column, are you able to make it a calculating one? Make the column a retention and then have it automatically calculate a retention? i.e.
[qty] [rate] [total] [5% retention] [total due for period]
2 $100 $200 -$10 $190
