SAP Knowledge Base Article - Public

2699296 - Migration of Accounting Transaction Data Cross-Check Balances - The balance of the migration reconciliation account is not zero

Symptom

While migrating Accounting Transaction data, on the Cross-Check Balances step, the following warning appears: "The balance of the migration reconciliation account is not zero. Correct data and restart simulation".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Find Migration of Accounting Transaction Data activity.
  4. Press Open.
  5. Press Migrate accounting transaction data using the migration tool.
  6. Select the respective Migration Unit.
  7. Press Cross-Check Balances Preview.

A warning appears: "The balance of the migration reconciliation account is not zero. Correct data and restart simulation."

Cause

Such warnings appear whenever the balance on the Migration Clearing Account is not zero: The balances maintained in the G/L Accounts migration template do not tally with the amounts derived for these G/L accounts from the Subledger Migration template

Resolution

To analyse where exactly differences exist navigate to the Cross-Check Balances Preview:

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Find Migration of Accounting Transaction Data activity.
  4. Press Open.
  5. Press Migrate accounting transaction data using the migration tool.
  6. Select the respective Migration Unit.
  7. Press Cross-Check Balances Preview.

From here check the balances on the Migration Clearing Accounts, for example

  • Initial Data Carryforward A/R Accounts
  • Initial Data Carryforward A/P Accounts
  • Initial Data Carryforward Inventory Account
  • Initial Data Carryforward Asset Account
  • Initial Data Carryforward Cash Account

etc..

For these Accounts, the LC Amount should display zero, as, ideally, the amounts posted to the Migration Clearing Account from the G/L Account Migration template and from the Subledger Migration template should clear to zero.

If there is an amount higher than zero, the warning will appear.

Example: 

Let's assume there is an amount of 500,00 EUR appearing on the Migration Clearing Account for Fixed Assets, here Initial data Carryforward Asset Account.

  1. In the Cross-Check Balances Preview extend the Migration Clearing Account.
  2. For each G/L Account of type Fixed Assets, here G/L Account AAA a line is displayed showing the amount maintained for the account in the G/L Accounts Migration template (AAA represents the G/L Account ID).
  3. Check the Amounts displayed in the LC Amount column for the Account IDs displayed in the Source column:Posting_Preview.png
  4. Then click on the Fixed Assets link in the Source Column.
  5. In the next screen you see the amounts and G/L Accounts derived from the Fixed Assets Migration template:PostingPreview_Fixed Assets.png
  6. Compare these amounts with the amounts displayed for the G/L Account Migration and then make the respective adjustments, either correct the amounts in the G/L Migration template or correct the amounts for the specific items, such as Inventory IDs, Invoice IDs etc. in the subledger template.
  7. If the Migration is already finished you might have to either execute further migration for the missing data.
  8. It might also be possible to reverse migrated Accounting Transaction Data, by reversing the respective source documents. Please see KBA 2107052-Mass Reversal of Incorrect Migrated Financial Data.

See Also

2107052 - Mass Reversal of Incorrect Migrated Financial Data

Keywords

migration, migration tool, warning, The balance of the migration reconciliation account is not zero, Initial Data Carry Forward, difference, balance , KBA , balance , migration , cross-check balances , difference , the balance of the migration reconciliat , correct data and restart simulation , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions

Attachments

Posting_Preview.png