SAP Financial Consolidation Web User Guide

Resolving data conflicts

If changes have been made to your package outside your locally enhanced workbook, there may be a difference between:

  • an amount stored in SAP Financial Consolidation.
  • the locally enhanced total in the EWS schedule.

This leads to conflicting data being produced. This conflict can be dealt with in the EWS schedules.

This difference is highlighted on screen as follows:

  • In the schedule's cells, the amount where a difference has been found appears against a red background.
  • In the cell's properties box, the difference is indicated by a warning sign. The application will propose various solutions depending on the actual problem.

Example of when differences are found:

  • An amount in SAP Financial Consolidation is calculated using an Excel formula, for example a formula referenced to other Excel cells. The Excel formula is looked upon as a local modeling enhancement.

Example: Data conflict

A supervisor is responsible for overseeing the data entry performed by three other users. He/she can change the amounts entered by the other three if it is judged necessary. One of the users called Jim has entered a line item detail locally, which the supervisor cannot see. The total, which the supervisor can see, is 10 000. The supervisor does not think the total entered is correct and changes it to 12 000, and asks Jim to make changes to his schedule. Jim opens his schedule. He looks at the amounts entered locally and the new total entered by the supervisor. The total of the line item detail (3 000 + 7 000) does not correspond to the new total. There is therefore a difference between the amount stored in SAP Financial Consolidation and the amount stored locally.

Example: Solving the problem

The cell's properties box indicates that The amount is different from the line item detail total. It proposes the following solutions:

  • Driver not currently applied. Apply driver. This enables you to keep the previous amount and to reanalyze the data accordingly.

  • Amount = XXX. Spread this amount. This will lead to the existing amounts being spread on a pro-rata basis.

  • Line item detail total = YYY. Use this total. This enables the user to keep the total that he/she calculated.

  • Variance = ZZZ. Manually change line item detail. This message suggests that the user should enter the line item detail again.