The Balance Calculator can be used for complex balance calculations. It uses formulas and literal string replacer values to determine what amount should be charged.

1.From the
Tools menu, select Balance
Calculator. The Balance Calculator page appears.

2.In the Final Balance
field, enter in a formula to calculate the desired balance. If you have
collection grids set up, a formula field appears for each grid on the
form. To use the total value of the collection grid in the final balance,
create a formula specific to that grid to tell the form how to determine
its balance. Example