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, as follows:

  • Open General Ledger work center -> Journal Entries view.
  • Select the journal entry for the source document ID from the receivables upload.
  • Click You can Also -> View Business Transaction for Accounting -> View All.
  • The screen "Business Transaction for Accounting" opens up where you see Reverse button.
  • By clicking the button, the journal entry and the open item in Customer Account Monitor (viewed on Receivables work center -> Customers view -> Customer Accounts subview) will be reversed.

The benefit of the strategies (1) and (2) 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 (3), please test whether reversal of journal entries is sufficient for your business processes. In any case we recommend testing the migration in a test system before doing the migration in your production system. This applies also to any objects that you are planning to migrate in the upcoming days.

Keywords

Migration of Accounting Transaction Data; journal entries; reverse , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions