SAP Knowledge Base Article - Public

3564117 - Error - Financial data missing for customer and company occurs during Migration of Accounting Transaction Data for Open Item Receivables

Symptom

  • During the migration of Open Item Receivables, an error is detected in the Simulate Import step.
  • The error message indicates as below mentioned.

Error Log:

Error detected in source record with key value 
Financial data missing for customer 'ABC' and company 'DEF'

ABC refers to customer ID.
DEF refers to company ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Business Configuration work center.
  2. Go to the Overview sub view.
  3. Search for the activity Migration of Accounting transaction Data and select it.
  4. Choose Migrate accounting transaction data using the migration tool.
  5. Select Open Items receivable for the specific company.
  6. Execute Migration.
  7. While attempting Simulate Import step, error occurs as mentioned below.

Error detected in source record with key value 
Financial data missing for customer 'ABC' and company 'DEF'

Cause

The error occurs due to a discrepancy between the Account ID in the source value and the target value during the migration process. The system identifies a different Account ID as the Target ID, leading to the error.

Resolution

  1. Go to the Business Configuration work center.
  2. Navigate to the Overview sub view.
  3. Search for the activity Migration of Accounting transaction Data and select it.
  4. Choose Migrate accounting transaction data using the migration tool.
  5. Select Open Items receivable for the specific company.
  6. Proceed to the step Convert values.
  7. Select the task edit value conversion for account ID.
  8. Change the target value from the incorrect ID to the correct ID as the source value.
  9. Confirm all and save the changes.
  10. Now the error won't occur while simulating the Import step.

Keywords

Migration, Accounting Transaction Data, Open Item Receivables, Financial Data Missing, Business Partner Account ID, Discrepancy, Convert Values, Target Value. , KBA , SRD-FIN-ACR , Receivables , Problem

Product

SAP Business ByDesign all versions