Accounting RollforwardFX & CSV Version - Support Advisory

Issue

Takedown entries for modified deals reflect as ‘Additions’ Entry Type instead of ‘Remeasurement:Modification’ Entry Type.

When could the issue manifest?

When generating either the Accounting Rollforward(FX) or Accounting Rollforward(FX) – CSV report.

How does the issue manifest?

The Entry Type for the takedown entries on modified deals appear as Additions and will subsequently appear in the Additions section of the pivot table on the Accounting Rollforward(FX) report. The CSV version currently does not include a pivot table.

Recommended Solution

On the ALL tab of the report, identify any new modifications within the reporting period by looking for “-M00x” schedules that have JEShortDesc = “CapOp Modification Takedown”. Locate the full journal entry related to the modification including both the original and “-M00x” schedule. Under the Entry Type column, replace the ##. Additions text with the ##. Remeasurement: Modification text.

In the example below, the first three rows are the writeoff entries for the original schedule (properly referring to Remeasurement: Modification). The 4th and 5th rows are the takedown entries for the “-M00x” deal and are incorrectly reflecting Additions. Text from one of the first three rows in this column can be copy/pasted to the 4^th and 5^th rows.

Note: It is important to include the preceding two-digit number, decimal and space before the text so that the data feeds the pivot table correctly.

The pivot table will need to be refreshed.