Payment Application Grid Column Total

The following information is related to BP run-time only for the Payment Applications and Summary Payments Applications Business Processes (Standard tab). For Payment Applications and Summary Payments Applications, when you add, modify, or reset a grid line, the Total row displays values according to the Total property configured for the data elements (DEs) in uDesigner:

  • Blank: The system displays the value as empty in the Total Column (that particular DE column).
  • Sum of All Rows: The system displays the value as "Sum of All Rows" in the Total Column.
  • Use Formula Definition: The system displays the value as "Formula Defined" in the Total Column. In other words, the system calculates the formula by using the values from the Total row for the respective DEs.

When you reset a line, the system immediately recalculates the Total row and any dependent formula-based values using the remaining line data. If Reset removes a new line, that line no longer contributes to totals. If Reset restores an edited saved line, the totals reflect the restored saved values.

If the formula was reset to Manual, the system resets the Total to "Sum of All Rows."

The system calculated the Total, for DEs with predefined formula, as follows:

  • %Complete to Date (uuu_spa_per_comp)
    • Custom formula

      Based on the whether the property is enabled.

    • System-defined formula

      Based on whether the property is enabled.

  • Amount This period (uuu_spa_amt_tp)

    Based on whether the property is enabled. (Either Blank or Sum of All Rows)

    Note:

    With version 23 and later, a Total row on a non-standard tab of a line item grid is not displayed. For version 22 and earlier, the Total row displays a 0.