SAP Knowledge Base Article - Public

2107052 - Mass Reversal of Incorrect Migrated Financial Data

Symptom

You have incorrectly migrated the financial data. Now you would like to remove the migrated data to enable a new financial data migration.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Select the Implementation Projects view.
  3. Select your implementation project and click Open Activity List.
  4. Search and open the activity Migration of Accounting Transaction Data.
  5. Click Migrate accounting transaction data using the migration tool.
  6. Select Migration of Open Items Payable/Receivable.
  7. Click Execute Migration.
  8. Select your uploaded migration file and click Process File.
  9. After Migration, you realized that data was incorrect and there is no way to remove the migrated data.

Cause

The removal of migrated data is not possible (this fact is described in a popup that has to be confirmed before you can start any data import). However, you can reverse all the migrated journal entries.

Resolution

We suggest following alternative approaches how you could move forward:

  1. Falling back to the latest restore point (in case you had ordered any, for example, before starting with data migration).
  2. Starting over with a fresh production system.
  3. The migration postings can be reversed for each Journal entry.
    This can be done by reversing the accounting notification.
    One General Ledger->View Journal Entries
    Select the JE for the source document ID from the receivables
    upload. On the You can Also -> Click View business transaction - >View All

    The screen "Business Transaction for Accounting" opens up where you see Reverse Button
    On click of the button, the JE and the open Item on Customer Account Monitor(viewed on Customers->Customer accounts) will be reversed.

    The benefit of the strategies (1a) and (1b) are at hand, no redundant financial postings in the system, but of course this has a stronger impact onto your project plan. In case you are opting for (2), please test whether reversal of journal entries are sufficient for your business processes.

    In any case we recommend testing the migration in a test system before migration to your production system. This applies also to any objects that you are planning to migrate in the upcoming days.

 

Keywords

KBA , AP-SIP , Supplier Invoice Processing , How To

Product

SAP Business ByDesign all versions