SAP Knowledge Base Article - Public

3395218 - Error 'Duplicate source records detected for the following values' during Migration of Accounting Transaction Data: G/L Account Balances

Symptom

You are trying to migrate G/L Account Balances and encounter below error messages:

Data inconsistency detected on sheet 'Account Balances'

Duplicate source records detected for the following values

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center
  2. Search for Activity Migration of Accounting Transaction Data and open Migration Unit in question
  3. Migration object G/L Account Balances and Below Error is seen

Data inconsistency detected on sheet 'Account Balances'
Duplicate source records detected for the following values

 

Cause

The same G/L with multiple Line-item currencies is not allowed for the combination of the below combination.

Company ID | Set of Books ID | G/L account | Company Currency

Resolution

The use case is not allowed now and the same has to be raised in the influence forum.

https://influence.sap.com/sap/ino/#/campaign/886

Keywords

Line-item currency, Migration of accounting data, G/L account Balance , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign 2311