Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To prevent committing returns if the effective date falls on or before inception date or after termination date:

  1. Select the Report Rule or Field Rule used by the Performance Returns report.

  2. Do one of the following:
    In the Report Rule workspace, select the Specify the Commit Tolerance and Reference Fields link. The Specify Commit Tolerance and Reference Fields dialog box appears. See the following figure.

...

  1. Specify Commit Tolerance and Reference Fields Dialog BoxImage Added

    Otherwise, if you are building a Field Rule, these fields appear in the middle of the Field Rule dialog box in the Specify Inception and Termination Date Fields section.

  2. In the Do not Commit Returns On or Before field, either select:
    The entity's inception date field to activate the inception date check, and prevent the commit process from committing returns with effective dates that are less than or equal to the entity's inception date, identified by the selected field. You can select the default value, i Entity Inception Date, an internal field that uses the INCEPTION_DATE column in the Entity table, or can select any date format field from the Entity table or the Entity History table. For example, you can select eglEnt-EntityInceptionDate.
    If the Performance Calculation report's end effective date is less than or equal to the inception date for that entity, the system commits no returns at any level for that entity and effective date. If the entity has no inception date set, the system commits no returns at any level for that entity and effective date.
    <none> to omit use of the inception date check. This allows the commit process to commit returns with effective dates that are less than or equal to the entity's inception date.

  3. In the Do not Commit Returns After field, either select:
    The entity's termination date field for use as the termination date check. This prevents the commit process from committing returns with effective dates that are greater than the entity's termination date, identified by the selected field. You can select the default value, Entity Termination Date, an internal field that uses the TERMINATION_DATE column in the Entity table, or can select any date format field from the Entity table or the Entity History table.

    For example, you can select eglEnt-EntityTerminationDate. If the Performance Calculation report's end effective date is greater than the termination date for that entity, the system commits no returns for that entity and effective date. If the entity has no termination date set, the system commits returns as if you were not using the termination date check. 
    <none> if you do not want to use the termination date check. This allows the commit process to commit returns with effective dates that are greater than the entity's termination date.