Cash Flow Worksheet Recalculation

Any of the following changes makes the calculated results obsolete or out of sync with the worksheet and some or all of the line items must be recalculated:

These conditions require recalculation of the worksheet:

• When anything other than the description is changed on a data source definition.

• When such things as the data source, reverse sign, filter, or ChartField value set are changed for an element.

• When new effective dated rows are added to an element.

• When changes are made to ChartField trees used in ChartField value sets.

• When business unit trees used in the process scope are changed.

• When source data is updated.

For all the above changes, you are responsible for keeping track of the changes and knowing the cash flow impact.

The following require recalculation but because any change is made within the worksheet component a warning message is issued if the changes affect rows that exist in the FR_WORKSHT_GRID and you are asked by the system if output data should be revised:

• When worksheet line items are deleted from the worksheet.

• When line items are changed to reference a different element.

• When a derived line item is changed for its deriving source.

• When the worksheet as of date is changed.

• When worksheet process options, such as ledger set, TimeSpan, rate type are changed.