ECMT AIM - Default Value

Default Values can either be static::

Open

Or calculable:

Open

This means that this field, LINE TOTAL, will have a default value of

<INVOICE TOTAL> - <LINE TOTAL>

<INVOICE TOTAL> in this scenario is a Header Field. The value is equal to the value in header field with name <INVOICE TOTAL>.

<LINE TOTAL> in this scenario is a Detail Field. The value is equal to the sum of values in the detail fields <LINE TOTAL>.

We start with a Header Field <INVOICE TOTAL>, with value $100.00

There are no rows present so the default row defaults to a LINE TOTAL value of $100.00

Editing this value to 20.00, will cause the newly created default row to have a default value of

<INVOICE TOTAL> minus the sum of the <LINE TOTAL> in the rows, 100 – 20, or 80. Adding another row of 20, will create a default row of 100 – 20 – 20, or 60: